topic Re: Character to Numeric Value Labels in SAS Programming

Character to Numeric Value Labels

tjones156 — Fri, 13 Aug 2021 03:18:46 GMT

I am trying to figure out how to change character value labels to numeric values.

For example:

"ABCDEF"=1

"GHIJKL"=2

MNOPQR=3

STUVWX=4

"YZ"=5

I know how to do it in the reverse (numeric to character) using proc format. I attempted to use the same method but maybe I am just using the incorrect syntax??? Suggestions please

Re: Character to Numeric Value Labels

ChrisNZ — Fri, 13 Aug 2021 03:33:48 GMT

Like this?

proc format; 
 invalue read     
  "ABCDEF"=1
  "GHIJKL"=2
  'MNOPQR'=3
  'STUVWX'=4
  "YZ"    =5 ;
data T;  
  NUM=input('YZ',read.);
run;

NUM=5

Re: Character to Numeric Value Labels

andreas_lds — Fri, 13 Aug 2021 05:39:51 GMT

You may want to post code and log so that we can help to improve / fix what you already have.