topic Re: Trouble Seeing my Data Source in Enterprise Miner in SAS Software for Learning Community

Trouble Seeing my Data Source in Enterprise Miner

SShubert — Tue, 22 Nov 2022 16:53:42 GMT

Hello Community,

I am having major trouble with my assignment. I have an excel data set that I've loaded into SAS studio. It did not show any errors. I tried to bring it into Enterprise Miner and the library was created but I couldn't see my data source. I cannot see what I'm doing wrong from SAS studio all the way to bringing the data source in. Missing Data SetSays path is not vaild after trying to modify the dataNo errors in SAS Studio

Re: Trouble Seeing my Data Source in Enterprise Miner

tom_grant — Tue, 22 Nov 2022 17:40:05 GMT

A few suggestions:
1. In SAS Studio, rename the folders without spaces (you can use underscores) - not sure if this will help.
2. Once you see the SAS dataset (.sas7bdat file) in the folder in SAS Studio, right-click on the folder & select properties. Copy the path, & then in Enterprise Miner paste the path in the Library Wizard when creating the Library. (It looks like your second-shot is using the path c:\... which is not correct).
3. From the log in 3rd screen-shot, it looks like you are creating a SAS dataset called Import in the Work library - In the Import Wizard (SAS Studio) - make sure you change the Library (& dataset name) to a library associated with those folders. You can right-click on the folder & select Create->Library if you do not have one associated with the folder already.
Hope that helps.

Re: Trouble Seeing my Data Source in Enterprise Miner

SShubert — Tue, 22 Nov 2022 17:59:42 GMT

Hi Tom,

I erased my excel file and brought it back in as DatServ file name. I ran the code and no errors. I can't get it into a .sas7bat file now. Also I wanted to move it into Libraries so I can get it from there but also unsure of how to get it there.

Re: Trouble Seeing my Data Source in Enterprise Miner

SShubert — Tue, 22 Nov 2022 18:01:36 GMT

Re: Trouble Seeing my Data Source in Enterprise Miner

tom_grant — Tue, 22 Nov 2022 18:12:50 GMT

So SAS successfully created the dataset from Excel file but it is saved in the Work Library & the dataset is called Import - if you scroll down a bit in the top section of the screen - you will see where you can change the library & dataset name.

Re: Trouble Seeing my Data Source in Enterprise Miner

tom_grant — Tue, 22 Nov 2022 18:15:03 GMT

Re: Trouble Seeing my Data Source in Enterprise Miner

SShubert — Tue, 22 Nov 2022 18:24:40 GMT

Hi Tom,

I did that a little while ago after stumbling upon it. Now I was succesful in loading the data into a library but now It won't let me pull the data source into my project. What do I need to clean up in my excel file?

Re: Trouble Seeing my Data Source in Enterprise Miner

tom_grant — Tue, 22 Nov 2022 18:42:05 GMT

In SAS Studio go the the More Applications Options button:

Then select preferences.

In the tables properties, set the SAS variable name policy to V7 & member name policy to Compatible

Make sure you scroll down & select SAVE

You'll have to re-import your excel file. This should fix the variable names so that they follow naming standards.

Re: Trouble Seeing my Data Source in Enterprise Miner

tom_grant — Wed, 23 Nov 2022 12:47:23 GMT

Let me know if this fixed the problem.