Hi ,
I have used the below syntax to generate the table.
ODS html body='D:\SAS Project\Output\sample3.xls';
proc tabulate data=prac.parents;
format gender gender. c2_2 prefer.;
class age gender c2_2/mlf preloadfmt order=data ;
tables all='Base :All Respondents'*f=9.0*N='' c2_2=''*colpctn='' ,(all='Total' gender)*f=7.2;
run;
ODS html close;
Output :
Total | Gender | |||
Male | Female | |||
Base :All Respondents | 365 | 227 | 138 | |
Bottom2 Box[1/2] | 0.55 | . | 1.45 | |
[2] Somewhat unfavorable | 0.55 | . | 1.45 | |
[3] Neutral | 24.66 | 19.82 | 32.61 | |
[4] Somewhat favorable | 46.85 | 48.9 | 43.48 | |
Top2 Box[4/5] | 74.79 | 80.18 | 65.94 | |
[5] Very favorable | 27.95 | 31.28 | 22.46 |
Query : please explain syntax to delete the empty column before "Total" column.
Thanks
What empty column? It's not clear in the output what you mean.
Please search http://support.sas.com and this community for a solution before posting any new question in community.
Hi LinusH,
Please run the above code at your end with your dataset, to know the problem. If you look at the output , u will realize there is a empty col before "Total col" which is not reflected when pasted.
thanks
It looks like your extra column is the unlabeled N and COLPCTN statistic. The only way I see around this is to transpose the table. Make the columns contain Total, Male, and Female, for example. When blank statistic labels appear in the column dimension of the table, the label gets entirely removed.
Somebody else may come up with another way around this, or perhaps the transposed version is acceptable.
Good luck.
thanks
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.