BookmarkSubscribeRSS Feed
fengyuwuzu
Pyrite | Level 9

I have a number of data files, from different providers, and they used different formats for the dates, like:

yyyymm yyyy-mm mm-yyyy yyyy/mm

 

Sometimes SAS reads in as bes12. numberic, sometimes SAS reads in as $8. characteric, and sometimes SAS automatically recognizes as date and added the day 01 to become 01MMMYY:00:00:00 format.

 

So I have to deal with every different case.

I hope there is a way that I can control the import to end up one format in SAS, so that I only need to deal with one format conversion.

Any suggestions?

 

Thank you!

3 REPLIES 3
Reeza
Super User
Welcome to the world of data analysis.

Ideally, each data provider has a standard and you can customize your code for that provider. Unfortunately there's no way to guarantee that proc import will format variables the way you want. To gain control of the format/type you need to write your own code. For CSV/TXT this is relatively easy, especially if you have data dictionaries.
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Firstly, and most important, is to get the transfer agreement in place.  This would be a document which details what data, and in what format the data is in.  Without this document you will not be sure what the data reflects, or be able to handle changes.  Once you have this setup for each vendor then the coding is very simple, a datastep import based on the agreement.  Like 90% of programming, the actual work should be in the documentation, the code then writes itself.

 

fengyuwuzu
Pyrite | Level 9
Thanks for the advice.

Now I have figured out how to convert all these formats. This is a very nice practice actually. So in future I know how to take care of these.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 3 replies
  • 1535 views
  • 0 likes
  • 3 in conversation