topic Re: Creating a new variable in SAS Programming

Creating a new variable

mtherr828 — Tue, 24 Jan 2017 17:31:21 GMT

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!

Re: Creating a new variable

RW9 — Tue, 24 Jan 2017 17:37:27 GMT

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;

Re: Creating a new variable

mtherr828 — Tue, 24 Jan 2017 17:43:18 GMT

Thanks, exactly what I was looking for.