Hello i have a code which needs to conditionaly import an text file. dates are dynamic and cant be hardcoded, we import them from an excel file and add them to a macro variable, which we use to conditionaly import a text file. but i am having issues with open if condition. if the same condition is passes in a data step, i am able to resolve it with out any issues.   PROC IMPORT OUT= dates_file DATAFILE= "D:\test\dates.xls" DBMS=xls REPLACE; RUN; proc sql ; select strip(start_dt) into :stdt from operational where start_dt ne '' ; select strip(end_dt) into :endt from operational where end_dt ne '' ; quit; 　 %let d_today=%sysfunc(putn("&sysdate9"d,5.)); %let start_dt1=%sysfunc(inputn(&stdt,mmddyy10.)); %let end_dt1=%sysfunc(inputn(&endt,mmddyy10.)); %put &d_today start_dt1 end_dt1;   %macro test; %if &start_dt1 <= &d_today <= &end_dt1 %then %do; data comp; infile "D:\Extract.txt" delimiter= '~' MISSOVER DSD lrecl=32767 firstobs=2 ; informat name $20. ; informat race $20. ; informat sex $10. ; informat age best32. ; format name $20. ; format race $20. ; format sex $10. ; format age best12. ; input name $ race $ sex $ age; run; %end; %mend test; %test;   i have been working on this code and if condition does not work as intended, i am really confused what the underlying issue, is it the date macro variables being not resolved properly or is it the open if condition.     if condition is always true even thogh date is out of range.   SYMBOLGEN: Macro variable START_DT1 resolves to 20645 SYMBOLGEN: Macro variable D_TODAY resolves to 20612 SYMBOLGEN: Macro variable END_DT1 resolves to 21375   MLOGIC(TEST): %IF condition &start_dt1 <= &d_today <= &end_dt1 is TRUE   same step when called from a data step it works fine.     ... View more

Hello Guys i was trying to add logo to an Excel report(multisheet excel file), which is generated using ODS excelsxp and  proc report. from what i read on knowledge base and other sourses. the only way we can acomplish this in SAS 9.2 is by using ODS HTML, like its mentioned in following link: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html.   Now we have upgraded our SAS to 9.4, i heard we can accomplish the same task with ODS EXCEL http://blogs.sas.com/content/sasdummy/2014/08/29/experimenting-with-ods-excel-to-create-spreadsheets-from-sas/   but i dont see any explanation of how this works in ODS EXCEL. can any one help me, understand how this is done in SAS 9.4 using ODS EXCEL.   ... View more