topic Re: PROC FORMAT in SAS Procedures

PROC FORMAT

jopo12345678 — Fri, 07 Jul 2017 11:37:40 GMT

Hi,

How can I delete fist zero in variable ID_var it is charecter variable.

This is i have

This I want

Does anybody know?

Kurt_Bremser — Fri, 07 Jul 2017 11:40:09 GMT

data test;
id_var = "0000000010000100";
id_var = left(put(input(id_var,32.),best32.));
run;

FredrikE — Fri, 07 Jul 2017 11:43:32 GMT

Try this:

data test;

length id_var $32;

input id_var;

id_var = strip(put(input(id_var,32.),32.));

datalines;

0000000010000100

0000000010006377

0000000010042044

0000000010049190

;

run;

kiranv_ — Fri, 07 Jul 2017 11:44:09 GMT

there are multiple solutions in the below thread

jopo12345678 — Fri, 07 Jul 2017 11:45:18 GMT

I would like to change it to numeric variable...is there any option?

jopo12345678 — Fri, 07 Jul 2017 11:46:44 GMT

I would like to change it to numeric variable without datalines statement.

Kurt_Bremser — Fri, 07 Jul 2017 11:48:21 GMT

data want;
set have (rename=(id_var=id_char));
id_var = input(id_char,32.);
drop id_char;
run;