topic Re: group by age in datastep in SAS Procedures

group by age in datastep

BrahmanandaRao — Sat, 14 Mar 2020 04:09:00 GMT

data dd;
set sashelp.class;
run;

proc sql;
	select age, count(age) from dd 
group by  age;
quit;

i want output in datastep group by age as well as name of age of agecount

Re: group by age in datastep

Kurt_Bremser — Sat, 14 Mar 2020 06:19:01 GMT

What do you mean by "name of age"?

And is your question how to re-engineer the sql code in a data step?

Re: group by age in datastep

BrahmanandaRao — Sat, 14 Mar 2020 07:12:40 GMT

Hi Krut,

I want same result like in datastep like proc sql

proc sql;
select age, count(age) as agecount from sashelp.class
group by age;
quit;

Re: group by age in datastep

Kurt_Bremser — Sat, 14 Mar 2020 07:55:59 GMT

First, sort by age. Then use a data step with

by age;

retain the new variable agecount, set it to 1 at first.age, and increment it else. At last.age, output.

See examples for the use of by in a data step here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lestmtsref&docsetTarget=p0yeyftk8ftuckn1o5qzy53284gz.htm&locale=en

Re: group by age in datastep

ed_sas_member — Sat, 14 Mar 2020 08:39:57 GMT

Hi @BrahmanandaRao

Here is a data step equivalent to your PROC SQL code:

/*PROC SQL */

proc sql;
	create table want as /* <-- add this code if you want to output a dataset */
	select age, count(age) as Age_N from sashelp.class 
	group by age;
quit;


/* DATA STEP EQUIVALENT */

proc sort data=sashelp.class out=class_sorted;
	by age;
run;

proc means data=class_sorted n nonobs;
	var age;
	class age;
	ways 1;
	output out=want (drop=_:) n= /autoname; /* <-- add this code if you want to output a dataset */
run;

All the best,

Re: group by age in datastep

Reeza — Sat, 14 Mar 2020 15:12:23 GMT

This isn't a great idea for a data step either, the 'SAS' method to do this would be to use PROC FREQ (or REPORT, TABULATE, MEANS). This provides displayed output or a dataset.

proc freq data=sashelp.class;
table age / out = want;
run;

proc means data=sashelp.class N;
class age;
output out=want_means N= ;
run;

@BrahmanandaRao wrote:
data dd;
set sashelp.class;
run;

proc sql;
	select age, count(age) from dd 
group by  age;
quit;
i want output in datastep group by age as well as name of age of agecount