Help using Base SAS procedures

Error reading dataset using Enterprise guide 4

Reply
N/A
Posts: 0

Error reading dataset using Enterprise guide 4

Hi,

I have created a dataset in SAS DI 3.4 Then I go to Enterprise Guide 4 to open and view the data but I can't due to this error.

[Error] Not authorized in the SAS metadata Repository to read data in table/view XXX.XXX.DATA

How to solve this error?

Thanks

Yours Sincerely,
helphelp
Super User
Posts: 5,256

Re: Error reading dataset using Enterprise guide 4

A few assumptions:
-You are using the same userid/account in both cases.
-You have no pre-assigned libraries.
If this is the case, EG will assign metadata libname when you try to access data.
In DI Studio by contrast, the generated SAS code will contain old school libnames, which does not take metadata authorization into account, just OS privileges.
Talk to the person responsible for administrating your SAS configuration/security/environment, or look for yourself in SMC to find out how to set appropriate authorizations.

/Linus
Data never sleeps
N/A
Posts: 0

Re: Error reading dataset using Enterprise guide 4

Hi Linus,

You mean if I am using the same userid/account in both cases, i will have the error? What do u mean by that?

Yours Sincerely,
helphelp
Super Contributor
Posts: 318

Re: Error reading dataset using Enterprise guide 4

Hi HelpHelp,

Log in to your SMC and kindly check the library where the dataset is located.

It should have both read metadata and read allowed i think.

Regards,
Milton
Super User
Posts: 5,256

Re: Error reading dataset using Enterprise guide 4

What I meant was that if you were using different userids there is also a possibility that these accounts has different rights in metadata/OS level.
/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 207 views
  • 0 likes
  • 3 in conversation