I need generate 3-by-2 plots, which the code below does. BUT also need let the lines are with varied colors.   There are GROUPLC= and styleattrs datacontrastcolors=(red green black orange blue cyan);  BUT only for multiple lines within a single plot. How to get 3-by-2 plots with controlled/varied colors?   Any other PROC is fine.    Thanks,     data _test; do grp=1 to 6; do ind=1 to 100; yvalue=sin(ind/10)+grp; gx=grp; output; end; end; run;quit; ods layout gridded columns=3 rows=2 advance=bygroup; proc sgplot data=_test noautolegend uniform=xscale; by grp; series x=ind y=yvalue / group=grp lineattrs=( thickness=2 pattern=solid) grouplc=grp ; refline 30/axis=x lineattrs=(color=red thickness=2 pattern=solid); run; ods layout end; ... View more

Say need to let someone at another city to run a home-made SAS macro,  AND does not want to expose the coding details, HOW TO DO IT?! Thanks,  ... View more

The code is straightforward, to get the dif from two variables. The dataset has the two variables, which are both of numeric. But the one inside marco complains. The "same" code works ok without macro. Anyone?! MPRINT(DOLOOP): proc sql ; MPRINT(DOLOOP): select avg(IF)-avg(dlastprice) into: lpadj from hs300_0604 ; ERROR: The AVG summary function requires a numeric argument. MPRINT(DOLOOP): quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 59956 proc sql; 59957 select avg(IF)-avg(dlastprice) from hs300_0604 ; 59958 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds ... View more

I have a setting file, the top two lines are below(it have 10+ lines). Need to update the sinx_index value with a macro variable from SAS run.  How to do it?! Any convenient way, thanks,    [global] sinx_index=100   ... View more