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).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.