I have tried what I have found on the support forums but nothing seems to work. I have tried to use the XLSX and XML extension on the ENAME portion of the code below and i cannot even open the file. Below is the only way I have managed to export and email the report and is able to open but it pops up the warning. I would like it not to have such a warning. My SAS version is : 8.2 (8.2.0.1201) (32-bit)   DATA _NULL_; ENAME_DT = PUT(DATE(),DATE9.); ENAME = STRIP(("Weekly_Report_" ||ENAME_DT||".xls")); CALL SYMPUT("ENAME", ENAME); RUN; %LET OUTPUT_PATH = /data/bi/data/inbox/; ODS LISTING CLOSE; ods tagsets.ExcelXP style=sasweb path= "&OUTPUT_PATH" file= "&ENAME" Style=Printer; ods tagsets.ExcelXP options(sheet_interval="none" sheet_name='Weekly Summary Report' AUTOFIT_HEIGHT="yes" absolute_column_width='10,20,5,5,5,5,5,5,5,5,7,7,7,7,7'); %report_page1(BO_WEEKLY_RESULTS); ods tagsets.ExcelXP options(sheet_interval="none" sheet_name='Weekly AHT Report' AUTOFIT_HEIGHT="yes" absolute_column_width='10,39,5,5,5,5,5,5,5,5,7,7,7,7,7'); %report_page2(BO_AHT_WEEK_RESULTS); ods tagsets.ExcelXP options(sheet_interval="none" sheet_name='Weekly Due Report' AUTOFIT_HEIGHT="yes" absolute_column_width='10,39,5,5,5,5,5,5,5,5,7,7,7,7,7'); %report_page3(BO_DUE_WEEK_RESULTS); ods tagsets.ExcelXP close; /*%exec(step=Output the invalid eDM file, parm=&OUTPUT_PATH./&ENAME..csv);*/ filename mymail email to=('nam@email.com') subject= "Weekly Report." attach=("&OUTPUT_PATH./&ENAME" content_type="application/xls"); data _null_; file mymail; put 'Hello:'; put ' '; put "Attached is the Weekly Report"; put ' '; put 'If you encounter any problems with the file please let me know. '; PUT ' '; PUT ' '; put 'Thank You,'; put ' '; run; ... View more

I have a data set with a Start and End Datetime. Trying a few things to compute the difference between the end and start time. But the results (below) are not getting anything back.    proc sql outobs=100; select ACTION_END_DTM, ACTION_START_DTM, ACTION_START_DTM-ACTION_START_DTM as AHT, INTCK("interval",ACTION_END_DTM , ACTION_START_DTM) as AHT from calls_closed; run;     ... View more

Hi All, I've created a report and I've exported the report. One of my fields is a grouping on the main column. Upon exporting the name of the grouped column is on the bottom. how can i adjust this so that it is centered in the box? I've tried everything Ive been able to find online. In the style section I've tried verticalalign=center and top. THe excel still has it like th eattached image on the bottom. Thanks in Advance!   style(column)=[font=(Arial, 8pt) foreground=black background=CXFFFFFF verticalalign=top VJUST=C bordertopwidth=0 borderrightwidth=0 borderleftwidth=0 bordercolor=white ];   Define CATEGORY / CENTER group order=data "CATEGORY";     ... View more

I have an excel report I built that drop the file into my ftp drive. when I open the file I get a "File Format and Extension .... don't match.." I can still bypass and open the file. Just wondering if there is a way to have the program be exported "properly" so that the error doesnt pop up.    ods tagsets.ExcelXP path= "&OUTPUT_PATH" file= 'Weekly Report.xls' Style=Printer;   I tried xlsx as the extension but it wont open the file at all. ... View more

I have a script in which I applied an Index. I noticed that in a production run while monitoring the job that when the index is applied the logs are massive   246 +proc sql; 247 +create index CUST_ID on CTC_TB(CUST_ID); INFO: Multiple concurrent threads will be used to create the index. NOTE: Simple index CUST_ID has been defined. 248 +run;   I pulled the above from the log where it cerates the index. After that, when it runs the part of the script where it utilized the index i get pages upon pages of this:   INFO: Index CUST_ID selected for WHERE clause optimization. INFO: Use of index CUST_ID for WHERE clause optimization canceled. INFO: Index CUST_ID selected for WHERE clause optimization. INFO: Use of index CUST_ID for WHERE clause optimization canceled. INFO: Index CUST_ID selected for WHERE clause optimization. The code runs and all. But I just wanted to know if this was normal or if I am applying the index inefficiently/incorrectly. TIA! ... View more