BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AnaVelloso
Calcite | Level 5

Hello, 

I am very new and green to SAS and I am sure that I just not writing something correctly. I have a data set where one of the variables is called status (survived vs perished). I want to select only the ones that survived which I am coding in the following way:

 

data survived;

set birds;

if status = perished then delete;

proc print data= survived; 

run;

 

Once I do that keeps printing all the data without deleting the ones that perished. Can someone help me please? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star
Other things to note:

Capitalization matters. These are all different:

Perished
PERISHED
perished

You don't need a data step to print a subset. This is a valid approach:

proc print data=birds;
where status="perished";
run;

View solution in original post

3 REPLIES 3
PGStats
Opal | Level 21

You probally need to quote the value to make it a string constant and not a variable name

 

data survived;
set birds;
if status = "perished" then delete;
run;

proc print data= survived; 
run;

 

PG
Astounding
PROC Star
Other things to note:

Capitalization matters. These are all different:

Perished
PERISHED
perished

You don't need a data step to print a subset. This is a valid approach:

proc print data=birds;
where status="perished";
run;
AnaVelloso
Calcite | Level 5

That was my problem! thanks so much!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2222 views
  • 0 likes
  • 3 in conversation