Hi,
i want my proc freq only to do counts and not percent.
so what i did was
PROC FREQ DATA=TEMP ORDER=FREQ NOPRINT;
TABLES X * Y / NOPERCENT OUT=TEMP2;
RUN;
but even though i mention no percent my out put is showing
X Y COUNT PERCENT
abc 123 2 40
I don't want the percent to be calculated.
Am i doing any thing wrong or is there any other option i have to use to suppress it.
;
If you don't want it in the output file, you can always just drop it. e.g.,
PROC FREQ DATA=sashelp.class ORDER=FREQ NOPRINT;
TABLES age * sex / OUT=TEMP2 (drop=percent);
RUN;
Hi Art,
Instead of droping it is there any way i can tell Proc Freq not to calculate Percent
Not that I'm aware of.
The ODS tables don't give the percent but they give a bunch of other columns that are probably just as useless, so dropping is your best option.
proc freq data=sashelp.class;
tables sex*age/ nopercent nocol norow out=temp2;
ods output crosstabfreqs=temp3;
run;
Hey Reeza,
Thanks for your reply.That's good to know.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.