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 |
| 1 | one |
| 2 | two |
| 3 | |
| . | . |
| . | . |
| . | . |
| 50 | fifty |
| 100 | hundred |
thanks in advance
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;
data have;
input number;* description;
cards;
1 one
2 two
;
data want;
set have;
description=put(number,words100.);
run;
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;
Nearly 200 sessions are now available on demand in the Innovate Hub.
Watch Now →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.