BookmarkSubscribeRSS Feed
jcis7
Pyrite | Level 9

1.  Do you see a problem wtih having a field that has different length numbers (Type 1 has 10 digits, Type 2 has 8 digiits)   that may have leading zeros  if I want to do Update the Master table with a transaction table or match merge or deduplicate?

2.  How would you export the file into MS Access with the correct number of leading zeros retained?

ID                             Type

0123948578                1

0593827108                1

2983748597                1

02498377                    2

00938478                    2

Thanks!

4 REPLIES 4
allurai0412
Fluorite | Level 6

hi,

if your question is about zeros ...please try this..

format id z5.

For  5 digits ....

format id z10.

Regards

ALLU

jcis7
Pyrite | Level 9

Thanks!  How do you export the same field with two different lengths into a MS Access database retaining the leading zeros?  The only way I can think of is if you break the 10-digit facilities into 1 dataset and the 8 digit facilites into another dataset and format them separetly using the z format?

SASKiwi
PROC Star


To ensure you retain leading zeros while exporting it would be preferable to convert ID to character columns:

if type = 1 then ID1 = put(ID, z10.);

else if type = 2 then ID2 = put(ID, z8.);

Its good practice to store IDs as character anyway so things like leading zeroes don't get lost.  

jcis7
Pyrite | Level 9

Thank you ! Very helpful!!

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
  • 4 replies
  • 1657 views
  • 3 likes
  • 3 in conversation