------------------------------------------------------------------------------- log: e:\classb.log log type: text opened on: 13 Feb 2002, 15:19:54 . set mem 34m (34816k) . set more off . run "d:\temp\STD000000.tmp" . do "d:\temp\STD000000.tmp" . 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 salary hours Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 5 30 18.70829 10 60 hours | 5 9.6 8.648699 5 25 . 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 > . tabulate salary hours | hours salary | 5 6 7 25 | Total -----------+--------------------------------------------+---------- 10 | 1 0 0 0 | 1 20 | 1 0 0 0 | 1 30 | 0 1 1 0 | 2 60 | 0 0 0 1 | 1 -----------+--------------------------------------------+---------- Total | 2 1 1 1 | 5 . end of do-file . do "d:\temp\STD000000.tmp" . 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: . end of do-file . do test.do . 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 salary hours Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 5 30 18.70829 10 60 hours | 5 9.6 8.648699 5 25 . 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 > . tabulate salary hours | hours salary | 5 6 7 25 | Total -----------+--------------------------------------------+---------- 10 | 1 0 0 0 | 1 20 | 1 0 0 0 | 1 30 | 0 1 1 0 | 2 60 | 0 0 0 1 | 1 -----------+--------------------------------------------+---------- Total | 2 1 1 1 | 5 . end of do-file . run test . * generate, replace, egen . gen big=1 . drop big . gen big=0 . l tall tall 1. 4 2. 5 3. 5.5 4. 4.5 5. 6 . replace big=1 if tall=6 invalid syntax r(198); . replace big=1 if tall==6 (1 real change made) . l big tall big tall 1. 0 4 2. 0 5 3. 0 5.5 4. 0 4.5 5. 1 6 . gen logsal=log(salary) . egenerate unrecognized command: egenerate r(199); . egen invalid syntax r(198); . egen means=mean(s) . drop means . gen means=mean(s) Unknown function mean() r(133); . gen sums=sum(s) s ambiguous abbreviation r(111); . gen sumhours=sum(hours) . l hours sumhours hours sumhours 1. 5 5 2. 5 10 3. 6 16 4. 7 23 5. 25 48 . egen sumhours2=sum(hours) . l hours sumhours sumhours2 hours sumhours sumhours2 1. 5 5 48 2. 5 10 48 3. 6 16 48 4. 7 23 48 5. 25 48 48 . replace sumhours=sumhours2 (4 real changes made) . l hours sumhours sumhours2 hours sumhours sumhours2 1. 5 48 48 2. 5 48 48 3. 6 48 48 4. 7 48 48 5. 25 48 48 . summarize income if big==6 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 0 . summarize income big=1 invalid syntax r(198); . summarize income if big==1 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 1 100 . 100 100 . l big income big income 1. 0 100 2. 0 100 3. 0 300 4. 0 300 5. 1 100 . summarize income Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 5 180 109.5445 100 300 . l family salary family salary 1. 1 10 2. 1 20 3. 2 30 4. 2 30 5. 3 60 . l family person salary family person salary 1. 1 1 10 2. 1 2 20 3. 2 1 30 4. 2 2 30 5. 3 1 60 . summarize income if family==1 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 2 100 0 100 100 . by family: summarize income not sorted r(5); . sort family . by family: summarize income ______________________________________________________________________________ > _ -> family = 1 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 2 100 0 100 100 ______________________________________________________________________________ > _ -> family = 2 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 2 300 0 300 300 ______________________________________________________________________________ > _ -> family = 3 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- income | 1 100 . 100 100 . by family: summarize salary ______________________________________________________________________________ > _ -> family = 1 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 2 15 7.071068 10 20 ______________________________________________________________________________ > _ -> family = 2 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 2 30 0 30 30 ______________________________________________________________________________ > _ -> family = 3 Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 1 60 . 60 60 . *collapse . l family person family person 1. 1 1 2. 1 2 3. 2 1 4. 2 2 5. 3 1 . family person salary unrecognized command: family r(199); . l family person salary family person salary 1. 1 1 10 2. 1 2 20 3. 2 1 30 4. 2 2 30 5. 3 1 60 . collapse (mean) salary, by(family) . l family salary 1. 1 15 2. 2 30 3. 3 60 . clear . use data1 . collapse (sum) salary, by(family) . l family salary 1. 1 30 2. 2 60 3. 3 60 . collapse (sum) salary . l salary 1. 150 . save invalid file specification r(198); . save collapse file collapse.dta saved . exit