topic Re: proc freq of summary table (raw data) in SAS Programming

proc freq of summary table (raw data)

Ronein — Sun, 18 Aug 2019 04:00:56 GMT

Hello

In the following proc freq example I create an output data set(out statement) and also print the output.

In the output data set there are only 3 columns: Site,Count,Percent.

In the print output there are 5 columns: Site,Count,Percent,Cumulative count,Cumulative percent.

My question is:

How can I add columns :Cumulative count,Cumulative percent to the output data set?

How can I add % symbol to the output data set for columns:Percent,,Cumulative percent?

How can I create the output data set without print it?

thanks

Joe

data summary_tbl1;
input Site $ 1-8 frq;
datalines;
Atlanta  103
Chicago  486
Dallas   195
Denver   400
New York 307
Seattle  577
;
run;

proc freq data=summary_tbl1;
tables site/out=pelet;
weight frq;
run;

Re: proc freq of summary table (raw data)

SASKiwi — Sun, 18 Aug 2019 04:54:18 GMT

You can find the options for your required outputs in the documentation for the PROC FREQ TABLES statement:

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=procstat&docsetTarget=procstat_freq_syntax08.htm&locale=en

I suggest you bookmark this web link - documentation.sas.com - for future reference.

Re: proc freq of summary table (raw data)

Ksharp — Sun, 18 Aug 2019 11:33:45 GMT

data summary_tbl1;
input Site $ 1-8 frq;
datalines;
Atlanta  103
Chicago  486
Dallas   195
Denver   400
New York 307
Seattle  577
;
run;

proc freq data=summary_tbl1;
tables site/out=pelet outcum outpct;
weight frq;
run;

proc print;run;

Re: proc freq of summary table (raw data)

PaigeMiller — Sun, 18 Aug 2019 11:52:46 GMT

@Ronein wrote:

Hello

In the following proc freq example I create an output data set(out statement) and also print the output.

In the output data set there are only 3 columns: Site,Count,Percent.

In the print output there are 5 columns: Site,Count,Percent,Cumulative count,Cumulative percent.

My question is:

How can I add columns :Cumulative count,Cumulative percent to the output data set?

How about this:

ods output onewayfreqs=owf;
proc freq data=summary_tbl1;
tables site/cumcol;
weight frq;
run;

How can I add % symbol to the output data set for columns percent, Cumulative percent?

This is done via applying formats or picture formats to the values in the output data set OWF.