Help using Base SAS procedures

Urgent Help for Padding length of Charachter Variable

Reply
New Contributor
Posts: 2

Urgent Help for Padding length of Charachter Variable

I have a variable which contains 2 character digits per observation. For e.g
AA , BB , BC & so on....

My problem is Of some 30 lakhs such variables i have in my data few are having only one digit . For eg. A .

I need to manintain 2 digit length in character format.
So if its just 'A' then i need to have these observations as 'AX' or like

Zw. format doesn't work since it needs Numeric variable to start with whereas I have a character variable. Message was edited by: Wanderer
Super Contributor
Super Contributor
Posts: 3,174

Re: Urgent Help for Padding length of Charachter Variable

Use a DATA step approach with the TRANSLATE function to convert blank to some non-blank character.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

translate function site:sas.com
Ask a Question
Discussion stats
  • 1 reply
  • 151 views
  • 0 likes
  • 2 in conversation