06-29-2015 11:27 AM
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?
09-23-2016 10:16 PM
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.