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.
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;
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.