topic Re: Creating separate Code and Decode variables from a SAS dataset custom formats in SAS Programming

Creating separate Code and Decode variables from a SAS dataset custom formats

pteranodon — Wed, 13 Jan 2021 06:10:18 GMT

I'm receiving a SAS dataset with five integer variables (x1-x5) with different custom formats already applied. I also have the formats catalog. I want to create character variables x1_DEC through x5_DEC that contain just the decodes.

I would normally solve this by using

x1_DEC=put(x1, formatA.);

x2_DEC=put(x2, formatB.);

but that requires hardcoding the format names into the program. Is there a way to do this using vformat or some such function so that I can write something like

x1_DEC=put(vformat(x1));

that would dynamically read the currently assigned format?

Re: Creating separate Code and Decode variables from a SAS dataset custom formats

Astounding — Wed, 13 Jan 2021 06:20:02 GMT

If the name of the format is stored in a DATA step variable, use PUTN instead of PUT.

Re: Creating separate Code and Decode variables from a SAS dataset custom formats

andreas_lds — Wed, 13 Jan 2021 06:22:14 GMT

You can use vvalue to get the formatted value of variable:

x1_Dec = vvalue(x1);