Hello everyone,   Again i am hit with one strange error.   I am creating a report using sas stored procedure to get the ouput in excel spreadsheet from running this stored procedure from web application. while i have used same code which i have used in previous reports and those are giving result absolutely fine.   I am using below code:   data _null_;  rc = stpsrv_header('Content-disposition','attachment; filename=test.xls');  rc = stpsrv_header('Content-disposition',"inline");  run;   OPTIONS NOBYLINE MISSING=' '; /*ods tagsets.ExcelXP options(*/ %let _ODSDEST=TAGSETS.EXCELXP options( EMBED_TITLES_ONCE = 'YES' EMBEDDED_TITLES='YES' /*EMBEDDED_FOOTNOTES='YES' */   sheet_name='Current Data' /*autofilter='ALL' */ /*frozen_headers='3' */ /*frozen_rowheaders='NO' */   ABSOLUTE_COLUMN_WIDTH='13,10,11,12,10,12,12,12,12,12,11,11,11,16,16,16,10,10,10,10,10,10,10'   /*ZOOM='80' */ /*WRAPTEXT='YES' */ BLACKANDWHITE='YES' ); %let _ODSSTYLE=seaside;   Then MACRO Code to run report.   I am getting below error rather than getting output in excel file.   <?xml version="1.0" encoding="utf-8" ?>   <?mso-application progid="Excel.Sheet"?> - <!-- Generated by the SAS Excelxp Tagset .v1.131, 04/23/2015   --> - <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> - <DocumentProperties xmlns="urn:schemas-microsoft-com:office">   <Author>sassrv</Author>   <LastAuthor>sassrv</LastAuthor>   <Created>2017-09-28T08:16:45</Created>   <LastSaved>2017-09-28T08:16:45</LastSaved>   <Company>SAS Institute Inc. http://www.sas.com</Company>   <Version>9.04.01M4P11092016</Version>   </DocumentProperties> - <Styles> - <Style ss:ID="_body">       Can anyone suggest what should i do to get rid of this and get output in excel spreadsheet.   Thanks in advance !! ... View more

Hi everyone,   I am seeking help regarding the code which can transfer server file to livelink. Or i am also thinking about getting the data into sas environment by reading server file and then upload/save that data file to livelink.   i dont know what should be method/approach to save data file to livelink.   Can anyone give suggession or have done any similar task ?   Thanks for support. Vinod ... View more

Hello SAS Experts, Could any of you please help me out with this issue I'm facing? 1. I have a SAS stored process created and linked to web portal. 2. The SAS Stored process is required to generate an Excel file as output comtaining the needed data. 3. In order to get the desired out , I have to pre process the data with many conditions. Everything is correct whenever I have data in database and giving correct result in Excel. But the problem comes whenever user gives incorrect input , I have coded it as it will give output in Excel as one record saying " no data available for this input number". In all other report my logic is throwing this 1 record output in Excel, but in only in 1 report it's not giving desired output like other report. In my observation, in other report , I just fetch the data using proc SQL and check the record count and if obs=0 then I place a proc report to put 1 record. But in this report as I have to pre process the data , so many datasets get created . And if record does not exist then error found in log , which is I think causing issue . ... View more

Hi,   I have made sas stored procedure and then transfered output to excel. But in excel preceding zero's are missing.   e.g.   value in sas                 value in excel            005407                         5407            001                               1   i have tried following code.   DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: @'} FORMAT= $CHAR4.;   DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: text'} FORMAT= $CHAR4.;   DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: $'} FORMAT= $CHAR4.;   I am getting error.   Can anyone please help.   Thanks in advance   ... View more

Hi,   I'm developing sas stored procedures to get attached in web portal to display data automatically in Excel. But i am getting error while running this code. Can anyone help me with the code which i can include in my stored procedure to get output automatically in excel ?   Thanks, Good luck to me 🙂 ... View more

Suppose i have call details data in PDF , how can i read it through SAS EG to analyse it further? Any suggession on this ? I am using SAS EG 5.1 version. Thanks in Advance ... View more