topic Re: Add trailing zeros to character data in SAS Programming

Add trailing zeros to character data

Patty — Wed, 29 Jan 2014 17:47:39 GMT

I had such a wonderful response to add leading zeros to data that I am now asking for help in adding training zeros.

Any suggestions would be appreciated.

Re: Add trailing zeros to character data

Amir — Wed, 29 Jan 2014 17:51:52 GMT

Hi,

It would help to provide examples of what you have and what you'd like it to change to.

Is this character or numeric data?

Regards,

Amir.

Re: Add trailing zeros to character data

Patty — Wed, 29 Jan 2014 18:00:43 GMT

It originally was numeric and I converted the data to character data. I was able to add a leading zero by doing this but I also need to add a trailing zero as well.

example: '3' to '030'

Re: Add trailing zeros to character data

Amir — Wed, 29 Jan 2014 18:06:34 GMT

Hi,

Consider either multiplying the numeric by 10 before converting it to character, or when it is character consider using the cats() function, e.g.:

var2=cats(var1,'0');

Regards,

Amir.

Re: Add trailing zeros to character data

Astounding — Wed, 29 Jan 2014 18:18:53 GMT

You might want to consider adding both the leading and trailing zero in one step:

charvar = put(numvar * 10, z3.);

Re: Add trailing zeros to character data

Haris — Thu, 13 Mar 2014 20:54:55 GMT

I have a similar problem. When I merge number with decimals, the decimals that are zero get cut off. For example, merging 2.500 and 6.050 would produce 2.5-6.05. How do I get the program to stop cutting off the zeroes and output 2.500-6.050?

Re: Add trailing zeros to character data

ballardw — Thu, 13 Mar 2014 22:00:35 GMT

The values aren't cut off it is a result of internal numeric storage.

You don't show how you have attempted to create your 2.500 - 6.050 but the likeliest answer is going to involve a format that displays at a given precision.

For example a value of 2.5 will display at 2.500 when using something like F6.3 which forces every appearance to show 3 values to the right of a decimal point.
One way to create a string of your example

data _null_;

x= 2.5;

y= 6.05;

result = catx(' - ',put(x,7.3),put (y,7.3));

put result;

run;