Help with very simple code!!

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Help with very simple code!!

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


Accepted Solutions
Solution
‎02-25-2013 04:37 PM
Super User
Posts: 19,822

Re: Help with very simple code!!

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;

View solution in original post


All Replies
Solution
‎02-25-2013 04:37 PM
Super User
Posts: 19,822

Re: Help with very simple code!!

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;

Super Contributor
Posts: 543

Re: Help with very simple code!!

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

New Contributor
Posts: 2

Re: Help with very simple code!!

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 169 views
  • 3 likes
  • 3 in conversation