Hi All, Just wondering if there is a way to supress the heading when we use a proc freq ---> The Freq Procedure. I see that even after giving a title, is there a way to remove it? Also, could we remove the datetime stamp that comes after the proc Freq procedure??                                           *** Underage supression has been applied ***            09:34 Tuesday, March 5, 2013   1                                                          The FREQ Procedure                                                      UNDR_AGE_FLAG    Frequency                                                      --------------------------                                                                  1       37274                                          *** OLD Securities supression has been applied ***         09:34 Tuesday, March 5, 2013   2                                                          The FREQ Procedure                                                      OLD_SEC_FLAG    Frequency                                                      -------------------------                                                                 1      178044 ... View more

Hi, I am trying to transfer the contents using PROC EXPORT using the below code: PROC EXPORT DATA=last OUTFILE='/home/data.xls' DBMS=XLS REPLACE; SHEET="data"; RUN; My log says the file was successfully created but when I try to open the sheet, it gives an error saying : Excel found unreadable content in 'data.xls'. Could anyone help me out here. My original goal is to transfer the contents of sas dataset to excel and then feed it as an input to pivot table on the same workbook on a different sheet. So I need to only replace the data sheet in order to have the pivot structure as it is. So only PROC EXPORT has the option to replace sheet. Any ideas on this?? ... View more