BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MohabAli
Fluorite | Level 6

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 

1 ACCEPTED SOLUTION

Accepted Solutions
MohabAli
Fluorite | Level 6
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!

View solution in original post

4 REPLIES 4
ballardw
Super User

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?

MohabAli
Fluorite | Level 6
 
 
 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

ballardw
Super User

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.

MohabAli
Fluorite | Level 6
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!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

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.

Discussion stats
  • 4 replies
  • 688 views
  • 0 likes
  • 2 in conversation