Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 13

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

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

 

Super Contributor
Posts: 344

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

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 Smiley Happy

 

//Fredrik

Occasional Contributor
Posts: 13

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

Thank you for your response.
Super User
Posts: 9,611

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

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.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 13

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

Posted in reply to KurtBremser
Thank you. I will try it out.
Ask a Question
Discussion stats
  • 4 replies
  • 109 views
  • 0 likes
  • 3 in conversation