Architecting, installing and maintaining your SAS environment

SAS dataset shows as blank in one SAS/BAse library but not the other

Reply
Super Contributor
Posts: 268

SAS dataset shows as blank in one SAS/BAse library but not the other

[ Edited ]

Hi,

 I have a sas dataset that I wrote to 2 libraries MYCLIENT and WW. Both are sas native libraries. Myclient library shows the dataset as fine but WW library shows it as a blank dataset. I see column numbers but not data in it.

 

these are the errors I get while trying to register in the sas metadata library -

 

WWDATA library

NOTE: Additional host information:

X64_SRV12 WIN 6.2.9200 Server

NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: The autoexec file, E:\Programs\sas94\config\Lev1\SASApp\WorkspaceServer\autoexec.sas, was executed at server initialization.
1
2 proc metalib;
3
4 omr (libid="B500000C" repid="A5H7IVWY");
5 report(type = summary);
6 update_rule = (noadd);
7 select (A5H7IVWY.BF000BLN);
8
9 run;

ERROR: The value WoW YAG is not a valid SAS name.
NOTE: A total of 1 tables were analyzed for library "WWDATA".
NOTE: Metadata for 0 tables was updated.
NOTE: Metadata for 0 tables matched the data sources.
NOTE: 0 tables listed in the SELECT or EXCLUDE statement were not found in either the metadata or the data source.
NOTE: 1 other tables were not processed due to error or UPDATE_RULE.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The PROCEDURE METALIB printed page 1.
NOTE: PROCEDURE METALIB used (Total process time):
real time 0.05 seconds
cpu time 0.03 seconds

 

 

My library in SAS MC


NOTE: Start of registration for table MYCLIENT.WW_AFFLT_WEEKLYSUBS.
ERROR: A table of name WW_AFFLT_WEEKLYSUBS is already registered in the specified folder and cannot be added again. The table will be skipped.
NOTE: End of registration for table MYCLIENT.WW_AFFLT_WEEKLYSUBS.

 

Note 1 - So I tried to recreate the dataset using no spaces in the field names (as in WoWYAG instead of WOW YAG). So i copied the dataset from myclient to WW and I still keep getting the same error. 

Note 2 - I checked the admin privileges for my id on my lib. I have all GRANT options as checked. I checked the SAS VA admin profile for the WW library and all GRANT options as checked. 

 

 

 

Thanks,
saspert

Respected Advisor
Posts: 3,124

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

Care to share your SAS code using to "wrote to 2 libraries MYCLIENT and WW. "?

Super Contributor
Posts: 268

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

Hi Haikuo - I just updated my post with the sas metadata log from SAS MC since I usually go the SAS MC route and not the proc metalib method. I have SAS VA 7.1/Base SAS 9.4/SAS EG 7.1. 

 

Thanks,

saspert

Super Contributor
Posts: 268

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

I just changed the metadata path to this -

/User Folders/saspert/My Folder

and the dataset showed up in the myclient library in SAS MC. For some reason it would not allow me to re-register in the original folder. 

 

I guess my understanding of folder layout for normal libraries (on the server) vs metadata libraries is a bit lacking. 

Respected Advisor
Posts: 3,124

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

It seems to me you may have some issues on metadata layer.

In term of troubleshooting, I would try the following:

1. Make sure the table of interest behave the same in different base engine libraies, not meta engine. Meaning you use libname statement to define two different libraies on the fly, then check the table. I would expect there should be no problems.

2. Delete the exsiting problematic metadata libraies if you could and re-create them. After that using MC or Proc metlib to register table.

3. Contact your SAS admin.

4. Contact SAS tech support.

Super Contributor
Posts: 268

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

Thanks Haikuo. Do you know if a library (base sas engine or odbc or LASR) need to have all its datasets in the same metadata folder? because I see the LASR library with its list of datasets all across the metadata environment. But I am noticing that is not the same case for base sas engine or a database library like ODBC-to-mssqlserver or teradata.

 

Also I am noticing that unless the metadata definition is properly defined in SAS MC for the datasets, even SAS EG does not cooperate well (ie copying into another library will not work). Is that correct?  I always thought SAS EG view of libraries will by default will always work without issues regardless of the metadata definitions/folders for the datasets. 

Super User
Posts: 3,112

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

Please note that which SAS metadata folder you store your metadata-defined library in has a bearing on whether the library is listed in the server list or not for a particular user. This is the way you can give different groups of users access to different libraries.  

Trusted Advisor
Posts: 1,253

Re: SAS dataset shows as blank in one SAS/BAse library but not the other

Hi @saspert,

 

You mentioned in your comment "my understanding of folder layout for normal libraries (on the server) vs metadata libraries is a bit lacking." and I thought you may find the following post posts on metadata libraries useful:

 

Hope they help you with getting a better understanding.

 

Kind Regards,

Michelle

Ask a Question
Discussion stats
  • 7 replies
  • 474 views
  • 0 likes
  • 4 in conversation