Desktop productivity for business analysts and programmers

Interact with Data After Using Import Wizard

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Interact with Data After Using Import Wizard

Hi all,

 

I'm new to SAS and using Enterprise Guide on a Windows VM has posed some difficulty in working with data stored locally. I use the Import Wizard to open local files and assign it to a library I've created in the Management Console. After I do that, how do I save the data? I see a table is created in the library, does that mean it is "saved"? From there, how do I start a new program to work with the data? Going to File>New>Program doesn't connect them in the Process Flow and adding a Libname doesn't work either. 

 

I'm sorry if this sounds all over the place. I'm so new I don't really know how to describe what I'm trying to do other than, once I use the Import Wizard in SAS EG and it opens, how can I start a new program to do basic stuff like rename columns?

 

Any help is greatly appreciated. Thanks.


Accepted Solutions
Solution
Wednesday
Occasional Contributor
Posts: 6

Re: Interact with Data After Using Import Wizard

Posted in reply to JenniferLB08

Once you go through the import wizard, you are basically creating a SAS dataset saved in your library, either a permanent library, or work library. So, yet, it should be saved at that point. You can run any sort of task, like query builder. It will ask for your SAS dataset as the input and you would just navigate to that library and SAS dataset from your server tree. Or, from the process flow, you can right click on the output dataset from your import and it will give options on what you can do with it.

 

You can add new programs that references that dataset, but you won't see the line to connect the steps import step to that program. But you can manually add it. This is also helpful to control the order your programs run in (also check out ordered lists for that).

 

 

View solution in original post


All Replies
Solution
Wednesday
Occasional Contributor
Posts: 6

Re: Interact with Data After Using Import Wizard

Posted in reply to JenniferLB08

Once you go through the import wizard, you are basically creating a SAS dataset saved in your library, either a permanent library, or work library. So, yet, it should be saved at that point. You can run any sort of task, like query builder. It will ask for your SAS dataset as the input and you would just navigate to that library and SAS dataset from your server tree. Or, from the process flow, you can right click on the output dataset from your import and it will give options on what you can do with it.

 

You can add new programs that references that dataset, but you won't see the line to connect the steps import step to that program. But you can manually add it. This is also helpful to control the order your programs run in (also check out ordered lists for that).

 

 

Occasional Contributor
Posts: 6

Re: Interact with Data After Using Import Wizard

Posted in reply to bobpep212

Thanks for the explanation of the Import Wizard--that helps. I also did see how to connect a new program to the file that was opened from the Wizard but when I run the program I get an error that says 'File Work.MyData.Data does not exist'. This seems weird because I didn't save the data to the Work folder when I used the Wizard. Is there an additional step I should be doing?

Occasional Contributor
Posts: 6

Re: Interact with Data After Using Import Wizard

Posted in reply to JenniferLB08

What is the name of the libref of where you did store the dataset? If you aren't sure, I would use the server list, navigate to local ->Libraries and then look for the folder where you did store your SAS dataset. Then, edit your program and replace WORK.MyData with <libref>.MyData, where <libref> is the library where the dataset is stored.

 

Super User
Posts: 23,224

Re: Interact with Data After Using Import Wizard

[ Edited ]
Posted in reply to JenniferLB08

There's a SAS EG tutorial available built in. Spending an hour or so going through it would probably help you answer all these questions.

 

https://support.sas.com/documentation/onlinedoc/guide/tut71/en/menu.htm

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 114 views
  • 0 likes
  • 3 in conversation