PROC SGPANEL ERROR ERROR: An exception has been encountered.

dcortell — Fri, 13 Oct 2023 16:39:17 GMT

Hi experts

All of a sudden I’m starting to get the following error below about sgpanel

Any idea about the root cause?

Bests

MPRINT(SOURCED):   proc sgpanel data=tr_test (where=(lowcase(opportunity_type) contains "software" or lowcase(opportunity_type)

contains "managed"));

MPRINT(SOURCED):   panelby countryname opportunity_type;

MPRINT(SOURCED):   vbar class / response=col1 group=_name_ stat=sum nostatlabel groupdisplay=cluster;

MPRINT(SOURCED):   run;



NOTE: Since no format is assigned, the numeric category variable will use the default of BEST6.

NOTE: Compressing data set WORK._SGSORT_ increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: Compressing data set WORK._OPNTMP000000000000000000000 increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.



ERROR:  An exception has been encountered.

Please contact technical support and provide them with the following traceback information:



The SAS task name is [SGPANEL ]

Segmentation Violation

Re: PROC SGPANEL ERROR ERROR: An exception has been encountered.

dcortell — Fri, 13 Oct 2023 19:33:31 GMT

I discovered the error being associated to the variable length utilized, which was changed in the mart with a huge format of $480.

I re-formatted the var to $30. and the error is not showing anymore

topic PROC SGPANEL ERROR ERROR: An exception has been encountered. in SAS Programming

PROC SGPANEL ERROR ERROR: An exception has been encountered.

Re: PROC SGPANEL ERROR ERROR: An exception has been encountered.