-------------------------------------------------------------- log: e:\class.log log type: text opened on: 11 Feb 2002, 15:19:59 . set memory 34m (34816k) . input family person salary hours family person salary hours 1. 1 1 10 5 2. 1 2 20 5 3. 2 1 30 6 4. 2 2 30 7 5. end . set memory 34m no; data in memory would be lost r(4); . edit - preserve - sort person - drop in 4 - restore - preserve . list family person salary hours 1. 1 1 10 5 2. 1 2 20 5 3. 2 1 30 6 4. 2 2 30 7 . l family person salary hours 1. 1 1 10 5 2. 1 2 20 5 3. 2 1 30 6 4. 2 2 30 7 . save data1.dta file data1.dta could not be opened r(603); . save e:\data1.dta file e:\data1.dta saved . cd e:\ e:\ . dir *.dta 1103.7k 2/05/02 14:54 family.dta 9563.1k 2/05/02 14:55 Person.dta 0.8k 2/11/02 15:33 data1.dta . dir e:\*.dta 1103.7k 2/05/02 14:54 family.dta 9563.1k 2/05/02 14:55 Person.dta 0.8k 2/11/02 15:33 data1.dta . clear . input family person salary hours family person salary hours 1. 3 1 60 25 2. end . l family person salary hours 1. 3 1 60 25 . save data2.dta file data2.dta saved . append using e:\data2.dta . l family person salary hours 1. 3 1 60 25 2. 3 1 60 25 . append using e:\data1.dta . l family person salary hours 1. 3 1 60 25 2. 3 1 60 25 3. 1 1 10 5 4. 1 2 20 5 5. 2 1 30 6 6. 2 2 30 7 . edit - preserve - drop in 1 - preserve . l family person salary hours 1. 3 1 60 25 2. 1 1 10 5 3. 1 2 20 5 4. 2 1 30 6 5. 2 2 30 7 . save invalid file specification r(198); . save, replace file data2.dta saved . save data1.dta file data1.dta already exists r(602); . save, replace data1 data1 invalid r(198); . save data1, replace file data1.dta saved . l family person salary hours 1. 3 1 60 25 2. 1 1 10 5 3. 1 2 20 5 4. 2 1 30 6 5. 2 2 30 7 . clear . input family income family income 1. 1 100 2. 2 300 3. 3 100 4. 4 300 5. end . save data3 file data3.dta saved . merge family using data1 master data not sorted r(5); . sort family . save, replace\ \ invalid r(198); . save, replace file data3.dta saved . clear . use data1 . l family person salary hours 1. 3 1 60 25 2. 1 1 10 5 3. 1 2 20 5 4. 2 1 30 6 5. 2 2 30 7 . sort family . l family person salary hours 1. 1 2 20 5 2. 1 1 10 5 3. 2 1 30 6 4. 2 2 30 7 5. 3 1 60 25 . merge family using data3 . l family person salary hours income > _merge 1. 1 2 20 5 100 > 3 2. 1 1 10 5 100 > 3 3. 2 1 30 6 300 > 3 4. 2 2 30 7 300 > 3 5. 3 1 60 25 100 > 3 6. 4 . . . 300 > 2 . list family person salary income family person salary income 1. 1 2 20 100 2. 1 1 10 100 3. 2 1 30 300 4. 2 2 30 300 5. 3 1 60 100 6. 4 . . 300 . list family person salary income _merge family person salary income _merge 1. 1 2 20 100 3 2. 1 1 10 100 3 3. 2 1 30 300 3 4. 2 2 30 300 3 5. 3 1 60 100 3 6. 4 . . 300 2 . drop _merge . edit - preserve - restore . edit - preserve - drop in 6 . l family person salary hours income 1. 1 2 20 5 100 2. 1 1 10 5 100 3. 2 1 30 6 300 4. 2 2 30 7 300 5. 3 1 60 25 100 . save data1, replace file data1.dta saved . input family person tall family already defined r(110); . clear . input family person tall family person tall 1. 1 1 4 2. 1 2 5 3. 2 1 5.5 4. 2 2 4.5 5. 3 1 6 6. end . merge family person using data1 master data not sorted r(5); . sort family person . l family person tall 1. 1 1 4 2. 1 2 5 3. 2 1 5.5 4. 2 2 4.5 5. 3 1 6 . save data4 file data4.dta saved . clear . use data1 . l family person salary hours income 1. 1 2 20 5 100 2. 1 1 10 5 100 3. 2 1 30 6 300 4. 2 2 30 7 300 5. 3 1 60 25 100 . sort family person . l family person salary hours income 1. 1 1 10 5 100 2. 1 2 20 5 100 3. 2 1 30 6 300 4. 2 2 30 7 300 5. 3 1 60 25 100 . merge family person using data4 . drop _merge . save, replace file data1.dta saved . l family person salary tall family person salary tall 1. 1 1 10 4 2. 1 2 20 5 3. 2 1 30 5.5 4. 2 2 30 4.5 5. 3 1 60 6 . graph salary . graph using graph1 . graph salary . graph using graph1 . graph salary, hist . graph salary, bin(2) . graph salary tall . graph salary tall, (saving graph3) ( invalid r(198); . graph salary tall, saving (graph3) . graph using graph3 . graph salary tall, c(ll) . sort tall . graph salary tall, c(ll) . . clear . use data1 . describe Contains data from data1.dta obs: 5 vars: 6 11 Feb 2002 15:59 size: 140 (100.0% of memory free) --------------------------------------------------------------- > ---------------- storage display value variable name type format label variable label --------------------------------------------------------------- > ---------------- family float %9.0g person float %9.0g salary float %9.0g hours float %9.0g income float %9.0g tall float %9.0g --------------------------------------------------------------- > ---------------- Sorted by: . summarize Variable | Obs Mean Std. Dev. Min > Max -------------+------------------------------------------------- > ---- family | 5 1.8 .83666 1 > 3 person | 5 1.4 .5477226 1 > 2 salary | 5 30 18.70829 10 > 60 hours | 5 9.6 8.648699 5 > 25 income | 5 180 109.5445 100 > 300 tall | 5 5 .7905694 4 > 6 . summarize Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- family | 5 1.8 .83666 1 3 person | 5 1.4 .5477226 1 2 salary | 5 30 18.70829 10 60 hours | 5 9.6 8.648699 5 25 income | 5 180 109.5445 100 300 tall | 5 5 .7905694 4 6 . summarize salary Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 5 30 18.70829 10 60 . tabulate salary salary | Freq. Percent Cum. ------------+----------------------------------- 10 | 1 20.00 20.00 20 | 1 20.00 40.00 30 | 2 40.00 80.00 60 | 1 20.00 100.00 ------------+----------------------------------- Total | 5 100.00 . tabulate salary tall | tall salary | 4 4.5 5 5.5 6 | Total -----------+-------------------------------------------------------+---------- 10 | 1 0 0 0 0 | 1 > 20 | 0 0 1 0 0 | 1 > 30 | 0 1 0 1 0 | 2 > 60 | 0 0 0 0 1 | 1 > -----------+-------------------------------------------------------+---------- Total | 1 1 1 1 1 | 5 > . summarize salary, detail salary ------------------------------------------------------------- Percentiles Smallest 1% 10 10 5% 10 20 10% 10 30 Obs 5 25% 20 30 Sum of Wgt. 5 50% 30 Mean 30 Largest Std. Dev. 18.70829 75% 30 20 90% 60 30 Variance 350 95% 60 30 Skewness .7683612 99% 60 60 Kurtosis 2.5 . regress salary hours tall Source | SS df MS Number of obs = 5 -------------+------------------------------ F( 2, 2) = 12.97 Model | 1299.79606 2 649.898029 Prob > F = 0.0716 Residual | 100.203943 2 50.1019714 R-squared = 0.9284 -------------+------------------------------ Adj R-squared = 0.8569 Total | 1400.00 4 350.00 Root MSE = 7.0783 ------------------------------------------------------------------------------ salary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- hours | 1.4276 .5836078 2.45 0.134 -1.083461 3.938662 tall | 8.864718 6.384573 1.39 0.299 -18.60588 36.33532 _cons | -28.02855 28.38026 -0.99 0.427 -150.139 94.08187 ------------------------------------------------------------------------------ . test hours=0 ( 1) hours = 0.0 F( 1, 2) = 5.98 Prob > F = 0.1343 . test hours ( 1) hours = 0.0 F( 1, 2) = 5.98 Prob > F = 0.1343 . test hours=tall ( 1) hours - tall = 0.0 F( 1, 2) = 1.19 Prob > F = 0.3890 . test hours=0 tall=0 invalid 'tall' r(198); . test hours tall ( 1) hours = 0.0 ( 2) tall = 0.0 F( 2, 2) = 12.97 Prob > F = 0.0716 . testparm hours tall ( 1) hours = 0.0 ( 2) tall = 0.0 F( 2, 2) = 12.97 Prob > F = 0.0716 . summarize salary Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 5 30 18.70829 10 60 . test salary salary not found r(111); . exit