Hello guys,   can you please advise with the following? I need to combine multiple tables based on list of values with the following structure:   Table1   Table2   Desired output Col1   Col2 Col3   Col1 Col4 A   BBB 5   A 90 B   CCC 10   B 40 C   AA 15   C 10     AAAA 20           AAA 25           A 30           B1 35         that means that in table1 I have list of values and I need to sum quantity from Col3 but there is no exact match with Col1 and Col2.   Thanks in advance Jan ... View more

Hello guys,   I need to create data driven macro based on table values to export several ppt slides.   this is the table called "Acc": Acc 261726 109338 79878   I need something like the below but instead of number 1-3 assign the values from the table and generate slide for each of the value:   %MACRO generate; %do i=1 %to 3 ;    goptions reset= all  device= PNGT;    ods powerpoint   file="&p\RegionalActivity_&i..ppt" nogtitle nogfootnote style=htmlblue; options nodate nonumber;  goptions reset= all; ods graphics / reset=all; ods region; proc odstext; p "&i"/ style = [font_size = 16pt color=#2f4696 background=a00000000]; run;   ods layout end;  ods powerpoint close; %END; %MEND generate;   %Generate;      Can you please advise how to define the variables? Apologies if this was already described but I haven't found appropriate answer. Thanks!     ... View more

Hello,   Can you please advise how to assign different colors for datalabels in sgplot hbar chart? With datalabelattrs =(color=)  statement I can put just 1 color for all datalabels together, I need different color for each series (4 bars - "1","2","3" and "4" - I need to assign different color for each bar).  THANK YOU!!!   proc sgplot data=Americas noborder noopaque nowall pad=0 noautolegend; goption xpixels=400 ypixels=300;   hbar ID / response=TotalCases stat=sum datalabel group=ID dataskin=matte nooutline nostatlabel datalabelattrs=(size=12) clusterwidth=0.9 barwidth=0.96; styleattrs datacolors=('#D4002C' '#009354' '#EF820F' '#6C206B');    xaxis display=none valueattrs=(color=black size=11pt) LABELATTRS=(color=black size=12pt); yaxis values=( "1" "2" "3" "4") display=(NOVALUES NOLINE) display=none display=(noticks) label=' ' ; run;   ... View more