BookmarkSubscribeRSS Feed
didye
Calcite | Level 5

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

1

1

2

2

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

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

col2char

A

A

B

B

Is there a simple instruction to do this ?

Thanks for help!!!

2 REPLIES 2
LinusH
Tourmaline | Level 20

put()-function

Data never sleeps
Ksharp
Super User

PROC FORMAT ?

proc format ;

value fmt

1='A'

2='B'

;

run;

data a;

input a;

b=put(a,fmt.);

cards;

1

1

2

;

run;

Ksharp

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1258 views
  • 0 likes
  • 3 in conversation