DATA Step, Macro, Functions and more

Exectue code if statement = true

Reply
New Contributor
Posts: 4

Exectue code if statement = true

I've imported two datasets from excel ('Current_IC' and 'Current_EC') and want to combine the two datasets to create a new table called CurrentData.  The issue is that I've defined a variable, 'Combined', that will take on the values 'Both', 'IC', or 'EC'.  If the variable = 'Both' then i want to combine the two datasets.  If it's 'IC' I only want to put in 'Current_IC' to the CurrentData table, and if it's 'EC' then I only want to add 'Current_EC'.  I don't know how to add an if statement to accomplish this.  Below is the code I have to combine the two sets but how do I add an if statement?

 

Data CurrentData;

Set Current_IC Current_EC;

Run;

 

If the variable 'Combined' = IC then the code would be

 

Data CurrentData;

Set Current_IC;

Run;

 

Any help with this would be great.

PROC Star
Posts: 307

Re: Exectue code if statement = true

 

You can name multiple data sets in the data statement and output them conditionally based on the value of your Combined variable;

 

Something like this:

data combo ic_only ec_only;   
 set current_ic current_ec;   
 if combined = 'Both' then output combo;   
 else if combined = 'IC' then output ic_only;   
 else if combined = 'EC' then output ec_only;
run;

 

Ask a Question
Discussion stats
  • 1 reply
  • 98 views
  • 0 likes
  • 2 in conversation