I think you can just add a line to your LOAD, like:
Makedate(Year,Month) as Date,
MakeDate(Year, Month) creates a date: 1st day of Month in Year (this is equivalent to write Makedate(Year, Month, 1), since Day parameter defaults to 1).
I hope this is what you want, if not, just post your excel (preferred, or SAS) code.
swuehl - thanks for the reply....
I acutally figured out the first problem - had the makedate in the SELECT and not the LOAD.....
but still not getting out exactly what I want with the code below - the month and year are coming in as string from the DB so I thought I needed to convert to number for the makedate....
the below code results in a - in the Date field. same result without the Num# conversion
Num#(Month,'0') as Month,
Num#(Year,'0') as Year,
Makedate((Num#(Month,'0')), (Num#(Year,'0'))) as Date;
SQL SELECT ......