Hi @Risi
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;
Hi @Risi
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;
Use the words format.
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".
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.