topic Re: how to handle missing values in proc freq in SAS Procedures

how to handle missing values in proc freq

anilgvdbm — Mon, 01 Dec 2014 09:17:58 GMT

Dear friends,

I am Anilkumar from Hyderabad, India i am facing a problem with missing values when i'm going to prepare tables in proc freq even i used missing option also the table is coming like this. so if i delete missing valyues in the particular variable it will effect to other variables also. so what is the solution.

i request you to look at my codes and output once.

proc freq data=nfhs_05.nonpreg_women;

where V024=29;

table V025*Anemia_statusnpw/norow nocol missing ;

table V013*Anemia_statusnpw/norow nocol missing ;

table V106*Anemia_statusnpw/norow nocol missing ;

table V130*Anemia_statusnpw/norow nocol missing ;

table Age_group * Anemia_statusnpw/norow nocol missing ;

format V025 F00009_.;

format V013 F00001_.;

format V106 F00019_.;

format V130 F00609_.;

format Age_group agewomen_.;

weight weights;

run;

Urban

411.757

5.78

78.9311

1.11

527.523

7.41

544.624

7.65

1335.25

18.75

2898.09

40.70

Rural

354.752

4.98

198.139

2.78

940.865

13.21

851.88

11.96

1876.98

26.36

4222.62

59.30

766.51

10.76

277.07

3.89

1468.39

20.62

1396.5

19.61

3212.24

45.11

7120.71

100.00

Tanks for your help....

thanks and regards,

Anil

Re: how to handle missing values in proc freq

RW9 — Mon, 01 Dec 2014 09:34:00 GMT

Sorry, what is the problem? I see no missings in that table. Can you provide test data/expected output also.

Re: how to handle missing values in proc freq

anilgvdbm — Mon, 01 Dec 2014 10:08:18 GMT

Hi this is what i got results

i need to remove missing values in tables mentioned as a dot in 2nd column because its also contributing to the total value so the results will go wrong.

V013(Age 5-year	Anemia_status
groups)	.	1	2	3	4	Total
15-19	136.447	41.8884	265.464	269.619	597.145	1310.56
15-19	1.92	0.59	3.73	3.79	8.39	18.4
20-24	149.603	47.3045	281.121	232.218	571.942	1282.19
20-24	2.1	0.66	3.95	3.26	8.03	18.01
25-29	158.116	49.8065	220.12	251.434	527.914	1207.39
25-29	2.22	0.7	3.09	3.53	7.41	16.96
30-34	107.972	37.5547	223.551	235.415	470.085	1074.58
30-34	1.52	0.53	3.14	3.31	6.6	15.09
35-39	82.5654	43.8742	174.801	169.643	448.908	919.792
35-39	1.16	0.62	2.45	2.38	6.3	12.92
40-44	86.641	33.3251	184.268	150.581	323.863	778.678
40-44	1.22	0.47	2.59	2.11	4.55	10.94
45-49	45.1647	23.3171	119.063	87.5943	272.379	547.517
45-49	0.63	0.33	1.67	1.23	3.83	7.69
Total	766.51	277.07	1468.39	1396.5	3212.24	7120.71
Total	10.76	3.89	20.62	19.61	45.11	100

the codes are

proc freq data=nfhs_05.nonpreg_women;

where V024=29;

table V025*Anemia_statusnpw/norow nocol missing ;

table V013*Anemia_statusnpw/norow nocol missing ;

table V106*Anemia_statusnpw/norow nocol missing ;

table V130*Anemia_statusnpw/norow nocol missing ;

table Age_group * Anemia_statusnpw/norow nocol missing ;

format V025 F00009_.;

format V013 F00001_.;

format V106 F00019_.;

format V130 F00609_.;

format Age_group agewomen_.;

weight weights;

run;

thanks

anil

Re: how to handle missing values in proc freq

RW9 — Mon, 01 Dec 2014 10:50:47 GMT

So you can just have a step before which drops data where that group (don't know the variable name) is missing, i.e. assuming anemia status groups is a_group:

data want;

set have;

where a_group ne .;

run;

proc freq...;

run;

Re: how to handle missing values in proc freq

DaveBirch — Tue, 02 Dec 2014 03:04:01 GMT

Hi Anil,

I think should use the MISSPRINT option rather than MISSING option. Here's what the Proc Freq documentation says:

MISSPRINT

displays missing value frequencies in frequency or crosstabulation tables but does not include them in computations of percentages or statistics.

MISSING

treats missing values as a valid nonmissing level for all TABLES variables. Displays missing levels in frequency and crosstabulation tables and includes them in computations of percentages and statistics.

Eliminating missing values with a WHERE statement will affect other variables also, unless you run them in separate Proc Freq steps.

I've always found it useful to understand the missing value frequencies, even though I wasn't using them in computations.

Cheers,

Dave

Re: how to handle missing values in proc freq

anilgvdbm — Tue, 02 Dec 2014 03:24:34 GMT

Hi Dave,

Thanks for the help i thought missprint will works only in proc tabulate otherwise i would have applied this before.

anyway thanks a lot..

Anil