DATA Step, Macro, Functions and more

ERROR: Sort execution failure in PROC SQL

Reply
New Contributor
Posts: 4

ERROR: Sort execution failure in PROC SQL

Hi

 

I am getting this error when runining the below code 

 

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26


27 proc sql outobs=10;
28 (
29 select * from nz_creditdw_pl.bo_master_test
ERROR: Librefs are restricted to eight characters. nz_creditdw_pl has been truncated.
30 );

Super User
Posts: 7,766

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to josephsas

It's all there: you used an invalid name for the library. Library references can have at most eight characters. Fix that, and then check for the error in the subject.


josephsas wrote:

ERROR: Librefs are restricted to eight characters. nz_creditdw_pl has been truncated.


 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to KurtBremser

Hi 

 

Thanks for replying i am new on sas been using sql. I changed that and put this but still getting some error. Can you please assist

 

27 proc sql;
28
29 create table dwpl.Acc_num
30 as
31 select * from datamart.ac_num
32
33 quit;
ERROR: You cannot create or delete datasets, views or indexes in this mode. Try the option METAOUT=DATA. Use Proc Metalib to create
metadata for datasets.

New Contributor
Posts: 4

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to KurtBremser
Hi



I have changed the code please see below now I am getting a different error. I am sorry I am very much new on sas


27 proc sql;
28
29 create table dwpl.Acc_num
30 as
31 select * from datamart.ac_num
32
33 quit;
ERROR: You cannot create or delete datasets, views or indexes in this mode. Try the option METAOUT=DATA. Use Proc Metalib to create

metadata for datasets.


Super User
Posts: 7,766

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to josephsas

Is dwpl pre-assigned by metadata or do you assign it by a libname statement?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to KurtBremser
I assign it in the libname statement


Super User
Posts: 7,766

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to josephsas

josephsas wrote:
I assign it in the libname statement



Then please post the log of the libname statement (inlcuding the statement itself).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 54

Re: ERROR: Sort execution failure in PROC SQL

Posted in reply to josephsas
I think you are working on server and maybe there is an authorization problem. Are you using sas eg ?
Ask a Question
Discussion stats
  • 7 replies
  • 1001 views
  • 0 likes
  • 3 in conversation