topic Re: appears missing in proc print but not with proc freq in SAS Programming

appears missing in proc print but not with proc freq

Diana_AdventuresinSAS — Sat, 04 Aug 2018 18:44:40 GMT

I merged two datasets together using a common variable (occsoc); afterwards, a different variable (met2013) appears missing when I print the data but when I run a proc freq on the variable, it's all there like it is in the original set. Any ideas why it's doing this and also should I ignore it? (It is a variable I don't plan to use much if at all but would like it ready to go if need be).

In case this matters, one of the files (not the one containing met2013 variable) was once an Excel file that I imported into SAS and cleared of formats and informats before merging the two.

Thanks!

Diana

Re: appears missing in proc print but not with proc freq

PeterClemmensen — Sat, 04 Aug 2018 18:45:50 GMT

Show us your code 🙂

Re: appears missing in proc print but not with proc freq

Diana_AdventuresinSAS — Sat, 04 Aug 2018 18:48:18 GMT

Data onetlib.onetipums;
merge IPUMS.ACS2016 onetlib.onetindexes;
by occsoc;
run;

proc print data=onetlib.onetipums (obs=10); run;

Re: appears missing in proc print but not with proc freq

Diana_AdventuresinSAS — Sat, 04 Aug 2018 18:55:47 GMT

I should add, the original set was once sorted by met2013 and occsoc, then before the merge I sorted it by occsoc alone. Could sorting it in the past by met2013 have done something to cause this?

proc sort data=IPUMS.ACS2016; by met2013 occsoc; run;

Re: appears missing in proc print but not with proc freq

PeterClemmensen — Sun, 05 Aug 2018 05:17:11 GMT

Is the variable of question in both your data sets?

Also, can you show us a part of your data? It is much easier to help you then..

PROC FREQ ignores missing values by default.

Re: appears missing in proc print but not with proc freq

PGStats — Sat, 04 Aug 2018 19:27:30 GMT

When there are more variables that can fit on the page width, proc print will split the printed table into many components. Could it be that the missing variable appeared on another page?

Re: appears missing in proc print but not with proc freq

Astounding — Sat, 04 Aug 2018 19:29:33 GMT

From what you have shown us so far, it's still a guess. So here's an educated guess. Perhaps ....

The new data set being merged in contains some new values for OCCSOC, values that don't appear in the old data set. And, perhaps those values sort first. You are printing only ten observations. Those could represent mismatches from the merge step where if you looked a little further into the data you would start finding the matches and the valid values.

Re: appears missing in proc print but not with proc freq

Diana_AdventuresinSAS — Sat, 04 Aug 2018 19:46:25 GMT

no, it's only in acs2016 which I see in proc print also has missing met2013. But I think it's because I sorted it at one point with met2013 first, which probably lists first the missing observations then the rest.

SAS Output

Obs	MET2013	PERNUM	PERWT	NCHILD	SEX	AGE	RACE	RACED	EMPSTAT	CLASSWKRD	OCCSOC	INDNAICS	INCWAGE	male	female	urban	noturban	yescitizen	citizenship	native	nativity	ENGLISH	SPKENG	HSDIPLOMA	SOMECOLLEGE	COLLEGE	GRADUATE	educa	MARRIED	NOTMARRIED	race4	nativewhite	nativeblack	nativeasian	race8	LowSkilled	HighSkilled	LowNative	HighNative	notmoved	moved	broad	major	minor	IND
1	.	2	17.00	0	1	51	1	100	1	22	111021	3399ZM	288519	1	0	.	.	1	1	1	1	1	2	0	0	0	1	5	1	0	1	1	0	0	1	0	1	0	1	0	1	1	1	1	5
2	.	1	50.00	0	1	32	2	200	1	22	111021	493	50177	1	0	1	0	1	1	1	1	1	2	1	0	0	0	2	0	1	2	0	1	0	3	1	0	1	0	1	0	1	1	1	8
3	.	1	15.00	0	1	48	1	100	1	22	111021	4234	141124	1	0	.	.	1	1	1	1	1	2	0	0	1	0	4	1	0	1	1	0	0	1	0	1	0	1	1	0	1	1	1	6
4	.	2	68.00	4	2	31	2	200	1	22	111021	722Z	53313	0	1	0	1	1	1	1	1	1	2	1	0	0	0	2	0	1	2	0	1	0	3	1	0	1	0	1	0	1	1	1	18
5	.	1	6.00	0	1	53	1	100	1	22	111021	31411	73175	1	0	.	.	1	1	1	1	1	2	0	0	1	0	4	1	0	1	1	0	0	1	0	1	0	1	1	0	1	1	1	5
6	.	2	7.00	2	1	44	1	100	1	14	111021	56173	43905	1	0	0	1	1	1	1	1	1	2	0	1	0	0	3	1	0	1	1	0	0	1	1	0	1	0	1	0	1	1	1	14
7	.	1	6.00	1	1	42	5	500	2	22	111021	4241	0	1	0	0	1	1	1	1	1	1	2	0	0	1	0	4	1	0	3	0	0	1	5	0	1	0	1	1	0	1	1	1	6
8	.	1	6.00	0	1	33	1	100	1	22	111021	713Z	83629	1	0	.	.	1	1	1	1	1	2	0	1	0	0	3	0	1	1	1	0	0	1	1	0	1	0	1	0	1	1	1	17
9	.	1	18.00	0	1	61	1	100	1	28	111021	2213M	62722	1	0	.	.	1	1	1	1	1	2	1	0	0	0	2	0	1	1	1	0	0	1	1	0	1	0	0	1	1	1	1	3
10	.	2	70.00	0	1	24	1	100	1	22	111021	722Z	28225	1	0	0	1	1	1	1	1	1	2	1	0	0	0	2	0	1	1	1	0	0	1	1	0	1	0	1	0	1	1	1	18

Re: appears missing in proc print but not with proc freq

PGStats — Sat, 04 Aug 2018 20:52:18 GMT

Yes, missing values are considered by SAS as smaller than any other number.

Re: appears missing in proc print but not with proc freq

Tom — Sat, 04 Aug 2018 21:20:36 GMT

By default PROC FREQ will ignore the missing values add the MISSIING or MISSPRINT option to your TABLES statement.