Yes, sorry I wasn't explicit... but that works perfectly! Thank you! ... View more

I think of informats being for input rather than output, so I find this posting a bit confusing. For input use informat YYMMDD8. and for output read the doc for YYMMDDx. When x=N you get no delimiters. ... View more

Here is a macro I used to read the same 8 variables (SchNum Last First Middle DOB Sex Grade Race) from 4 different csv files which have the same column headers. ********************************************************************************************* %macro crs (sch=); data &sch; informat DOB yymmdd.; format Schnum $3.Last $40.First $20. Middle $20. Sex $40. Grade $2. Race $40. ; infile "G:\Departments\Research\MAP\0607\CRF_Winter2007\&sch..csv" dsd missover lrecl=32767 firstobs=2; input SchNum Last First Middle DOB Sex Grade Race; run; %mend; %crs(sch=oms);%crs(sch=sms);%crs(sch=tsms);%crs(sch=wmms); ... View more

since you have control of the workbook, name a range to cover all the columns and rows you need, in the sas-name style (starting with letter or underscore and the rest containing numbers, letters and/or underscores, and no longer than 32). Then the workbook can work as a sas library. The rangename is a tablename allowing: libname book 'your workbook.xls'; proc contents data= book.rangename; * where rangename is the name you gave that range in excel); run; no need for proc import ... View more