topic Re: how to change data one as 1 and two as 2 in SAS Programming

how to change data one as 1 and two as 2

Risi — Wed, 18 Dec 2019 12:26:51 GMT

Re: how to change data one as 1 and two as 2

ed_sas_member — Wed, 18 Dec 2019 13:08:37 GMT

You can try this:

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

data have;
	input V1$;
	datalines;
one
two
three
seven
;
run;

data convert;
  do num=1 to 100;
    V1=put(num,words100.);
    output;
  end;
run;

proc sql noprint;
	create table want as
	select a.V1, b.num
	from have as a left join convert as b on a.V1 = b.V1
	order by a.V1;
quit;

Have

Want

Re: how to change data one as 1 and two as 2

ballardw — Thu, 19 Dec 2019 17:10:44 GMT

Details matter.

Do you mean to change a TEXT value of 'one' to a numeric value of 1 for computation?

Or just to display a text value of 'one' as text value of '1'?

How many of these the text values are involved? Just 'one' and 'two' or a large number? Are there other text values in the variable that are not "numbers" such as "NA" or "missing".

Re: how to change data one as 1 and two as 2

ChrisNZ — Thu, 19 Dec 2019 02:03:00 GMT

Use the words format.