topic Re: Adding some numbers to variable and calculating the length of variable in New SAS User

Adding some numbers to variable and calculating the length of variable

Nini1 — Fri, 04 Sep 2020 20:49:47 GMT

Hello everyone, I'm new SAS user and could you please help me to solve some problem? how can I add some number to the existing variable? e.g. in this table it is shown that I added '25' to all the number in variable 'num' and got a new variable 'number'. One more thing, how can I calculate how many elements does each data have? e.g. 2364 has 4, 8467 again 4, 253679 has 6 and so on . So I want to have another column that will reflect the length of each data. I used function length but it did not work.

thank you in advance

num	number
2365	252365
8467	258467
253679	25253679
4533	254533

Re: Adding some numbers to variable and calculating the length of variable

PaigeMiller — Fri, 04 Sep 2020 20:59:05 GMT

Assuming the original variable is a character variable (is it?), this will prepend the characters '25' in front of it.

number=cats('25',num);

Actually, the above ought to work even if NUM is numeric and not character, but NUMBER will always be character.

As far as how many elements each string has, you can use the LENGTH() function.

Re: Adding some numbers to variable and calculating the length of variable

novinosrin — Fri, 04 Sep 2020 21:00:24 GMT


data have;
input num;*	number;
cards;
2365	252365
8467	258467
253679	25253679
4533	254533
;

data want;
 set have;
 new_num=input(cats('25',num),32.);
 length=lengthn(cats(num));
run;

Re: Adding some numbers to variable and calculating the length of variable

Nini1 — Fri, 04 Sep 2020 22:36:44 GMT

Thank you very much

Re: Adding some numbers to variable and calculating the length of variable

Ksharp — Sat, 05 Sep 2020 11:58:18 GMT

Assuming it was always positive number.

data have;
input num;
new= 25*10**(int(log10(num))+1) + num;
cards;
2365	252365
8467	258467
253679	25253679
4533	254533
;