Solved: create page html for upload file from visual analytics

dipand · Posted 11-16-2021 04:11 AM

Hello to all, my client asks to create a page that can be called up from visual analytics to give the user the possibility to upload excel sheets. At the moment I have created a small job that allows you to select the file:

code:

data _null_;
file _webout;
put "<html>";
put "<body>";
put'<form method="post" enctype="multipart/form-data">';
put"<div>";
put '<label for="file">Choose file to upload</label>';
put'<input type="file" id="file" name="file" multiple>';
put"</div>";
put" <div>";
put"<button>Submit</button>";
put" </div>";
put"</form>";
put"</body>";
put "</html>";

the problem I have is that I don't know how to save the file in a path of my server to be able to process it with SAS. Can anyone give me directions?

Thanks

Stu_SAS · Posted 11-16-2021 09:37 AM

When files are uploaded to SAS through either a Viya Job or STP, they are saved to a temporary storage location. You can access it using the macro variable _WEBIN_FILEREF. Since they can upload multiple files, multiple macro variables will be available, and the number of files uploaded is stored in _WEBIN_FILE_COUNT. For example, if they are uploading two files:

_WEBIN_FILE_COUNT = 2
_WEBIN_FILEREF1   = #LN0001
_WEBIN_FILEREF2   = #LN0002

However, if _WEBIN_FILE_COUNT = 1, you will only use _WEBIN_FILEREF:

_WEBIN_FILE_COUNT = 1
_WEBIN_FILEREF    = #LN0001

If you want to only process these files, count the number of files using _WEBIN_FILE_COUNT, then run your import code just like any other SAS code:

/* Test values */
%let _WEBIN_FILE_COUNT = 1;
%let _WEBIN_FILEREF    = a;
%let _WEBIN_FILEREF1   = b;
%let _WEBIN_FILEREF2   = c;

/* copy:   Optional. if YES, copies the file to "outdir" 
   outdir: Location to copy the uploaded file permanently 
*/
%macro read_uploaded_files(copy=NO, outdir=/directory/here);
    %local i n;
    %let outdir = %superq(outdir);
    %let copy   = %upcase(&copy);

    %put Total files: &_WEBIN_FILE_COUNT;

    /* Read in all the uploaded files and output sequentially to datasets 
       named excelout1, excelout2, etc.
    */
    %do i = 1 %to &_WEBIN_FILE_COUNT;

        /* Add a suffix if more than one file was uploaded */
        %if(&_WEBIN_FILE_COUNT > 1) %then %let n = &i;

        %put Importing fileref %nrbquote(&)_WEBIN_FILEREF&n.: &&_WEBIN_FILEREF&n.;

        /* Read the file in to SAS. Comment out for testing. */
        proc import 
            file = &&_WEBIN_FILEREF&n.
            out  = excelout&i.
            dbms = xlsx
            replace;
        run;
    
        /* Copy the file somewhere to the server permanently */
        %if(&copy. = YES) %then %do;
            filename outfile "&outdir./&&_WEBIN_FILENAME&n";
            %let rc = %sysfunc(fcopy(&&_WEBIN_FILEREF&n., outfile) );
        %end;

    %end;
%mend;
%read_uploaded_files;

Follow me on LinkedIn for SAS tips with #SASTipTuesday
Check out my GitHub for SAS tips and tricks
Read my blog for cool SAS and open source data science projects

View solution in original post

Stu_SAS · Posted 11-16-2021 09:37 AM

When files are uploaded to SAS through either a Viya Job or STP, they are saved to a temporary storage location. You can access it using the macro variable _WEBIN_FILEREF. Since they can upload multiple files, multiple macro variables will be available, and the number of files uploaded is stored in _WEBIN_FILE_COUNT. For example, if they are uploading two files:

_WEBIN_FILE_COUNT = 2
_WEBIN_FILEREF1   = #LN0001
_WEBIN_FILEREF2   = #LN0002

However, if _WEBIN_FILE_COUNT = 1, you will only use _WEBIN_FILEREF:

_WEBIN_FILE_COUNT = 1
_WEBIN_FILEREF    = #LN0001

If you want to only process these files, count the number of files using _WEBIN_FILE_COUNT, then run your import code just like any other SAS code:

/* Test values */
%let _WEBIN_FILE_COUNT = 1;
%let _WEBIN_FILEREF    = a;
%let _WEBIN_FILEREF1   = b;
%let _WEBIN_FILEREF2   = c;

/* copy:   Optional. if YES, copies the file to "outdir" 
   outdir: Location to copy the uploaded file permanently 
*/
%macro read_uploaded_files(copy=NO, outdir=/directory/here);
    %local i n;
    %let outdir = %superq(outdir);
    %let copy   = %upcase(&copy);

    %put Total files: &_WEBIN_FILE_COUNT;

    /* Read in all the uploaded files and output sequentially to datasets 
       named excelout1, excelout2, etc.
    */
    %do i = 1 %to &_WEBIN_FILE_COUNT;

        /* Add a suffix if more than one file was uploaded */
        %if(&_WEBIN_FILE_COUNT > 1) %then %let n = &i;

        %put Importing fileref %nrbquote(&)_WEBIN_FILEREF&n.: &&_WEBIN_FILEREF&n.;

        /* Read the file in to SAS. Comment out for testing. */
        proc import 
            file = &&_WEBIN_FILEREF&n.
            out  = excelout&i.
            dbms = xlsx
            replace;
        run;
    
        /* Copy the file somewhere to the server permanently */
        %if(&copy. = YES) %then %do;
            filename outfile "&outdir./&&_WEBIN_FILENAME&n";
            %let rc = %sysfunc(fcopy(&&_WEBIN_FILEREF&n., outfile) );
        %end;

    %end;
%mend;
%read_uploaded_files;

Follow me on LinkedIn for SAS tips with #SASTipTuesday
Check out my GitHub for SAS tips and tricks
Read my blog for cool SAS and open source data science projects

create page html for upload file from visual analytics

Re: create page html for upload file from visual analytics

Re: create page html for upload file from visual analytics

Registration is open