Try changing your set statement as below: %let mth=JUL; libname  myxls1 "&path\Monthly_Summary_by_LATSK_In_Tran_In_Month_SK_GTET_&mth.2013.xlsx"; data &mth.2013;     set myxls1."BO_Query$"n; run; libname myxls1 clear; ... View more

If i understand you correctly, you don't really want week number but the week start or the previous Monday's date in each of your records. if you have a variable DATE for the date of each sale then if weekday(date)=1 then weekstart=date-6;else                                    weekstart=date-weekday(date)+2; will put the previous Mondays date in weekstart Hope it's what you need ... View more

You can use the LIBNAME statement to access Excel files Like this: LIBNAME XXX EXCEL "C:\TEST.XLS"; Then set a length/format before reading from the selected sheet DATA TEST;    LENGTH GVKEY $6.;    SET XXX."SHEET1$"N;    RUN; That way you read it as character. ... View more

You could try something like this: proc sort data=transfile;    by customer last_trans_date; data xxx;    set transfile;    retain hold_last;    hold_last=lag1(last_trans_date);    if last_trans_date gt hold_last+90 then    do;         etc............................................ ... View more

You need to use the option MIXED=YES in the import ... View more

Hi Bruce I use a bat file to set pgm, log and output like this- set sas=C:\Program Files\SAS\SAS 9.1\sas.exe set src=C:\SAS\Source\ set log=C:\SAS\Log\ set prt=C:\SAS\Output\ "%sas%" "%src%testpgm.sas" -nosplash -print "%prt%" -log "%log%" exit That way they'll all be named the same as the program Chris ... View more

I'm using 9.1.3 I just used %let i=2; %let name2=acct_num; data x;    acct_num=12345;    put &&name&i; run; ... View more

Hi again sorry (forgot one myself) PUT &&name&i; Chris ... View more

Hi Steve I think you're getting bogged down with ampersands - it's just PUT &name&i; Chris ... View more