Help with very simple code!!

[mrs_oj]

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

[Reeza · Accepted solution]

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;

[AncaTilea]

hi.first thing i can think of is to place quotes for the last variable..ar3 eq 'PA0'

[mrs_oj]

Thank you so much!!  Something so simple, and yet so frustrating