Hello, I want to supply a excel output for users to download. What I do now in my sas program is using sas to create csv file, then call a perl script to convert this csv file to binary excel file, finally using a data step to read the excel file generated by perl and output to the fileref _webout as follows. It works fine.
file _webout recfm=n;
infile "tmp.xls" recfm=n;
input byte $char1. @@;
put byte $char1. @@;
I want to if there are some methods to stream the perl output directly to _webout fileref? I tried let my perl script output to standard output, then using filename to pipe the output to sas as input as follows.
Sorry for repost. when I post the broswer gives a error and let me back to edit again. so I back an post again.
Admin may please help to delete the duplicated posts. Thanks.
Message was edited by: cxterm
Context is everything. I'm not sure how you're using a Perl script....whether you're really talking about stored processes or??? SAS/IntrNet?? SAS Integration Technologies???
First of all, if you are running on the BI platform, I'm not sure I understand why you're making a CSV file, then creating an Excel file from the CSV file??? If you were using the Platform, your task or results or data set could come directly to Excel via the SAS Add-In to Microsoft Office.
Since I see a call to APPSRV_HEADER, I suspect you're using SAS/IntrNet and a PERL script in your HTML/web front end????