BookmarkSubscribeRSS Feed
syam_india_kochi
Calcite | Level 5
Dear All,

I was using a code to extract data through odbc connection, I used to get the data as intended but this time when I ran, I didnt select the full code, I missed to select the "proc" statement from my code. I got an error message and I ran the code with full selection as usual but, the SAS thrown an error message as shown below.


Please explain what is this error and the upseting fact is that once you get this message you cant run any other part of your stream without disconnecting from work.

The error is repeating in all further runs...

Are there any options to reset these errors and start working in the work without disconnecting..?

Pls help...



NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between
a quoted string and the succeeding identifier is recommended.
12
13 %gaccessible;
14 proc sql;
15 connect to odbc(datasrc=dwh_sybaseiq user="Syams" password="syams@123");
____________
49

16 execute(select
17 cust_id,
18 currency_code,
19 SOURCE_ACCOUNT_NBR,
20 CUST_STAT_CODE,
21 CUST_CONST,
22 NRI_FLG,
23 GL_SUB_HEAD_CODE,
24 Account_Summary_Date
WARNING: The quoted string currently being processed has become more than 262 characters long. You may have unbalanced quotation
2 The SAS System 14:40 Tuesday, November 30, 2010

marks.
25 into #base1
26 from
27 EDW.T03055_LIABILITY_SNAPSHOT
28 where CUST_STAT_CODE IN ('HNIPB', 'HNIPS', 'HNIPT')
29 AND Account_Summary_Date = '2010-10-31'
30 )by odbc;
1 REPLY 1
polingjw
Quartz | Level 8
You have an unbalanced quotation mark. Try repeatedly submitting the following code until you get an error message pertaining to the %mend statement with no matching %macro statement.

*/; *’; *”; stop; run; quit; %mend;

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1171 views
  • 0 likes
  • 2 in conversation