12-22-2015 04:36 PM
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.
12-22-2015 05:19 PM
12-23-2015 05:37 AM
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.
12-23-2015 02:51 PM