Hi SAS Forun, I have hard coded the same date in 2 different places in a lengthy code (see yellow highlights).  data k.Arr_Histry_filtrd_haphaz_rmvd;     set tt;     by bank_number account_number current_date;     if first.account_number       then _f1 = (current_date ne '28FEB2010'd and Arrears_Band                     ne 'Current') ;         retain _f1;     if _f1 ne 1 then output; drop _:; run; After the above code, I have several other code pieces below. …………………………………. …………………………………. …………………………………. …………………………………. …………………………………. Then I get another code like below. data t1 k.write_off_History_GE_FEB2010; /*you should use a.write_off_History_GE_FEB2010 file throughout and not a.write_off_History*/ set k.write_off_History; if post_date <'28FEB2010'd then output t1; else output k.write_off_History_GE_FEB2010; run; Question: I want to turn the above hard coding into a macro. Could any macro expert please let me know if the following macro is logically OK? Can I use the same macro name, i.e. %macro first_1(mth), in two different places in the same code? %let t_1=28FEB2010; %macro first_1(mth); data k.Arr_Histry_filtrd_haphaz_rmvd;     set tt;     by bank_number account_number current_date;     if first.account_number       then _f1 = (current_date ne '&mth'd and Arrears_Band                     ne 'Current') ;         retain _f1;     if _f1 ne 1 then output; drop _:; run; %mend first_1; %first_1(mth=&t_1); After the above code, I have several other code pieces below. …………………………………. …………………………………. …………………………………. …………………………………. …………………………………. Then I get another code like below. %macro first_1(mth); data t1 k.write_off_History_GE_FEB2010; /*you should use a.write_off_History_GE_FEB2010 file throughout and not a.write_off_History*/ set k.write_off_History; if post_date <'&mth'd then output t1; else output k.write_off_History_GE_FEB2010; run; %mend first_1; %first_1(mth=&t_1); Thank you for your help Mirisage ... View more

Hi SAS Forum, I have exported 10 SAS data sets to 10 different tabs of a same Excel file named “model_test.xls”. The code piece shown below, which is a part of a relatively long code,  does the exporting job correctly. %macro name1(sheet_name,which_bank); PROC EXPORT DATA=k.Source_Data_Bank_&which_bank OUTFILE="\\Ad.noki.com\Cccp\Home\Fredrick\model_test.xls" DBMS=XLS REPLACE; sheet = "&sheet_name"; PUTNAMES=YES; run; %mend name1; %name1(sheet_name=Source_Data_Bank_10,which_bank=10); %name1(sheet_name=Source_Data_Bank_20,which_bank=20); %name1(sheet_name=Source_Data_Bank_30,which_bank=30); %name1(sheet_name=Source_Data_Bank_40,which_bank=40); %name1(sheet_name=Source_Data_Bank_50,which_bank=50); %name1(sheet_name=Source_Data_Bank_70,which_bank=70); %name1(sheet_name=Source_Data_Bank_80,which_bank=80); %name1(sheet_name=Source_Data_Bank_90,which_bank=90); %name1(sheet_name=Source_Data_Bank_100,which_bank=100); Question: When I try to open the excel file named “model_test.xls”, a dialogue box appears like this. File error: Data may have been lost ok But when I click the ok button in the above dialogue box, then the excel file comes with 10 tabs with correctly exported data. Have anyone of you come across this situation, and how to get rid of this dialogue box? Thank you Mirisage ... View more