How would I use an array to extract ONLY observations/records that have the values '9351' '9359' (character values)? Below is my code (I made a new variable previously, but it would be better if I just extracted the records I wanted instead of identifying them with a new variable).
data cuthip;
set allrecords;
array procedure (3) $ prcode1-prcode3;
do x=1 to 3;
if procedure(x) in ('9351' '9359') then newvar=1;
end;
run;
if procedure(x) in ('9351' '9359') then output;
if procedure(x) in ('9351' '9359') then output;
It worked, but it's now creating records when the array finds an observation with both those values (i.e., the observation has 9359 and 9351). I can't use the OR statement in my code between '9359' and '9351' - how do I tell the array then to just search for one?
Something like this should work too, no arrays:
data cuthip;
set allrecords;
if index('9351', catx('-',of prcode1-prcode3)) or index('9359', catx('-',of prcode1-prcode3));
run;
Alternatively:
if procedure(x) in ('9351' '9359') then do;
output;
delete;
end;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.