topic Re: Proc Freq & Proc Mean in SAS Programming

Proc Freq & Proc Mean

leeleelee — Wed, 06 Oct 2021 19:10:34 GMT

Hi, I currently have a proc freq macro.
How do I separate these into separate proc freq's for each variable?

Note: I have 13 categorical variables and 2 numerical variables.

/*looping through all categorical variables for proc freq exports*/
%macro freq_loop;
%Do i=1 %to &num_cats.;
	%let j=%scan(&cat_vars.,&i.);

proc freq data=&filetype._stacked order=freq; 
	table &j. / out=freqs_&j. ;
	by year;
run;

PROC EXPORT DATA=freqs_&j.
	OUTFILE="&results.\&filetype._ProcFreq_&date..csv"
	dbms=xlsx replace;
	sheet= "&j.";
RUN;

%end;
%mend;
%freq_loop;

/*looping through all numerical variables for proc means exports*/
%macro means_loop;
%Do i=1 %to &num_nums.;
	%let j=%scan(&num_vars.,&i.);

proc means data=&filetype._stacked; 
	var &j.;
	by year;
	output out=means_&j. (where=(_STAT_ IN ("MIN", "MEAN", "MAX"))drop=_TYPE_ _FREQ_);
run;

PROC EXPORT DATA=means_&j.
	OUTFILE="&results.\&filetype._ProcMeans_&date..csv"
	dbms=xlsx replace;
	sheet= "&j.";
RUN;
%end;
%mend;
%means_loop;

Thank you in advance,

Re: Proc Freq & Proc Mean

Reeza — Wed, 06 Oct 2021 19:21:42 GMT

That's already what it's doing - it does it by year though. Are you asking how to do it not by year as well?

FYI - CSVs do not support multiple sheets, its a single file so you cannot export with a CSV extension, specify the DBMX=XLSX and a sheet name. Also, have you considered using ODS EXCEL instead of EXPORTS?

Re: Proc Freq & Proc Mean

leeleelee — Wed, 06 Oct 2021 20:06:17 GMT

Hello,

I am wondering how to take it out of the macro (a.k.a. the looping), group by year (I have a total of 12 years)
I want to write it out for example (I know this code is wrong):

proc freq cat_var ...

and thank you for the csv tip. I'll note it.

Re: Proc Freq & Proc Mean

Reeza — Wed, 06 Oct 2021 20:22:29 GMT

Something like this:

proc freq data=inputDatasetName;
table SingleVariable orListOfVarsSpaceDelimited;
run;

proc freq data=sashelp.class;
table sex age name;
table sex;
table age;
table sex*age;
run;

Maybe this tutorial would be helpful:

https://libguides.library.kent.edu/SAS/Frequencies

Re: Proc Freq & Proc Mean

leeleelee — Wed, 06 Oct 2021 20:16:43 GMT

I'll try this out and will see if it works!
Thank you!