topic Re: adding trailing zeros & period to fields in SAS Programming

adding trailing zeros & period to fields

archibald — Wed, 18 May 2016 03:54:41 GMT

Hi ,

I need to add trailing zeros and period field, any help would be appreciated.

data have;

Input alpha : $5.;

cards;

00100

1019

099

185

1010

0803

12398;

run;

data want;

set have;

test1=substr(alpha,1,3)||'.'|| substr(alpha,4,2); /* add a period to fields*/

run;

In addition to adding a period , I would want to add trailing zeros so to have :

test1

001.00

101.90

099.00

185.00

101.00

080.30

123.98;

Re: adding trailing zeros & period to fields

sowmya — Wed, 18 May 2016 06:11:11 GMT

You could read the data as below:

data have;

Input alpha;

cards;

00100

1019

099

185

1010

0803

12398;

run;

data formatted;

format new z6.2;

set have;

new=alpha/100;

run;

This should work, however in the example u gave the data is not consistant. For example, if the first row has trainling zeros, how come rest of them dont have.

Re: adding trailing zeros & period to fields

Kurt_Bremser — Wed, 18 May 2016 06:20:29 GMT

data have;
Input alpha : $5.;
cards;
00100
1019
099
185
1010
0803
12398
;
run;

data want;
set have;
substr(alpha,length(alpha)+1) = '00000';
length test1 $6;
test1 = substr(alpha,1,3) !! '.' !! substr(alpha,4);
run;

Re: adding trailing zeros & period to fields

archibald — Wed, 18 May 2016 13:06:54 GMT

@sowmya not all the data will need a trailing zeros, as you can see on what the result should look like.

Thanks!

Betreff: adding trailing zeros & period to fields

andreas_lds — Wed, 18 May 2016 14:33:28 GMT

Just replace the blanks in alpha with zeros an your code will produce the required resulsts.

data want;
set have;

alpha = translate(alpha, '0', ' ');
test1=substr(alpha,1,3)||'.'|| substr(alpha,4,2); /* add a period to fields*/
 
run;

Re: adding trailing zeros & period to fields

archibald — Thu, 19 May 2016 01:07:43 GMT

This is perfect!Thank you very much!

Betreff: adding trailing zeros & period to fields

archibald — Thu, 19 May 2016 01:08:22 GMT

Another great solution. Thank youvery much!