Hi ALL, executing a PROC IMPORT of Excel file, in the "RATING" variable, i find a dot value (.) instead of original value (2-).   the PROC IMPORT and EXPORT used is the following..   PROC IMPORT OUT= pio.DRO_478PAR_S_2 DATAFILE= "C:\Users\393571\Desktop\IRION_Schedulatore\&BMRC\Monitoraggio_DRO\ALL\DRO_478PAR-S_2.xlsx" DBMS=EXCEL REPLACE; RANGE="Monitoraggio_DRO_478PAR-S_2_Fla$";  GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run; @@@@@@ PROC EXPORT DATA= pio.DRO_478PAR_S_1_DIR2 OUTFILE= "C:\Users\393571\Desktop\IRION_Schedulatore\&BMRC\Monitoraggio_DRO\ALL\DRO_478PAR_S_1_DIR2.xlsx" DBMS=EXCEL REPLACE; SHEET="NDG_ARRICCHITI_DIR"; RUN;   moreover you'll find input (DRO_478PAR-S_2_SAS) and output (DRO478PAR-S_1_DIR2_SAS) .xlsx file   Thank's for your support , ever precious   don't esitate to ask for more details or deep analysis   K Regards Pio ... View more

hi All,  running with 9.4 SAS i'm experiencing a trouble with gspanel "BAR CHART" rapresentation...   proc sgpanel data=rwork.DATI_FIN_sorted_2 (where=(MERCATO = ('CORPORATE') )) ; format NDG comma18.0 ; styleattrs datacolors=(medium_orange brown lime green ); title1 f='Albany AMT/bold' h=0.8 color=depk justify=center "rilevazione documenti fiscali su perimetro BMRC del &BMRC_DT" ; title2 f='Albany AMT/bold' h=0.8 color=depk justify=center "eseguito alla data del &rundt" ; panelby coverage / layout=columnlattice novarname noborder colheaderpos=bottom; Vbar CLUSTER_ANNO / response=NDG group= TIPO_DOCUM groupdisplay=CLUSTER /*clusterwidth=1*/ stat=freq dataskin=gloss BARWIDTH=1 datalabel datalabelattrs=(weight=bold) /*seglabel*/ seglabelattrs=(size=10) ; colaxis LABEL='CLUSTER ANNO BILANCIO' ; rowaxis LABEL= '# Bilanci' grid; run; quit;       substantially a DB of 12.357 NDG observation  (Corporate) is showed in Histogram graph of 13.649 observation...... attacched you'll find data in sheet (FF) and  , graph and log result in sheet (GRAPH_LOG). thank's a lot for your support KRegards Pio Piccinin   ... View more

hi All, i'm in truble subtracting "date" (from %Let) with another "date" field.... following is showed the code definition... %let rundt = %sysfunc(date(),date9.) --- --- select 663 NDG_OPERATORE_ECONOMICO, 664 COD_TIPO_ORG, 665 COD_FORMA_GIURIDICA, 666 DTA_NAS, 667 rundt. - DTA_NAS as delta_date,                  -                 22 668 case when rundt. - DTA_NAS >= 540 then 'NO_Start_UP'                                     -                                    22 ERROR 22-322: Syntax error, expecting one of the following: un nome, *. 669 else 'SI_Start_UP' 670 end AS Start_UP 671 672 673 FROM ANGRFC.ANA_OPERATORE_ECONOMICO 674 GROUP BY 1,2,3,4,5 -     thank's in advance for your support and suggestions Pio Piccinin ... View more

Hi All, is there anyway a solution to display (inside the histogram) the corrispondent % value,  instead the numeric value, leaving the total numeric value on top ? in fact i don't have %value and it should be computed .... the source data is enclosed i hope to be clear .... thank's a lot for your support Pio Piccinin   ... View more

  hi All, my problem is to show various unit by group up to 100% as in file enclosed.. someone could help me?   thank's in advance Pio   ... View more

hi All, this is my first question to you and hope to be clear to help you in answer... so .. my problem is to break the bigger histogram  to allow the other two (very little) to be shown better ... i try to break it but unfortunately it remain the bigger! in attachment you 'll find 1) data in input 2) graph before and after   i hope in your help to solve this topic thank's in advance Kregards Pio     ... View more