05-10-2015 11:57 PM
I have an excel file with a date column that looks something like this:
The format is general and not in date
my importing procedure is the following:
PROC IMPORT OUT= board1
DATAFILE= " K:\thesis comp bankruptcy\board1.xlsx"
DBMS= EXCEL REPLACE;
sheet = "Sheet1";
What I would like to know is how to make such that when I import the file the dates are in mmddyy10. form.
05-11-2015 01:21 AM
Looks like those columns are stored as text in Excel. Either make sure that dates are stored as Excel dates and have a suitable format, or save the spreadsheet as a .csv file and write a suitable data step for import.
05-11-2015 04:23 AM
Should really make a sticky on topic Excel plus import. Totally agree, Excel is not a data transfer format. Save to CSV and use a datastep, don't let proc export/import guess what you want to do etc.