05-15-2018 04:43 PM
I want to be able to import an Excel File where in users are PROMPTED to choose the file from network/local machine. Is there a way to do it in SAS Enterprise Guide ?
05-16-2018 04:02 AM
You can do it by creating a file prompt and then a user written importer that uses the prompt value to select the file.
I don't think you can do it by just using standard transformations...
To make it easier you can import one file and then copy the code to your user written
05-16-2018 04:05 AM
If you want to use filenames in a user selection prompt, the following needs to be done:
Once all that is there, you can define a dynamic list prompt from the dataset.