Hi,
I have the following example code:
Data example;
set source_data;
if (VTYPE(¯o1.) eq 'C' and VTYPE(¯o2.) eq 'N' then do;
d1 = variable1;
end;
else if (VTYPE(¯o1.) eq 'N' and VTYPE(¯o2.) eq 'C' then do;
d2 = variable1;
end;
else do;
d3 = variable1;
end;
run;
But the output table has three new columns, d1, d2, d3, with the right one filled with data, and the other two empty. Why is SAS running things even if the if statement is false? E.g. if macro1 is C and macro2 is N, it outputs d1 correctly, but it also adds two empty columns d2 and d3. Since this is happening, I can't use input inside an if-statement, because if the variable is not char, it will throw an error. Can somebody help me?
Thanks!
@rodrigobarg wrote:
Hi,
I have the following example code:
Data example;
set source_data;
if (VTYPE(¯o1.) eq 'C' and VTYPE(¯o2.) eq 'N' then do;
d1 = variable1;
end;
else if (VTYPE(¯o1.) eq 'N' and VTYPE(¯o2.) eq 'C' then do;
d2 = variable1;
end;
else do;
d3 = variable1;
end;
run;
But the output table has three new columns, d1, d2, d3, with the right one filled with data, and the other two empty. Why is SAS running things even if the if statement is false? E.g. if macro1 is C and macro2 is N, it outputs d1 correctly, but it also adds two empty columns d2 and d3. Since this is happening, I can't use input inside an if-statement, because if the variable is not char, it will throw an error. Can somebody help me?
Thanks!
You cannot create or conditionally create a variable after a data step starts to execute. You will need to use macro language or other technique to accomplish your task.
If you show a more complete example of your problem with example data someone will be able to help you get what you need.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.