topic Conversion sql to data step in Administration and Deployment

Conversion sql to data step

pallis — Fri, 13 Sep 2013 05:57:14 GMT

proc sql;

create table a

select

Deptno,

STATUS,

Count(AGMTNO)

from Emp_aug13_Data

group by

Deptno ,

STATUS;

quit;

Can you help me how can achive this in data step

regards,

venky

Re: Conversion sql to data step

Patrick — Fri, 13 Sep 2013 06:39:51 GMT

Is this an exercise? Or why else would you want to do this?

First sort your data by deptno and status, then in a data step use by group processing.

...

by deptno status;

count+1;

if last.status then

do;

output;

count=0;

end;

...

Re: Conversion sql to data step

Scott_Mitchell — Fri, 13 Sep 2013 06:43:34 GMT

Is it necessary to use a datastep? Of course it can be done, but you could also use PROC FREQ:

PROC FREQ DATA=EMP_AUG13_DATA NOPRINT;

TABLES DEPTNO * STATUS / OUT=WANT(DROP=PERCENT) ;

RUN;

Re: Conversion sql to data step

pallis — Fri, 13 Sep 2013 06:54:23 GMT

Yes I'm an sql programmer and I was moved to sas recently. The task given by team is that. I could do things and get results in sql But they are rejecting and asking me to us in data step. I'm unable to figure out the thing how to do in sas . So I thought this is way I can learn and implement when it comes next time.

Regards,

venky.