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.