DATA Step, Macro, Functions and more

SASUSER.SASMBC

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

SASUSER.SASMBC

I am getting an warning saying variable xxx not found in SASUSER.SASMBC

I don't create any such library.

Can anybody suggest what it is


Accepted Solutions
Solution
‎11-27-2017 09:13 PM
Contributor
Posts: 38

Re: SASUSER.SASMBC

[ Edited ]

Thank you all for your time, interest and help.

My findings are as follows.

There was a batch job which gave this error. The job runs in a shared production environment. 

(The job ran earlier and continues to ran thereafter without any error)
After making due diligence and finding that this is created automatically and appeared to be empty.

This had three columns

Variable.type,length

Attribut, char,8

Value,Char,200

Varname,Char,8

I re-ran the job and it ran successfully.
As multiple jobs are running on the server, my presumption is that multiple batch jobs must be trying  to access the same data set (sashelp.sasmbc) , hence the error.

My issue stands resolved.

What remains, however, is a curiosity to know the purpose and the logic behind sashelp.sasmbc.

Was hopeful that learned SAS experts would shed some light on this.

 

 

View solution in original post


All Replies
Super User
Posts: 3,769

Re: SASUSER.SASMBC

Posted in reply to thesasuser

Please post the log containing the code step and the warning.

Super User
Posts: 22,857

Re: SASUSER.SASMBC

Posted in reply to thesasuser

The SASUSER library is created by default automatically. 

Solution
‎11-27-2017 09:13 PM
Contributor
Posts: 38

Re: SASUSER.SASMBC

[ Edited ]

Thank you all for your time, interest and help.

My findings are as follows.

There was a batch job which gave this error. The job runs in a shared production environment. 

(The job ran earlier and continues to ran thereafter without any error)
After making due diligence and finding that this is created automatically and appeared to be empty.

This had three columns

Variable.type,length

Attribut, char,8

Value,Char,200

Varname,Char,8

I re-ran the job and it ran successfully.
As multiple jobs are running on the server, my presumption is that multiple batch jobs must be trying  to access the same data set (sashelp.sasmbc) , hence the error.

My issue stands resolved.

What remains, however, is a curiosity to know the purpose and the logic behind sashelp.sasmbc.

Was hopeful that learned SAS experts would shed some light on this.

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 129 views
  • 0 likes
  • 3 in conversation