topic Re: Help with very simple code!! in SAS Programming

Help with very simple code!!

mrs_oj — Mon, 25 Feb 2013 21:36:16 GMT

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

Re: Help with very simple code!!

Reeza — Mon, 25 Feb 2013 21:37:32 GMT

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;

Re: Help with very simple code!!

AncaTilea — Mon, 25 Feb 2013 21:43:13 GMT

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

Re: Help with very simple code!!

mrs_oj — Mon, 25 Feb 2013 21:49:58 GMT

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