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 );
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.
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.
Is dwpl pre-assigned by metadata or do you assign it by a libname statement?
@josephsas wrote:
I assign it in the libname statement
Then please post the log of the libname statement (inlcuding the statement itself).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.