Problem annodate in data set

LuizSousa — Wed, 23 Jul 2014 20:08:20 GMT

Pessoal, estou com um problema na hora de gerar um GCHAR

O problema que imprime no log é esse:

NOTE: ERROR DETECTED IN ANNOTATE= DATASET WORK.ANLABELS.

NOTE: PROBLEM IN OBSERVATION 11 -

DATA SYSTEM REQUESTED, BUT VALUE IS NOT ON GRAPH 'SUBGROUP'

Ambulatório

NOTE: PROBLEM IN OBSERVATION 25 -

DATA SYSTEM REQUESTED, BUT VALUE IS NOT ON GRAPH 'MIDPOINT'

|Agreste|Meridional

NOTE: PROBLEM IN OBSERVATION 26 -

DATA SYSTEM REQUESTED, BUT VALUE IS NOT ON GRAPH 'MIDPOINT'

|Agreste|Meridional

Esse problema acontece quando o tamanho da variável carácter ultrapassa um certo limite.

No exemplo acima a variável tem esse conteúdo "|Agreste|Meridional 08.12 -|07.13"

		data anlabels(drop=nome_unimed indicador );
		length text $ 8 cbox $ 10;
		retain function 'label' when 'a' xsys ysys '2' hsys '3' size 2 ;
		set tab_final_grafico;
		midpoint=nome_unimed; subgroup=indicador;

	text=" " \|\| left(put(valor,percentn12.2));
	position = 'e';
/*	y = cumpct - (valor/2);*/
	if indicador = 'Consulta' then
		do; cbox = "#AC1632";
		color = "white"; end;
	else if indicador = 'SADT' then
		do; cbox = "#FFD100";
		color = "black"; end;
	else if indicador = 'Ambulatório' then
		do; cbox = "#B9D300";
		color = "black"; end;
	else if indicador = 'Internação' then
		do;cbox = "#009FAF";
		color = "white"; end;

		where nome_orig in (&varFiltro.);
		;
		run;

		/* Define the axis characteristics */
		axis1 color=white
		value=(justify=center) split='\|' label=none ;
		axis2 color=white LABEL=NONE
		order=(0.00 to 1 by 0.1)
		minor=(n=10);

		pattern4 color="#FFD100"; /SADT/
		pattern3 color="#009FAF"; /Internação/
		pattern2 color="#AC1632"; /Consulta/
		pattern1 color="#B9D300"; /Ambulatorio/

		/* Define legend options */
		legend1 frame cframe=white;

	proc gchart data=tab_final_grafico;
	vbar nome_unimed / subgroup=indicador
	sumvar=valor
	legend=legend1
/*	nostats*/
	maxis=axis1
	raxis=axis2
	annotate=anlabels
			width=8
		;
	where nome_orig in (&varFiltro.);

		format valor percentn12.2;
		run;
		quit;

Re: Problem annodate in data set

GraphGuy — Thu, 24 Jul 2014 12:39:26 GMT

Based on Google's translation of the Portuguese problem description:

... This problem happens when the size of the character variable exceeds a certain limit. In the above example the variable has that content "| Wasteland | South 08:12 - | 07:13"

I think you are running into the 32-character length limit. I recently entered a feature-request to get the length limit increased (tracking number S1096736), which the developers completed 2 weeks ago, and should be in the upcoming SAS 9.4-maintenance-3 release. The example I gave the developers used Proc Gplot, and I'll check to make sure the enhancement also works in Proc Gchart.

In the meantime (while you wait on the 9.4m3 SAS release), I think the only work-around is to use shorter text values, with length <=32 characters.

Re: Problem annodate in data set

LuizSousa — Thu, 24 Jul 2014 13:26:05 GMT

Thanks, I had not thought about that detail. I'm waiting for 9.4.

		pattern4 color="#FFD100"; /SADT/
		pattern3 color="#009FAF"; /Internação/
		pattern2 color="#AC1632"; /Consulta/
		pattern1 color="#B9D300"; /Ambulatorio/

topic Re: Problem annodate in data set in Graphics Programming

Problem annodate in data set

Re: Problem annodate in data set

Re: Problem annodate in data set