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.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.