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!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.