Hi
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
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.
How did you place the data set SASPRACTICE into the folder c:\users\desktop?
i placed the saspractice file inside the Myfolder folder
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.
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
@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.
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.
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.