Hello,
I ma having issues with lesson 3: exploring and validating data. When it try to do PG1.STORM_SUMMARY.DATA, Iget back back an error message on the log stating that PG1.STORM_SUMMARY does not exist. I did the required step on lesson 2 to create the libname.sas. I am using SAS studio. for the same exact reason I restarted the whole SAS practice files installation and still I am facing the same issue.
Please advice and thank you!
Mohab
NOTE: Libref= WORK Scope= IOM ROOT COMP ENV Engine= V9 Access= TEMP Physical Name= C:\Users\AliMohab\AppData\Local\Temp\SAS Temporary Files\_TD10544_LPSY348_\Prc2 Filename= C:\Users\AliMohab\AppData\Local\Temp\SAS Temporary Files\_TD10544_LPSY348_\Prc2 Owner Name= BUILTIN\Administrators File Size= 8KB File Size (bytes)= 8192 NOTE: Libref= WEBWORK Scope= IOM ROOT COMP ENV Engine= V9 Physical Name= C:\Users\AliMohab\AppData\Roaming\SAS\SASStudio\webwork\RS2101 Filename= C:\Users\AliMohab\AppData\Roaming\SAS\SASStudio\webwork\RS2101 Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 NOTE: Libref= SASHELP Scope= Kernel Levels= 20 -Level 1- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Filename= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 2- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Owner Name= BUILTIN\Administrators File Size= 96KB File Size (bytes)= 98304 -Level 3- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 4- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\access\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\access\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 5- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\af\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\af\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 6- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\assist\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\assist\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 7- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cas\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cas\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 8- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 9- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 10- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\eis\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\eis\sashelp Owner Name= BUILTIN\Administrators File Size= 12KB File Size (bytes)= 12288 -Level 11- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Owner Name= BUILTIN\Administrators File Size= 12KB File Size (bytes)= 12288 -Level 12- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\gis\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\gis\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 13- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Owner Name= BUILTIN\Administrators File Size= 8KB File Size (bytes)= 8192 -Level 14- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 15- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 16- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mlearning\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\mlearning\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 17- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 18- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\qc\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\qc\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 19- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 20- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 NOTE: Libref= MAPS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps Owner Name= BUILTIN\Administrators File Size= 128KB File Size (bytes)= 131072 NOTE: Libref= MAPSSAS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps Owner Name= BUILTIN\Administrators File Size= 128KB File Size (bytes)= 131072 NOTE: Libref= MAPSGFK Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Filename= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Owner Name= BUILTIN\Administrators File Size= 160KB File Size (bytes)= 163840 NOTE: Libref= SASUSER Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Users\AliMohab\Documents\My SAS Files\9.4 Filename= C:\Users\AliMohab\Documents\My SAS Files\9.4 Owner Name= UAMS\AliMohab File Size= 4KB File Size (bytes)= 4096 74 75 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89
Thank you for that, I ran the code you provided me and you are right PG1 library does not exist. So instead I ran the the storm summary file through file location as you mentioned and not following the steps of lesson 3 and the file was executed successfully. If it doesn't bother you, how can I assign this file to a library that I would create under name PG1. Thanks again!
Any question about an error should show, from the log the code and all the messages related to that code. Copy the text from the log and on the forum open a text box using the </> icon above the message window, then paste the text.
Did you rerun the LIbname for that library in the current session?
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc print data=pg1.storm_summary (obs=10) ; ERROR: File PG1.STORM_SUMMARY.DATA does not exist. 74 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 75 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89
I am not fully getting what is returning libname, If you mean that I created libname.sas in a previous step then yes I did that several times as an attmept to troubleshoot @ballardw thank you for your response
In your code Pg1.Storm_summary the part, Pg1 is the name of a library which is a storage location. If the current session does not have the library Pg1 assigned then the program cannot find the data set Storm_summary.
Please run this code:
libname _all_ list;
You LOG will show all of the libraries currently assigned in the active session and the physical path each one uses.
If you do not see an entry for PG1 then the library is not assigned.
If you do see PG1 then that means the data set named Storm_summary is not in the that library and you need to find out where you put it.
The most common causes of the error message you are getting are :
1) the library is not assigned
2) the spelling of the library is incorrect
3) the spelling of the data set name is incorrect
4) the data set is not in the library at all.
If you used the data set in a previous session that mean almost certainly you executed, or the SAS supplied training set up code, executed a statement like:
Libname Pg1 "<some file path goes here>";
I don't know where you might have set up anything so can't guess what your file path should be. It would look something like
Libname Pg1 "C:\foldername\otherfoldername";
or similar depending on your operating system.
NOTE: Libref= WORK Scope= IOM ROOT COMP ENV Engine= V9 Access= TEMP Physical Name= C:\Users\AliMohab\AppData\Local\Temp\SAS Temporary Files\_TD10544_LPSY348_\Prc2 Filename= C:\Users\AliMohab\AppData\Local\Temp\SAS Temporary Files\_TD10544_LPSY348_\Prc2 Owner Name= BUILTIN\Administrators File Size= 8KB File Size (bytes)= 8192 NOTE: Libref= WEBWORK Scope= IOM ROOT COMP ENV Engine= V9 Physical Name= C:\Users\AliMohab\AppData\Roaming\SAS\SASStudio\webwork\RS2101 Filename= C:\Users\AliMohab\AppData\Roaming\SAS\SASStudio\webwork\RS2101 Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 NOTE: Libref= SASHELP Scope= Kernel Levels= 20 -Level 1- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Filename= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 2- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Owner Name= BUILTIN\Administrators File Size= 96KB File Size (bytes)= 98304 -Level 3- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 4- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\access\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\access\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 5- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\af\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\af\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 6- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\assist\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\assist\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 7- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cas\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cas\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 8- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 9- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 10- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\eis\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\eis\sashelp Owner Name= BUILTIN\Administrators File Size= 12KB File Size (bytes)= 12288 -Level 11- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Owner Name= BUILTIN\Administrators File Size= 12KB File Size (bytes)= 12288 -Level 12- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\gis\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\gis\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 13- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Owner Name= BUILTIN\Administrators File Size= 8KB File Size (bytes)= 8192 -Level 14- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 15- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 16- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mlearning\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\mlearning\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 17- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 -Level 18- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\qc\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\qc\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 19- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp Owner Name= BUILTIN\Administrators File Size= 0KB File Size (bytes)= 0 -Level 20- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Owner Name= BUILTIN\Administrators File Size= 4KB File Size (bytes)= 4096 NOTE: Libref= MAPS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps Owner Name= BUILTIN\Administrators File Size= 128KB File Size (bytes)= 131072 NOTE: Libref= MAPSSAS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps Owner Name= BUILTIN\Administrators File Size= 128KB File Size (bytes)= 131072 NOTE: Libref= MAPSGFK Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Filename= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Owner Name= BUILTIN\Administrators File Size= 160KB File Size (bytes)= 163840 NOTE: Libref= SASUSER Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Users\AliMohab\Documents\My SAS Files\9.4 Filename= C:\Users\AliMohab\Documents\My SAS Files\9.4 Owner Name= UAMS\AliMohab File Size= 4KB File Size (bytes)= 4096 74 75 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89
Thank you for that, I ran the code you provided me and you are right PG1 library does not exist. So instead I ran the the storm summary file through file location as you mentioned and not following the steps of lesson 3 and the file was executed successfully. If it doesn't bother you, how can I assign this file to a library that I would create under name PG1. Thanks again!
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 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.