topic Re: sas studio not reading file in desktop in SAS Enterprise Guide

sas studio not reading file in desktop

ajith — Fri, 30 Dec 2016 17:04:07 GMT

I am trying to read a file stored in my desktop.

i created the libname zo 'c:\users\desktop';

proc print data=zo.saspractice;

run;

the system says library zo.saspractice does not exist

Re: sas studio not reading file in desktop

ballardw — Fri, 30 Dec 2016 17:13:28 GMT

How did you place the data set SASPRACTICE into the folder c:\users\desktop?

Re: sas studio not reading file in desktop

Reeza — Fri, 30 Dec 2016 17:49:52 GMT

If your using SAS UE make sure to place the file in the myfolders folder you created during set up.

Then refer to it using the Unix notation.

/folded/myfolders/file_name.csv

If you continue to get errors please post the code and log.

Re: sas studio not reading file in desktop

ajith — Fri, 30 Dec 2016 19:10:31 GMT

Hi Reeza

it still doesnt work.. i changed the file format to csv from the xlsx originally.

also, i put the name of the file at the end of the path...still the error message says error: file FOL.PR.data does not exist

thanks

Re: sas studio not reading file in desktop

ajith — Fri, 30 Dec 2016 19:12:20 GMT

i placed the saspractice file inside the Myfolder folder

Re: sas studio not reading file in desktop

Reeza — Fri, 30 Dec 2016 19:31:50 GMT

@ajith wrote:

Hi Reeza

it still doesnt work.. i changed the file format to csv from the xlsx originally.

also, i put the name of the file at the end of the path...still the error message says error: file FOL.PR.data does not exist

thanks

ap

If you continue to get errors post the code and log.

Re: sas studio not reading file in desktop

ballardw — Fri, 30 Dec 2016 20:27:50 GMT

Most SAS procedures use files in proprietary SAS file formats. If you data is in a text, csv, xls, xlsx or other file format then the data has to be imported into SAS so the values are in the right file format. Until you have done that using either a wizard, task or code written to read the data there is not a SAS formatted data set and so the "the data set does not exist".

The name SASPRACTICE makes me think you have been given some training materials. You may need to read the introduction or instructions on how to import the files so that they are available for use in SAS.

Re: sas studio not reading file in desktop

ajith — Fri, 30 Dec 2016 21:30:02 GMT

agree. this is the problem. i stored it as an xlsx and csv file. i will change it to a sas data set. hopefully that will solve the problem

Re: sas studio not reading file in desktop

ballardw — Fri, 30 Dec 2016 22:00:42 GMT

Do you do a file save as or just change the extension? If that is what you did then change the extension back to sas7bdat.

If it is a program file then there's likely more work to go