Hello SAS Community,
I am trying to create a new numeric variable (DA3) from two seperate numeric variables (DA1, DA2) . I would like my new variable or DA3 to be DA1 and DA2 seperated by a decimal. So for example,
DA1 | DA2 | DA3 |
780 | 6 | 780.6 |
124 | 78 | 124.78 |
54 | 6 | 54.6 |
Any advice would be much appreciated! Thanks in advance!
Post test data in the form of a datastep. We cannot see your data and so have to make assumptions, so I am going to assume that da1 and 2 are character, and the result should be character:
data want; set have; da3=catx('.',da1,da2); run;
Post test data in the form of a datastep. We cannot see your data and so have to make assumptions, so I am going to assume that da1 and 2 are character, and the result should be character:
data want; set have; da3=catx('.',da1,da2); run;
Thanks, exactly what I was looking for.
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.