Hello everyone, I would like to create a macro variable for a texted value such as ' in July'.  Notice there is a leading blank ahead of the word 'in'.  Here is how i define the macro variable: %let month =  in July;  (there is a leading blank to the left of the word 'in') SAS automatically removes the leading and training blanks for a macro variable and as a result the leading blank is removed.  How can I include the leading blank for a macro variable? Thank you very much ... View more

Hello Everyone, I have a macro called Copy_Datasets.  It reads an input file and appends the word "holiday" to the end of the file name if today's date is one of the holidays defined in the holiday_file.  When I run the macro i get an error "Required operator not found in expression: &today. in (&Holiday_List.)" from the macro.   Does anyone have any suggestions as to how I can fix this issue?  I have listed my code below.  Thank you! Data holiday_file; input holidays dates9.; datalines; 16jun2014 04jul2014 01sep2014 ; run; proc sql; select distinct holidays into : holiday_list      seperated by ', '      from holiday_file; quit; %Let today = $sysfunc(today()); %macro Copy_Datasets(infile); %if &today. in (&holiday_list.) %then %do;      data &infile._holiday;      set &infile.;      run; %end; %mend; %Copy_Datasets(cust_file) ... View more

Hello Everyone, I am trying to export data from SAS to an existing sheet in an Excel doc called Cust_Report.  The sheet name is "MTD".  I would like to overwrite the existing sheet but it creates a new sheet called "MTD1" instead.  Does anyone have any suggestions on how to replace an existing sheet in Excel?  I use SAS 9.3.  Thank you so much in advance for any input!  Here is my code: PROC EXPORT DATA = Total OUTFILE = "C:\My_docs\Cust_Report.xlsx" DBMS=EXCEL2000 REPLACE; Sheet = "MTD"; QUIT; Thank you! ... View more

Hello, I have created a macro that gets executed for everyday of the month.  In the code below &beg_date and &end_date represent the first date and last date of a month (i.e. 20130901 and 20130930).  They have already been defined in previous steps.  The problem is with the "i" in the do loop.  The "i" seems to work just fine with the "put i" statement.  However, when I call the macro %month_end it does not reconize the i being paseed. The log says "Macro variable DT resolves to &i.".  I have posted my code below.  If anyone has a different approach (not using the do loop) I would love to hear it.  Any input would be greatly appreciated Just a little more information, I am trying to run the macro 30 times and the value of "dt" should be from 20130901 to 20130930. %macro month_end (dt); data aaa_&dt.; XXXXX run; %mend; data _null_; do i = &beg_date. to &end_date.;   put i;   %month_end(&i.); end; run; ... View more