BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
djbateman
Lapis Lazuli | Level 10

Chris,

 

1.  As people have talked me through this, I now realize that I will never have a numeric variable that will need to go through this transformation, so I'm done with numeric variables.  I just need to try to work my way through character values.

 

2.  The "001-101-101" was not an example.  I was just showing in a reply that I would look for a subject in that manner in order to manually change the data the DM changed.  I'm not trying to keep leading zeroes in SUBJID, because you're right, SAS does keep that in the proper format.  It's SITEID that is just "001" that gets truncated to "1".

 

3.  Don't worry about it.  Many other respondents seem to be up to speed, and we'll get through this.

ChrisNZ
Tourmaline | Level 20

Ok, I'll leave it here then.

 

Let me re-emphasize this though:

 

You have to decide on a format that the variables must follow, and enforce this format.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 16 replies
  • 3457 views
  • 1 like
  • 7 in conversation