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

Hello programmers,

 

I wanted to create a dichotomous 0, 1 variable for CVD death.  If the cause of death is between codes  '410' and '41499' then the person has CVD death.

 

My codes are attached. 

data xyz;
input  id death $ ;
datalines;
1  195 
19  414  
26  431  
27  414  
29  414  
40  414  
; run;


data abc; set xyz;
if death = '410' then Dix= 1;
if death= '411' then Dix=1;
If death= '412' then Dix=1;
If death= '413' then Dix=1;
If death='414' then Dix=1;
else Dix=0; RUN;

This code worked because i checked the CVD codes to see that there were only codes '410' '411' '412' '413' and '414'. Sometimes there may be '41099' '41080' '41499' etc . Is there a better way i could write this code so that it checks every code without me having to do it in this pattern?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star
Dix = (death in: ('410','411','412','413','414'));

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star
Dix = (death in: ('410','411','412','413','414'));
ScottBass
Rhodochrosite | Level 12

See http://support.sas.com/resources/papers/proceedings09/056-2009.pdf for more details.


Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 2 replies
  • 953 views
  • 3 likes
  • 3 in conversation