topic Re: How to Import Excel File using PROMPTS as a first step in Project in SAS Enterprise Guide

How to Import Excel File using PROMPTS as a first step in Project

VarunD — Tue, 15 May 2018 20:43:21 GMT

Hi,

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 ?

Thanks,

Varun

Re: How to Import Excel File using PROMPTS as a first step in Project

FredrikE — Wed, 16 May 2018 08:02:02 GMT

Hi!

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 🙂

//Fredrik

Re: How to Import Excel File using PROMPTS as a first step in Project

Kurt_Bremser — Wed, 16 May 2018 08:05:24 GMT

If you want to use filenames in a user selection prompt, the following needs to be done:

the location must be "visible" to the workspace server SAS process
a dataset that will contain filenames has to be registered in SAS metadata
a step before the prompt becomes active has to populate the dataset with the current filenames

Once all that is there, you can define a dynamic list prompt from the dataset.

Re: How to Import Excel File using PROMPTS as a first step in Project

VarunD — Wed, 16 May 2018 16:51:26 GMT

Thank you for your response.

Re: How to Import Excel File using PROMPTS as a first step in Project

VarunD — Wed, 16 May 2018 16:53:39 GMT

Thank you. I will try it out.