topic what am I doing wrong? formatting missing values in SAS Programming

what am I doing wrong? formatting missing values

K_S — Sat, 24 Oct 2020 23:13:02 GMT

Hello everyone,

I am trying to create formats using proc format but for whatever reason the missing values are not getting formatted.

Same problem for both numeric and character vars.

Any idea why?

Re: what am I doing wrong? formatting missing values

PaigeMiller — Sat, 24 Oct 2020 23:20:31 GMT

Show us the code. Show us a portion of the data.

Re: what am I doing wrong? formatting missing values

K_S — Sat, 24 Oct 2020 23:31:06 GMT

PROC FORMAT;
VALUE AREA (NOTSORTED)
1="URBAN: built-up area with a high population density"
2="RESIDENTIAL: living dwellings"
.="MISSING/UNKNOWN";
RUN;

Re: what am I doing wrong? formatting missing values

PaigeMiller — Sat, 24 Oct 2020 23:38:55 GMT

Hi. I requested you show us two things. You only showed us one.

Also show us the rest of the code where you assign the format to a variable.

Re: what am I doing wrong? formatting missing values

K_S — Sat, 24 Oct 2020 23:45:01 GMT

data X;
set Y;
FORMAT
AREA AREA.;
RUN;

and please note, the other values get formatted, but not the missing ones.

Re: what am I doing wrong? formatting missing values

unison — Sun, 25 Oct 2020 00:11:04 GMT

PROC FORMAT;
VALUE AREA (NOTSORTED)
1="URBAN: built-up area with a high population density"
2="RESIDENTIAL: living dwellings"
.="MISSING/UNKNOWN"
other="some other value";
RUN;

Could be that your missing values are not . but rather some other missing such as .Z or ._

Re: what am I doing wrong? formatting missing values

K_S — Sun, 25 Oct 2020 00:25:56 GMT

Sadly, that is not the case. Any other possible explanation.

Re: what am I doing wrong? formatting missing values

jimbarbour — Sun, 25 Oct 2020 00:59:23 GMT

Can you post your proc format code, your data, and your results? Otherwise I think I'd kind of be taking a shot in the dark.

Jim

Re: what am I doing wrong? formatting missing values

K_S — Sun, 25 Oct 2020 01:44:05 GMT

I have posted the syntax in response to someone else's comment. I will not be posting the data.

Re: what am I doing wrong? formatting missing values

K_S — Sun, 25 Oct 2020 01:46:19 GMT

I see what you mean now! How would i be able to find out what the missing value is? I am looking at my table and see dots.

Re: what am I doing wrong? formatting missing values

unison — Sun, 25 Oct 2020 04:05:51 GMT

data have;
	input area;
	datalines;
1
2
.
.
;
run;

proc format;
	value area 
		1='URBAN: built-up area with a high population density' 
		2='RESIDENTIAL: living dwellings'
		.='MISSING/UNKNOWN';
run;

data want;
	set have;
	format area area.;
run;
proc print noobs;
run;

This works just fine. Can't really know for sure what's going on without data/images/etc.

Best,