topic Re: ERROR: Sort execution failure in PROC SQL in SAS Programming

ERROR: Sort execution failure in PROC SQL

josephsas — Sat, 11 Mar 2017 12:06:04 GMT

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 );

Re: ERROR: Sort execution failure in PROC SQL

Kurt_Bremser — Sat, 11 Mar 2017 12:17:01 GMT

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.

Re: ERROR: Sort execution failure in PROC SQL

josephsas — Sat, 11 Mar 2017 12:19:56 GMT

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.

Re: ERROR: Sort execution failure in PROC SQL

josephsas — Sat, 11 Mar 2017 12:22:19 GMT

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.

Re: ERROR: Sort execution failure in PROC SQL

Yavuz — Sat, 11 Mar 2017 12:24:01 GMT

I think you are working on server and maybe there is an authorization problem. Are you using sas eg ?

Re: ERROR: Sort execution failure in PROC SQL

Kurt_Bremser — Sat, 11 Mar 2017 15:13:54 GMT

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

Re: ERROR: Sort execution failure in PROC SQL

josephsas — Mon, 13 Mar 2017 04:29:19 GMT

I assign it in the libname statement

Re: ERROR: Sort execution failure in PROC SQL

Kurt_Bremser — Mon, 13 Mar 2017 07:49:24 GMT

@josephsas wrote:
I assign it in the libname statement

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