topic Re: missing 999 proc means in SAS Procedures

missing 999 proc means

starz4ever2007 — Sat, 01 Sep 2018 20:31:58 GMT

Hi,

I would like to do proc means on some variables on a dataset. I do have missing observations for each variable and it's set as 999. How do I exclude those missing observations from analysis.

proc means data=new;
var age educ sadyrs pslgthyrs;
run;

I only know how to do it for each variable separately (see below):

proc means data=new (where=(age ne 999));
var age;
run;

Re: missing 999 proc means

Reeza — Sat, 01 Sep 2018 22:06:09 GMT

You cannot easily. You could try and combine the where clause but then all records with any variable with 999 would be excluded.

Ideally you can recode the 999 to a SAS missing value. If you have multiple issues for missing you can use multiple missing codes.

This is an example that would create a view and then you would run PROC MEANS on it. It only runs when you call proc means and doesn't create a data set that lingers around.

data temp_recode/ view= temp_recode ;
set have;

array recode(*) var1-var200;

do i=1 to dim(recode);

if recode(i) = 999 then recode(i) = .N; *not applicable;
else if recode(i) = 888 then recode(i)=.K; *did not know;
else if recode(i) = 777 then recode(i) = .M; *missing;

end;

run;

@starz4ever2007 wrote:

Hi,

I would like to do proc means on some variables on a dataset. I do have missing observations for each variable and it's set as 999. How do I exclude those missing observations from analysis.

proc means data=new;
var age educ sadyrs pslgthyrs;
run;

I only know how to do it for each variable separately (see below):

proc means data=new (where=(age ne 999));
var age;
run;

Re: missing 999 proc means

Malk020 — Tue, 03 Aug 2021 15:45:19 GMT

I have tried your code, but does not work. The values (Numbers )in the table still the same do not convert to missing value.

Re: missing 999 proc means

PaigeMiller — Tue, 03 Aug 2021 15:50:20 GMT

@Malk020 wrote:

I have tried your code, but does not work. The values (Numbers )in the table still the same do not convert to missing value.

In cases like these, we need to see the EXACT code you are using, and also a portion of your data.

DO NOT ATTACH FILES. Include the code you are using in the code box (click on the little running man icon) and include a portion of your data as SAS data step code (instructions).

Re: missing 999 proc means

Malk020 — Tue, 03 Aug 2021 16:30:12 GMT

I think i do not understand you.

Please kindly see the code. The code is run perfectly as i want and makes two tables. The problem is in the second Proc Tabulate(Numerical variables) when I run the code I got some values over 1000 and I just want to set up them as a missing value!!

proc contents data = .. ;

run;

* Categorical Variables;

PROC FREQ DATA = …;

TABLES ;
RUN;

*Numerical Variables;

proc means data =…;
var ;

RUN;

*** Crate a format *****;

proc format;;
value

1=''

2='';
value

1 = 'M'

2= 'F';

run;

*** Crate a table save it as CSV format *****;

OPTIONS MISSING = '';

ODS CSV FILE = '.csv';

PROC TABULATE DATA =..

CLASS / Missing;

CLASSLEV

TABLE

ALL (..)*

(N= COLPCTN=*f=5.1)

, (… ='' ALL='Total')

misstext='0';

format ..;

RUN;

PROC TABULATE DATA…. = ;

CLASS …..;

VAR…. ;

TABLE

(…. )*(MEAN=

STD=), (.. ='' ALL='Total')

misstext='0';

format.;

run;

CLOSE

Re: missing 999 proc means

PaigeMiller — Tue, 03 Aug 2021 16:52:19 GMT

You said you tried the code above where 999 is converted to .N

but you don't show anything of the sort in your code.

That's the code we need to see.

Re: missing 999 proc means

Reeza — Wed, 04 Aug 2021 19:18:41 GMT

And when you post code please use a code box and format it. As posted, your code isn't legible.