I have to work with Stata. I got all my necessary data in Excel, but when I import them into Stata some data will be shown (as with the sum command) and some will be no observations or not found . I get these outputs
. summarize Variable | Obs Mean Std. Dev. Min Max total_assets | 2576 66822.33 236144.5 630.8 2573126 employees | 2570 67.61437 160.5821 .175 2200 changeofwo~e | 0 employeedo~g | 0 netincome | 2575 1683.551 4054.371 -99289 26895 revenue | 2575 22475.59 40565.01 -4234.472 483521 ROA | 2576 .0607231 .0734222 -.8526002 .5033718 changeinROA | 0 L | 0 M | 0 . describe Contains data obs: 2,577 vars: 13 size: 224,199 ----------------------------------------------------------------------------- storage display value variable name type format label variable label firm_ID int %10.0g firm_ID gvkey long %10.0g gvkey fiscal_year int %10.0g fiscal_year total_assets double %10.0g total_assets employees double %10.0g employees changeofworkf~e str18 %18s change of workforce employeedowns~g str1 %9s employee downsizing netincome double %10.0g netincome revenue double %10.0g revenue ROA double %6.4f ROA changeinROA str18 %18s change in ROA L byte %10.0g M byte %10.0g - Sorted by: Note: dataset has changed since last saved . sum ROA Variable | Obs Mean Std. Dev. Min Max ROA | 2576 .0607231 .0734222 -.8526002 .5033718 . sum changeofworkforce Variable | Obs Mean Std. Dev. Min Max changeofwo~e | 0 . tab downsizing downsizing | Freq. Percent Cum. ------------+----------------------------------- 0 | 2,168 84.19 84.19 1 | 407 15.81 100.00 ------------+----------------------------------- Total | 2,575 100.00