ERROR: Sort execution failure in PROC SQL

[josephsas]

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

[Kurt_Bremser]

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.

---

[josephsas]

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.

[josephsas]

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.

[Kurt_Bremser]

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

[josephsas]

I assign it in the libname statement

[Kurt_Bremser]

---

@josephsas wrote:
I assign it in the libname statement

---

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

[Yavuz]

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