I created a series of variables and now for some observations, I want to set them to missing.
Something like this:
if age_group in (2,3) and school_zone in (1,3,4,5,6,7,10,13,14,16) then pre_fix_vars_: = . ;
I appreciate your help. Thanks
Use a call routine, specifically, CALL MISSING.
if age_group in (2,3) and school_zone in (1,3,4,5,6,7,10,13,14,16) then call missing(of pre_fix_vars_: ) ;
Another option is to use an array with a loop but this is more succinct for sure.
Here's a tutorial on using Arrays in SAS
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/
@Emma_at_SAS wrote:
I created a series of variables and now for some observations, I want to set them to missing.
Something like this:
if age_group in (2,3) and school_zone in (1,3,4,5,6,7,10,13,14,16) then pre_fix_vars_: = . ;
I appreciate your help. Thanks
Thank you @Reeza and @PaigeMiller ! It's amazing!
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!
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.
Ready to level-up your skills? Choose your own adventure.