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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.