topic Re: How to convert 1 as one and 2 as two without Proc format in SAS Procedures

How to convert 1 as one and 2 as two without Proc format

SushilKumar — Thu, 13 Feb 2014 10:10:49 GMT

Hi,

Could any one help me how to convert Numeric Value 1 as one and 2 as two and 3 as three............ etc without using Proc Format

for egi do have dataset like,

X	1
Y	2
Z	3
A	4
B	5

and i want dataset to be like below without using Proc Format

X	1	One
Y	2	Two
Z	3	Three
A	4	Four
B	5	Five

and also is it possible to convert 1as First and 2 as Second and 3 as Third etc without using Proc Format

Re: How to convert 1 as one and 2 as two without Proc format

statistician13 — Thu, 13 Feb 2014 16:50:25 GMT

How about this:

data work.temp;

input letter $ number;

cards;

X 1

Y 2

Z 3

A 4

B 5

;

run;

data work.temp;

set work.temp;

wordnumber=put(number, words23.);

run;

proc print data=work.temp;

run;

Re: How to convert 1 as one and 2 as two without Proc format

ballardw — Thu, 13 Feb 2014 16:55:43 GMT

By "without proc format" do you mean without a custom format?

I think the easiest for the first requirement would be

data want;

set have;

/* assumes value is the name of the variable that contains the numeric 1,2,3 etc*/

num = put(value,words10.);

run;

If you somehow happen to find a dataset with the values and words you need you could use either a hash table or sql to match and bring in the word.

WHY can't you use proc format?

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Wed, 19 Feb 2014 06:46:49 GMT

Thanks to every one,

Could anyone help me is it possible to convert one as First and 2 as Second and goes on

X	1	First
Y	2	Second
Z	3	Third
A	4	Fourth
B	5	Fifth

Re: How to convert 1 as one and 2 as two without Proc format

Kurt_Bremser — Wed, 19 Feb 2014 08:17:00 GMT

If the range of input values is a) numeric with constant intervals and b) rather small, you could do the following:

data xxx (drop=lookup);

set yyy;

retain lookup 'First Second Third Fourth Fifth Sixth SeventhEighth Ninth Tenth ';

Wordnumber = substr(lookup,(number-1)*7+1,7);

run;

Adjust the formula in the substr() to your actual needs.

Re: How to convert 1 as one and 2 as two without Proc format

Tom — Wed, 19 Feb 2014 15:13:42 GMT

SCAN() would be easier.

Wordnumber = scan('First Second Third Fourth Fifth Sixth Seventh Eighth Ninth Tenth',number);

Re: How to convert 1 as one and 2 as two without Proc format

jaredp — Wed, 19 Feb 2014 18:12:07 GMT

This sounds like a homework assignment. :smileysilly:

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Thu, 15 May 2014 05:09:39 GMT

jairedp you can easily convert this

X	1	First
Y	2	Second
Z	3	Third
A	4	Fourth
B	5	Fifth

If you have 22 ,56 99 etc how will display that in words like twentytwo, fiftysix,lke that

Re: How to convert 1 as one and 2 as two without Proc format

jaredp — Thu, 15 May 2014 14:46:23 GMT

A "correct answer" has been provided. Did it not work for you?

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Mon, 02 Jun 2014 11:16:20 GMT

Re: How to convert 1 as one and 2 as two without Proc format

Kurt_Bremser — Mon, 02 Jun 2014 12:00:04 GMT

You can either:

- use proc format to specify a custom label for all the values you intend to cover

- generate a lookup table with the labels and join your dataset with it

- use the same lookup table as input for a hash object and use that in the data step