Dear community,   The below code successfully draws 4 polygons of fill colours red, blue, green, and yellow, respectively.   proc sgplot data=MyData aspect=1 noborder nowall noautolegend sganno=MyData subpixel; styleattrs datacolors=(red blue green yellow); polygon x=x y=y id=id / fill nooutline group=id; xaxis display=none; yaxis display=none; run; I am trying to replace the hardcoded colours by a variable of a different dataset, like so: styleattrs datacolors=(OtherDataSet.colours); (where OtherDataSet.colours neatly has 4 observations being: red blue green yellow) However, it fails with the error: "Syntax error, expecting one of the following: a name, a quoted string." Is there something obvious I am missing?   Thanks so much for your help!   ... View more

Dear community,   I have a short question that hopefully someone knows the answer to. Suppose you'd wish to simply extract 5 datasets from 1 dataset, using a macro: %macro MyMacro; %do i = 1 %to 5; CurrentAnimal = ('dog', 'cat', 'sheep', 'cow', 'horse') (i) proc sql; create table Want_ & i as select * from Have where Animal = CurrentAnimal; quit; %end; %mend MyMacro; %MyMacro It gives no errors, but no output either. Anyone knows what's going on and how to fix it?   Thank you in advance! ... View more

Dear community,   I was hoping for a bit of help with a simple question. I have a dataset with two columns such as this: Column1 Column2 A 123 A . A 123 A 456 B . B 789   All I'm looking for is to fill in the missings of Column2 with the mode by Column 1, like this: Column1 Column2 A 123 A 123 A 123 A 456 B 789 B 789   I know that it's possible with a select distinct and left join in proc sql, but since I am an R user, I'd highly appreciate a loop solution. In R, one solution is this: for(X in unique(Data[,"Column1"])) {    Data[Data[,"Column1"]==X&is.na(Data[,"Column2"]),"Column2"] <- which.max(table(Data[Data[,"Column1"]==X,"Column2"])) }   Surely there's some equivalent in SAS? Thanks a lot! ... View more