ERROR IN Query of SAS VA

Reply
Frequent Contributor
Posts: 81

ERROR IN Query of SAS VA

hi

I am getting and  error "The submitted line exceeds maximum line length - 32768 bytes" on running a query." and

"NOTE: The autoexec file, /opt/sas/config/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization."

"NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set."

Please help me to eliminate the errors.

the log details are mentioned below:

NOTE: SAS Initialization used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: The autoexec file, /opt/sas/config/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.

ERROR: The submitted line exceeds maximum line length - 32768 bytes.

1          ;*';*";*/;quit;run;

NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.

NOTE: PROCEDURE PRINTTO used (Total process time):

      real time           0.04 seconds

      cpu time            0.05 seconds

     

NOTE: Libref MSSQLLIB was successfully assigned as follows:

      Engine:        ODBC

      Physical Name: mssqldynamics

NOTE: Libref LASRLIB was successfully assigned as follows:

      Engine:        SASIOLA

      Physical Name: SAS LASR Analytic Server engine on local host, port 10031

NOTE: The "<>" operator is interpreted as "not equals".

NOTE: SQL view WORK.TEMP_LASR_VIEW_5834 has been defined.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.04 seconds

      cpu time            0.05 seconds

     

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

      table-expression referenced a summary function.

-anand

Ask a Question
Discussion stats
  • 0 replies
  • 238 views
  • 0 likes
  • 1 in conversation