And create another dataset and add a row to the second dataset explaining the problem with X variable, so I any number of variables/explinations would need to be added to other dataset. So I am trying to figure out how to do this in an array (IE add 3 variables to the array and then add a row for each variable to say this variable has a problem)
My dataset looks like:
Variable | X | Y |
---|---|---|
A | 1 | 2 |
B | 1 | .5 |
So the condition might be if X>Y then add a variable to array, and then I want to create dataset test and add a row saying variable X has X>Y
Is this possible and does it make sense
Sounds like you want to create a problem report. Typically you would include the id variables (so someone can find the offending row), then rule and the key values that violate the rule.
data want ;
set have ;
length rule $50 values $50 ;
keep id rule values ;
if x > y then do;
rule = 'X>Y' ;
values=catx(' ',catx('=','X',x),catx('=','Y',y));
output;
end;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: