Hello, i created a table, where i have 5 variables and 10000 observations (showing here only 10 of them). Now i want to have the number of people whose turnover is above average. data WORK.TABELLE;
infile datalines dsd truncover;
input name:$30. prename:$30. plz:$5. birthday:DATE9. tunrover:32.;
format birthday DATE9.;
datalines;
Schmidt Emma 48951 30SEP1966 44805
Schmidt Emma 84453 17SEP1953 58865
Schmidt Emma 76142 08DEC1988 10980
Schmidt Emma 77190 07OCT1990 83461
Schmidt Emma 31853 28APR1997 63172
Schmidt Emma 54647 08MAY1977 72697
Schmidt Emma 90476 01JAN1962 1924
Schmidt Emma 31518 25AUG1996 24680
Schmidt Emma 91016 08FEB1971 37587
Schmidt Emma 22758 25JUN1996 67124 I tried it with proc means mean and then a data step with if turnover>average. But the answer is 10000, which is obviously wrong. Thank you for help!
... View more
