CODEWITHSUNDEEP
sas
smackersz88
smackersz88

Reputation: 93

Add zero before decimal place in SAS

Hello I need to add a zero for only results and ranges are in a .2, .3 etc format but not tall values are like this. What would be the most efficient way to do this?.

I've only tried to format it using a w.d but the issue is that not all values are the same and all I want to do is add a zero for where they are applicable without messing the format of the other values.

format lborres lbornlo lbornhi z7.2.;

enter image description here

Upvotes: 0

Views: 1218

Answers (2)

Jason Duncan-King
Jason Duncan-King

Reputation: 56

Are you value all less than 1? eg.

.3
.002
.752
.056

If not you would have to create picture format for each unit (thousands, hundreds, tens etc)

If they are all less than 1, z5.3 I believe will give you - 5 being the total length and 3 the number of decimal points.

data test;
  format A z5.3;
  a=.3; output;     /* 0.300 */
  a=.002; output;   /* 0.002 */
  a=.752; output;   /* 0.752 */
  a=.056; output;   /* 0.056 */
run;

Upvotes: 0

Reeza
Reeza

Reputation: 21264

If your variable is numeric you can apply a standard format and that would add the leading zero.

ie

format yourVariable 8.1;

If your variable is character then you can test if the first character is a period and add a 0 or you can convert it to a number and store it that way instead. Option 2 is illustrated first as the first option overwrites the variable so to avoid any issues with that it's shown after.

data want;
   set yourInputDataSet;

   *Option 2;
   new_numeric_variable = input(yourVariable, 8.);
   format new_numeric_variable 8.1;

   *Option 1;
   if yourVariable =: '.' then yourVariable = catt('0', yourVariable);


run;

And as always, if your variable is incorrectly formatted this way, I would check my data import step and see if I can fix it there instead of after the fact. This is especially true if you used PROC IMPORT on a text file, where you can easily control the variable format and types as they're read in.

Upvotes: 1

Related Questions