Gday,
I'm not sure if I really need to save a format as text however, it's the only solution I can think of right now. I just don't know how to do it.
I want the following table (it will only ever have four lines):
Income | Success | |
Jan-12 | 831.59 | 1.751% |
Jan-11 | 923.87 | 1.759% |
Change | 11.10% | 0.47% |
^^
The first two records is in my data. The third record is the percentage difference between the above two records (Success and Income are both formatted numbers) . I can do that, however I want to maintain the formats.
Obviously the percentage difference will be fine for Success (although the number of decimal places would be quite right, I could probably live with it) but what about Income? This is why I think I need to convert these values into text.
How would I do that?
Thanks.
You can use the PUT function. For example in a data step.
data want ;
set have ;
if col1='Change' then incometext = put(income,percent.);
else incomtext=put(income,8.2);
run;
It will be good if you use the numeric variable for calculation purpose and for reporting you can use the Character with unique formats
You can use the PUT function. For example in a data step.
data want ;
set have ;
if col1='Change' then incometext = put(income,percent.);
else incomtext=put(income,8.2);
run;
Thanks Tom,
I think I had a brain snap yesterday.
Worked perfectly as described.
If you can sure the value of income could not be between 0 and 1, then you can use embed format.
But I still recommend you to use the method Tom proposed.
data want; input Income Success percent8.; format success percent8.2; cards; 831.59 1.751% 923.87 1.759% .1110 0.47% ; run; proc format; value x 0-1=[percent8.2] ; run; data want; set want; format income x.; run;
Ksharp
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.