topic Re: Trying to apply formats, but for some reason it's not working in SAS Programming

Trying to apply formats, but for some reason it's not working

Hello_there — Tue, 12 Jan 2021 18:36:23 GMT

I'm trying to apply a format to this table.

using this code

proc format;*creating formats;
	value $racex
AMERICAN INDIAN OR ALASKA NATIVE="American Indian or Alaska Native"
ASIAN="Asian"
BLACK OR AFRICAN AMERICAN="Black or African American"
NATIVE HAWAIIAN OR OTHER="Native Hawaiian or Other"
PACIFIC ISLANDER="Pacific Islander"
WHITE="White"
MULTIPLE="Multiple"
MISSING="Missing";
run;
	
data finalrace2;
	length raceX $50.;
	set finalrace;
	racex=put (race, $racex.);
run;
proc print data=finalrace2;
run;

My racex variable looks nothing like the format I created. can anyone point to what I'm doing wrong?

Re: Trying to apply formats, but for some reason it's not working

Hello_there — Tue, 12 Jan 2021 18:37:35 GMT

hmmm... after pasting the code and seeing I displayed it looks like the problem is the use of the word OR. That's in the name of the race. Is there anyway to fix it?

Re: Trying to apply formats, but for some reason it's not working

PaigeMiller — Tue, 12 Jan 2021 18:42:34 GMT

In PROC FORMAT, there is no "OR" operator, I think you mean

proc format;*creating formats;
	value $racex
'AMERICAN INDIAN','ALASKA NATIVE'="American Indian or Alaska Native"
'ASIAN'="Asian"
'BLACK','AFRICAN AMERICAN'="Black or African American"
/* etc. */
;
run;

Also, the above code is case sensitive, so 'Black" doesn't get formatted. If that's a problem, it's easy to fix via the UPCASE() function in your DATA step.

Re: Trying to apply formats, but for some reason it's not working

FreelanceReinh — Tue, 12 Jan 2021 19:10:27 GMT

Hi @Hello_there,

No, it's not the "OR" that confused the compiler, but the ambiguities that arise when quotes around values consisting of multiple words are missing. Just use quotes on both sides of the equals signs and the format will be created correctly.

It's good practice to always use quotes around character strings (where appropriate; not talking about macros, of course) although SAS tolerates unquoted strings in some places (for extreme backward compatibility I guess).