Hello I have a macro loop and has two steps, and the second step is transpose, but if the 1st step gets the empty data set (0 observation) then the 2nd step will have error. How can I have a step to test if the data set is empty, if its will jump to next loop. please see example below
%do m=1 %to 12;
%do n=1 %to 6;
/*1ST STEP*/ %Collect-DATA-SET-Step;
/*2ND STEP*/ %TRANSPOSE-Step;
%end;
%end;
What I would like is to have a test step after the 1st step, if the data set is empty, them move to next round loop.
Any thoughts are appreciated. Thank you.
proc sql noprint;
select nobs into :nobs from dictionary.tables
where libname = "XXXXX" and memname = "YYYYY";
quit;
%if &nobs ne 0 %then %do;
/* transpose step */
%end;
Thank you. I am little confused with "where libname = "xxxxxx" and memname = "YYYYY" ". What am I supposed to fillup for the xxxxxx and YYYYY?
I have posted a sample of my program, and can you please help me to correct it? I have struggled for few hours on this....:(
%do i= 1 %to 2;
%let PRIN1 = %scan(%bquote(&PRINLST), &i, ' ');
%put &prin1;
%do j = 1 %to 2;
%let POS1 = %scan(%bquote(&POS),&j, ' ');
%put &POS1;
%do m=1 %to 2;
%let CLSYRMTH1 = %scan(%bquote(&CLSYRMTH),&m, ' ');
%put &CLSYRMTH1;
%Basetable(&PRIN1, &POS1, &CLSYRMTH1); /*Gather base table*/
proc sql noprint;
select nobs into :nobs
from WORK.T_&PRIN1._&POS1._&CLSYRMTH1
where libname = "WORK" and memname = "YYYYY"
;quit;
%if &nobs ne 0 %then %do;
%TRANSPOSE(&PRIN1, &POS1, &CLSYRMTH1); /*Transpose step*/
%end;
%end;
%end;
%end;
memname is the dataset name (in uppercase) for which you want to get the observation count..
I figured it out. Thank you.
Below is an example using count(*) in PROC SQL:
%macro split(i, file);
%do i=1 %to &i;
proc sql noprint;
select count(*) into :obs_count
from &file._out&i;
quit;
%if &obs_count ne 0 and &file=res %then %do;
proc export data=&file._out&i label /* The label option is used to export the label names as variable names */
outfile="&SF\covid19&file.&i..csv"
dbms=csv replace;
run;
%end;
%else %if &obs_count ne 0 %then %do;
proc export data=&file._out&i
outfile="&SF\covid19&file.&i..csv"
dbms=csv replace;
run;
%end;
%end;
%mend split;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.