Hi Everybody, Long time reader, first time poster! I'm trying to load data from an excel file. I know what you're going to tell me: "Why don't you use .csv?" Well I can't because it's a whole mess of files that a colleague sends after it's exported out of a platform. I'm supposed to take these files, merge them into one dataset, as automatic as possible. So what do I do? I use proc import, get all the data and stack that mess into usable information. Until I ran into a snag. The thing is some columns in some of the files are empty; so when the data is read by the proc import then it is automatically turned into text. The data looks very simple: Date Unit mm/dd/yy 10000 And when it's: Date Unit (blank) (blank) Then I can't append the different datasets on the data step because of the different formats. Is there any way specify a format using proc import? Is there any way to detect the file is blank and it will just return zero and won't get merged with the rest? Any help is greatly appreciated! Thanks, Frank
... View more