topic Re: How do I keep the number 0 when transforming char var into numeric? in New SAS User

How do I keep the number 0 when transforming char var into numeric?

frakje — Thu, 01 Aug 2019 11:08:16 GMT

I have a char var called "cpr". My problem is when i transforms it into a numeric variable it is dropping the the start number 0 for those obs who starts with zero and returns a 9 digit num var.

CPR = 0101079010

data want;

set have;

cpr2 = input(CPR,best12.);

run;

returned value of cpr2 = 101079010.

I want that to look like the same CPR var with 10 digits but as a num var instead of a char.

Kind regards Frank

Re: How do I keep the number 0 when transforming char var into numeric?

Ksharp — Thu, 01 Aug 2019 11:12:21 GMT

Add a format in it.

data want;

set have;

cpr2 = input(CPR,best12.);

format cpr2 z10.;

run;

Re: How do I keep the number 0 when transforming char var into numeric?

frakje — Thu, 01 Aug 2019 11:15:01 GMT

Thank you Ksharp