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!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.