topic Re: How to set the observations for a groups of variables with a prefix to missing? in SAS Programming

How to set the observations for a groups of variables with a prefix to missing?

Emma_at_SAS — Fri, 01 Oct 2021 19:04:43 GMT

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

Re: How to set the observations for a groups of variables with a prefix to missing?

PaigeMiller — Fri, 01 Oct 2021 19:13:45 GMT

Use the CALL MISSING function

call missing(of pre_fix_vars_:);

Re: How to set the observations for a groups of variables with a prefix to missing?

Reeza — Fri, 01 Oct 2021 19:14:33 GMT

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

Re: How to set the observations for a groups of variables with a prefix to missing?

Emma_at_SAS — Fri, 01 Oct 2021 19:36:32 GMT

Thank you @Reeza and @PaigeMiller ! It's amazing!