Dear All, I was trying to create a stored process which would upload a csv file from the users computer and create a sas DATAset. The code i am trying was put together using references given below Upload Files in stp Dynamic Parameters for Stored Process The below code would first execute a stored process which would webout an html custom input form where the user can browse to the location where his csv file is present. On clicking the OK button on the Html the same stored process is executed again but with the parameters that the html sends to the STP which would import the data from the CSV and print the first 10 rows. On executing the STP the HTML form does get generated correctly but the import doesnot happen. In the refrence notes it was mentioned that the STP would generate the _webin_ macro variables. But when i execute this code no values get generated for the &_WEBIN_FILEREF. And the import code throws the following error ERROR: Unable to import, please specify a DATAFILE. Is there something wrong in what i am trying to achieve here. Please do guide. %macro main; %global reqtype; %macro first_request; data _null_; file _webout; PUT '<form action=http://myserver:8080/SASStoredProcess/do method="post" enctype="multipart /form-data">'; PUT '<input type="hidden" name="_PROGRAM" value="/PATH/STP_NAME">'; PUT '<input type="hidden" name=reqtype value="report">'; PUT '<table border="0" cellpadding="5">'; PUT '<tr>'; PUT '<th>Choose a file to upload:</th>'; PUT '<td><input type="file" name="myfile"></td>'; PUT '</tr>'; PUT '<tr>'; PUT '<td colspan="2" align="center"><input type="submit" value="OK"></td>'; PUT '</tr>'; PUT '</table>'; PUT '</form>'; RUN; %mend first_request; %macro report; %let CSVFILE=%sysfunc(pathname(&_WEBIN_FILEREF)); proc import datafile="&CSVFILE" out=work.mydata dbms=csv replace; getnames=yes; run; %stpbegin; title 'First 10 records of CSV file after importing to a SAS table.'; proc print data=work.mydata(obs=10); run; quit; %stpend; %mend report; %if "&reqtype" = "report" %then %do; %report; %end; %else %do; %first_request; %end; %mend main; %main;
... View more