topic Data step execution based on condition in SAS Programming

Data step execution based on condition

batu544 — Wed, 15 Nov 2017 22:30:29 GMT

Hi Everyone,

I have a situation where I need to run different data step based on output from 1st PROC SQL. I was looking for GOTO statement but it will not help because it needs to be used inside one data step.

PROC SQL 
        query to get the details from DB2 table. 
QUIT;
DATA _NULL_;
 if &sqlobs = 0 
      I need to bypass below proc steps and execute the code from label XXXX

run; 

proc sort data=xxx;
run;

proc SQL 
   another query to get data from DB2 
quit;

DATA ABCD;
  SET AAAA ( KEEP=XX,YY,ZZ,...);
  few logics here.. 
run;

XXXX: 

proc SQL 
  get data from DB2 table for another processing
quit;


proc print; 
...
...

Any suggestion will be really helpful.

Thank you

Re: Data step execution based on condition

Reeza — Wed, 15 Nov 2017 22:35:51 GMT

You need a macro 😞 But, it's a pretty basic one.

Here's a fully worked example that is from the SAS documentation. It checks if a data set has observations and prints it or otherwise prints a message to the log.

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p011imau3tm4jen1us2a45cyenz9.htm&docsetVersion=9.4&locale=en

It's fully explained so its a good starting point. But, if you have any further questions, feel free to post back.

Full list of macros in the appendix (for reference):https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716

@batu544 wrote:

Hi Everyone,

I have a situation where I need to run different data step based on output from 1st PROC SQL. I was looking for GOTO statement but it will not help because it needs to be used inside one data step.
PROC SQL 
        query to get the details from DB2 table. 
QUIT;
DATA _NULL_;
 if &sqlobs = 0 
      I need to bypass below proc steps and execute the code from label XXXX

run; 

proc sort data=xxx;
run;

proc SQL 
   another query to get data from DB2 
quit;

DATA ABCD;
  SET AAAA ( KEEP=XX,YY,ZZ,...);
  few logics here.. 
run;

XXXX: 

proc SQL 
  get data from DB2 table for another processing
quit;


proc print; 
...
...
Any suggestion will be really helpful.

Thank you

pk

Re: Data step execution based on condition

batu544 — Thu, 16 Nov 2017 23:11:09 GMT

Thank you.. 🙂