I want to produce a forest plot from my dataset here enclosed.  I write this code: proc sgplot data=plot; scatter x=pmr_max y=atc81chr1 / group=causa xerrorlower=pmr_inf_max xerrorupper=pmr_sup_max markerattrs=or (symbol=CircleFilled size=8 color=red) ; run;   and this the result   I want to ask:  1. how can I have different colors for each causa 2. I would like to have the different PMR_max for each ATC81chr1 in column and not on the same line (see the last line 'Costruzioni navali').  Thanks for you help Stefania   ... View more

Hi, I wish to create a new variable Newcode using conditions and "Contains" instruction. Considering the example here attached  the variable Newcode has to satisfy this condition :   if (ateco81='830' or ateco81='982') and (ateco91='93020' or ateco91='93021') and (attsoc contains "PArrucch*" or "Barbier*")) then Newcode ='999'; Obviously this instruction doesn't work. Can you give me any suggestion? Thanks Stefania   Version SAS 9.4  ... View more

     I want to use TRANSLATE  in more than one lines in the program (see example1) but the instruction doesn’t work. I works only if I write one line at a time. Is it correct?  Do I have to split each time for different dataset  and write one instruction at a time such Example 2? Is there a way to write all the instruction together?    Thank you Stefy67   Example1: data tre; set due; nomenew3 = translate(nomenew2,'AAAAAAAAAAA','ÀÁÂÃÄÅÆĀĂĄǍ'); cognomenew3 = translate(cognomenew2,'AAAAAAAAAAA','ÀÁÂÃÄÅÆĀĂĄǍ'); nomenew3 = translate(nomenew2, 'IIIIIIIIII' , 'ÌÍÎÏĨĪĬĮİǏ'); nomenew3 = translate(nomenew2, 'OOOOOOOOO' , 'ÒÓÔÕÖŌŎŐǑ'); cognomenew3 = translate(cognomenew2, 'IIIIIIIIII' , 'ÌÍÎÏĨĪĬĮİǏ'); cognomenew3 = translate(cognomenew2, 'OOOOOOOOO' , 'ÒÓÔÕÖŌŎŐǑ'); run;   Example2: data tre; set due; nomenew3 = translate(nomenew2,'AAAAAAAAAAA','ÀÁÂÃÄÅÆĀĂĄǍ'); run;  data tre1; set tre; cognomenew3 = translate(cognomenew2,'AAAAAAAAAAA','ÀÁÂÃÄÅÆĀĂĄǍ'); run;     ... View more

I have this problem: some values in VAR1 (see example) have special characters ( À   Á   Â   Ã   Ä   ). I want to find these special characters in a string and replace it with the correct letter (A) as showed in VAR2 of the example. Var1 Var2 SIAHMED SIAHMED DANDREÁ DANDREA PELLIÇANO PELLICANO MATÃ MATA DONZELLA DONZELLA DAGOSTINO DAGOSTINO ÔTTINA OTTINA   I tried this instruction var2 = TRANWRD (var1, "Á ", "A");  and it works but if I include more than one target it doesn't var2 = TRANWRD (var1, "Á" or "Ã", "A");   Waiting for your suggestion Thanks ... View more