BookmarkSubscribeRSS Feed
sanman
Calcite | Level 5

how can i get prefix zero for the following?

1

23

123

22.1

is it possible for me get in following manner?

001

023

123

22.1 or ?

2 REPLIES 2
BrunoMueller
SAS Super FREQ

Hi

 

The Zw. format will give leading zeros, see sample code below. Whether you use just a format or convert the number to a char value depends on what you want to use it for.

data have;
  infile cards;
  input
    value
  ;

  value_c = put(value, z3.);
  format value z3.;
cards;
1
23
123
22.1
;

proc print data=have;
run;

Bruno

ballardw
Super User

Is your variable numeric or character?

If numeric a format of Z5.1 might work but with an assigned decimal part ALL variables would show a decimal.

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
  • 1427 views
  • 0 likes
  • 3 in conversation