BookmarkSubscribeRSS Feed
Wanderer
Calcite | Level 5
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
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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

hackathon24-white-horiz.png

Join the 2025 SAS Hackathon!

Calling all data scientists and open-source enthusiasts! Want to solve real problems that impact your company or the world? Register to hack by August 31st!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 860 views
  • 0 likes
  • 2 in conversation