BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Dani08
Obsidian | Level 7

I would like to add trailing zeros to character data in the following way - to fill up to maximum of 7 characters:

 

133P. -> 133P.00

39B.. -> 39B..00

22EG.-> 22EG.00

R0832 -> R083200

 

Is there a way to do this?

 

Many thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

Put the length statement before the set statement.

 

Have you tried my suggested code. The following contains it and a slight variant of @Reeza's code:

 

data have;
  input old_var $;
  cards;
133P.
39B..
22EG.
R0832
;

data want;
  Length new_var1 new_var2 $7;
  set have;
  new_var1='0000000';
  substr(new_var1,1,length(old_var))=substr(old_var,1,length(old_var));
  new_var2 = substr(Catt(old_var, '0000000'),1,7);
run;

Art, CEO, AnalystFinder.com

 

View solution in original post

10 REPLIES 10
Reeza
Super User

Length new_var $7;

new_var = Catt(old_var, '0000000');

 

Add 7 zeroes to the end, but assign a length of 7. This causes the variable to truncate after 7th char meaning you get the variable plus the 0s, as desired. 

Dani08
Obsidian | Level 7
Thank you for your reply.

is it important where I put the length statement?
If I place it before the set statement, the new_var is blank,
if I place it after the set statement, I get 7 trailing '0's at the end...

please let me know if I am doing something wrong.
ballardw
Super User

@Dani08 wrote:
Thank you for your reply.

is it important where I put the length statement?
If I place it before the set statement, the new_var is blank,
if I place it after the set statement, I get 7 trailing '0's at the end...

please let me know if I am doing something wrong.

Did you include a $ sign? If not then your new_var was numeric and wouldn't hold the result of a character value very well.

data want;
   length New_var $ 7;
   set yourdataset;
   New_var = substr(translate(code,'0',''),1,7);
run;

Another approach.

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Why do you have characters in it?  This makes the problem far more complicated than necessary.  Instead of just putting the number to Zx. format, you now need to check length and repeat and concat:

data have;
  have="33p.";
  want=cats(have,repeat("0",5-lengthn(have)));
run;
Dani08
Obsidian | Level 7

It is necessary to have characters in this variable. They are medical read codes.

art297
Opal | Level 21

The following should work:

 

data want;
  input have $;
  want='0000000';
  substr(want,1,length(have))=substr(have,1,length(have));
  cards;
133P.
39B..
22EG.
R0832
;

HTH,

Art, CEO, AnalystFinder.com

 

art297
Opal | Level 21

Put the length statement before the set statement.

 

Have you tried my suggested code. The following contains it and a slight variant of @Reeza's code:

 

data have;
  input old_var $;
  cards;
133P.
39B..
22EG.
R0832
;

data want;
  Length new_var1 new_var2 $7;
  set have;
  new_var1='0000000';
  substr(new_var1,1,length(old_var))=substr(old_var,1,length(old_var));
  new_var2 = substr(Catt(old_var, '0000000'),1,7);
run;

Art, CEO, AnalystFinder.com

 

Dani08
Obsidian | Level 7
Is there a way to carry this out for the whole dataset? I have 1500+ observations...

art297
Opal | Level 21

Not sure what your question is. The above approaches are all designed to do the task for all of the records in the file.

 

Art, CEO, AnalystFinder.com

 

Dani08
Obsidian | Level 7
Thank you! I am new to SAS, sorry for the confusing questions. This solved my problem.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 14527 views
  • 2 likes
  • 5 in conversation