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 Set
Says path is not vaild after trying to modify the data
No errors in SAS Studio
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.
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?
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Select SAS Training centers are offering in-person courses. View upcoming courses for: