topic Re: Convert a formatted numeric column to its corresponding char column in SAS Programming

Convert a formatted numeric column to its corresponding char column

didye — Tue, 23 Apr 2013 11:25:11 GMT

Hello!

I would like to ask a question about column creation:

I 'd like to convert a formatted numeric column to its corresponding character column.

An example:

I have a numeric col1num as :

col1num

The format of this column is 1 ->"A", 2 -> "B".

I aim to create through a data step a new column col2char as :

col2char

Is there a simple instruction to do this ?

Thanks for help!!!

LinusH — Tue, 23 Apr 2013 12:00:38 GMT

put()-function

Ksharp — Tue, 23 Apr 2013 12:07:40 GMT

PROC FORMAT ?

proc format ;

value fmt

1='A'

2='B'

;

run;

data a;

input a;

b=put(a,fmt.);

cards;

;

run;

Ksharp