Good morning forum,
I am currently working on a set of chained stored processes (3 in total) in which the first stored process prompts the user to select a file that will be uploaded. The stored process is using HTML forms to display the page and create the buttons and browser to select a file. The form looks like this:
Once the 'Upload' button is selected, a second stored process is called and the selected file (a .xlsx file) is uploaded and proc sgplot is used to plot the data for visual representation of the uploaded file.
What I would like to happen is have 2 buttons on the second stored process.
The 'Go Back' button works fine to send the user back to the first stored process and allow for them to upload the file again. The 'Continue' button, bringing the user to the third stored process is where my problem is.
In the third stored process, I would like the same uploaded file from the second stored process to be called and used in data steps.
Right now on the third stored process, I am having some difficulties
The import code I am using is:
Does anyone have any suggestions on how to either bring them dataset from the second stored process into the third, or be able to upload the file selected in the first stored process?
Thank you.
--Chris.
Unless you establish a sessoion, data in the work library is deleted when chaining together different stored processes.
Try the technique described here and see if you are able to refernce WORK dataset after clicking continue.
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sesssamp.html
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.