topic Assigning Missing Values Irrespective of Type in SAS Programming

Assigning Missing Values Irrespective of Type

slolay — Mon, 31 Oct 2011 12:52:46 GMT

Is it possible to assign values to missing without knowing the variable's type?

A function that would assign a '' or . itself and I do not have to explicitily type it. I have some variables and do not want to have to find out which each type is and then assign them either '' or . myself.

Something like

textvar=missing;

numvar=missing;

ie set it to the appropriate missing value

Thanks in advance

Steve

Assigning Missing Values Irrespective of Type

art297 — Mon, 31 Oct 2011 12:54:51 GMT

You can use call missing. e.g.,

call missing(textvar)

would work as would

call missing(numvar)

Assigning Missing Values Irrespective of Type

slolay — Mon, 31 Oct 2011 12:59:44 GMT

Thanks Art...

sorry but don;t really understand. Do you have an example

Maybe it will be clearer when I give an example too..

data .....;

set.....;

if not first.subject then do;

age=.;

sex=.;

telno='';

address='';

end;

run;

Thanks

Steve

Assigning Missing Values Irrespective of Type

art297 — Mon, 31 Oct 2011 13:23:57 GMT

There are some shortcuts you could use, but the brute force method of applying call missing might be:

data .....;

set.....;

if not first.subject then do;

call missing(age);

call missing(sex);

call missing(telno);

call missing(address);

end;

run;

Assigning Missing Values Irrespective of Type

art297 — Mon, 31 Oct 2011 13:30:54 GMT

And, depending upon what you want to do, you can use call missing with arrays. E.g., while the following probably isn't close to your problem, it may show you some of the versatility. It takes sashelp.class and, for every other record, either sets the character fields or the numeric fields to missing:

data test;

set sashelp.class;

array numbers(*) _numeric_;

array characters(*) _character_;

if mod(_n_,2) eq 1 then do;

call missing(of numbers(*));

end;

else do;

call missing(of characters(*));

end;

run;

Assigning Missing Values Irrespective of Type

slolay — Mon, 31 Oct 2011 13:46:13 GMT

Thanks Art

Steve

Assigning Missing Values Irrespective of Type

Peter_C — Mon, 31 Oct 2011 15:05:31 GMT

shortcuts that Art297 refers to are great try

if not first.subject then call missing( age, sex, telno, address );

%let varlist = age sex telno address ;

if not first.subject then call missing( of &varlist ) ;