BookmarkSubscribeRSS Feed
Saikiran_Mamidi
Obsidian | Level 7

Ex: A= 123.22
      B = 44.21
Need output like
     A= 0000123.22
     B= 0000044.21

2 REPLIES 2
Kalind_Patel
Lapis Lazuli | Level 10

You can use zw.d format to get your desired results,

Try this code:

data want;
 value=123.22;
 format value z10.2;
run;
 

 

ed_sas_member
Meteorite | Level 14

Hi @Saikiran_Mamidi 

 

you can also use a PROC FORMAT with the PICTURE statement:

data have;
	input A B;
	datalines;
123.22 44.21
;
run;

proc format;
	picture myformat low-high = 9999999.99;
run;

data want;
	set have;
	format A B myformat.;
run;

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1206 views
  • 4 likes
  • 3 in conversation