Hi - I'm a very new user to SAS and I'm having trouble with some code. Here is my problem:
I have a data set from which I need to identify the number of respondents who meet certain criteria under 5 variables. The variables in the data set, and how they are coded, are as follows:
Variable Coding
H2g 0,1,2,3,4,5,6,8
H2h 0,1,2,3,4,5,6,8
H2i 0,1,2,3,4,5,6,8
H2j 0,1,2,3,4,5,6,8
aR3 BA0, BB0, PE0, PD0, PC0, PB0, PA0, IB0, IA0
so the code I have is:
data in;
set Baseline.Baseline;
if setting=2;
run;
proc print;
where H2i <=2 AND H2g <=2 AND H2h <=2 AND H2j<=2 AND aR3=PA0;
run;
I get multiple errors, one being that PA0 is not a recognized variable, which is wrong because it is not a variable.
Can someone help me fix this please?! I'm quite frustrated by it! I don't even know if I have the right proc
Thank you so much!
Shannon
you're comparing text so put PA0 in quotation marks.
data in;
set Baseline.Baseline;
if setting=2;
run;
proc print;
where H2i <=2 AND H2g <=2 AND H2h <=2 AND H2j<=2 AND aR3="PA0";
run;
you're comparing text so put PA0 in quotation marks.
data in;
set Baseline.Baseline;
if setting=2;
run;
proc print;
where H2i <=2 AND H2g <=2 AND H2h <=2 AND H2j<=2 AND aR3="PA0";
run;
hi.first thing i can think of is to place quotes for the last variable..ar3 eq 'PA0'
Thank you so much!! Something so simple, and yet so frustrating
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.