topic Re: leading zero issue in SAS Procedures

leading zero issue

yarrado2 — Mon, 16 Sep 2013 18:08:01 GMT

Hi ,

I have a text file with the following 3 values separated by spaces :

056746 Sr M

When I read this file in SAS and print the output, the leading 0 is missing. Eg: 056746 is displayed as 56746.

Can you please help me with command and syntax that will help me display the entire value(with leading zeros)

I tried various possibilities with FORMAT, but with no success. Please help asap.

Thanks for your time

LinusH — Mon, 16 Sep 2013 18:15:05 GMT

Use the z. format, or import the column as char.

Linlin — Mon, 16 Sep 2013 18:18:00 GMT

did you try

format your_variable z6.; ?

ballardw — Mon, 16 Sep 2013 19:56:25 GMT

Are you doing arithmetic with the first variable such as sum, mean, standard deviations? If not make it character and avoid lots of issues.

yaswanthj — Tue, 17 Sep 2013 14:32:02 GMT

Hi..

Use format Z. is the best way to keep leading Zeros..

data test;

input ID first $ last $;

format id Z6.;

cards;

056746 Sr M

;

run;

proc print;

run;