topic Re: datastep ouput and proc freq in Statistical Procedures

datastep ouput and proc freq

BrahmanandaRao — Wed, 07 Oct 2020 07:29:31 GMT

data dupcount;
set dup (keep= age);
by age;
if first.age then count=0;
count+1;
if last.age then output;
run;

proc freq;
tables age /nocum nocol norow nopercent  ;
run;

Here i am trying to get same output with proc freq as simple as datastep

Re: datastep ouput and proc freq

Kurt_Bremser — Wed, 07 Oct 2020 09:25:29 GMT

Use these options in the TABLES statement:

tables age / out=want (drop=percent) noprint;

No output is created, but a dataset with the same variables and content as in the data step.

Re: datastep ouput and proc freq

BrahmanandaRao — Wed, 07 Oct 2020 12:02:15 GMT

How to rename variable name Frequency Count as age_group_count in want dataset

Re: datastep ouput and proc freq

Kurt_Bremser — Wed, 07 Oct 2020 12:05:14 GMT

RENAME=