Of course yes. Those are exactly the percentages that I need for four combinations of sex and status. I am calculating these % s seperately in Excel (manualy) which takes ages.
However, following program does not generate it.
proc freq data=food;
by sex ;
tables status /nocum out=food1;
Could you please help. Besides, it should be 'proc surveyfreq' and not just 'proc freq' as I am trying to generate estimates for entire population. And shouldn't the the third statement include status*sex as I am estimating the cross tabs?
And if you want to get the percentages of each 'status' within a 'sex' group seperately. That means only one way, I think you can only define status in table statement. Otherwise status*sex should be two ways.
As my understanding you have to write table statements twice, one for one way percentage calculation, and the other one fore getting estimates. Like below..