BookmarkSubscribeRSS Feed
yarrado2
Calcite | Level 5

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

4 REPLIES 4
LinusH
Tourmaline | Level 20

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

Data never sleeps
Linlin
Lapis Lazuli | Level 10

did you try

format your_variable z6.; ?

ballardw
Super User

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
Fluorite | Level 6

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;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1054 views
  • 0 likes
  • 5 in conversation