New SAS User

Completely new to SAS or trying something new with SAS? Post here for help getting started.
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

dear all

greetings of the day

 

i have to convert number into description of the number in text form by using SAS code 

for example, 

 

number description
1one
2two 
3 
..
..
..
50fifty
100hundred 

 

thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
ed_sas_member
Meteorite | Level 14

Hi @srikanthyadav44 

 

You can try this:

 

NB: The WORDSw. format converts numeric values to their equivalent in English words.

 

data want;
  do number=1 to 100;
    description=put(number,words100.);
    output;
  end;
run;

View solution in original post

3 REPLIES 3
novinosrin
Tourmaline | Level 20

data have;
input number;* 	description;
cards;
1	one
2	two 
;

data want;
set have;
description=put(number,words100.);
run;
ed_sas_member
Meteorite | Level 14

Hi @srikanthyadav44 

 

You can try this:

 

NB: The WORDSw. format converts numeric values to their equivalent in English words.

 

data want;
  do number=1 to 100;
    description=put(number,words100.);
    output;
  end;
run;

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2350 views
  • 2 likes
  • 4 in conversation