Turn off your PDF (or other ODS destinations) before running the macro. Then you can make the printout you want from the dataset it generates. ... View more

Hi Ashy, You can mention the href option in ur plot statement. proc gplot data=rays; plot y*x = rad /haxis=axis1 href='href-value; by name; run; But if you want to save the trouble of writing it for each name, then you can use a macro like following: %macro macro-name(href,name); proc gplot data=rays; plot y*x = rad /haxis=axis1 href=&href; by &name; run; %mend; %macro-name(href1,name1); %macro-name(href2,name2); And so on… But if you want the values to come out directly from the rays datasheet. Then you can use the symput function. Hope this helps! Let me know if you have anymore question on this Message was edited by: neophyte ... View more

GLM will group the dependents by missing values. The maintain the order of the specified in the MODEL transpose the data and use a BY statement. [pre] dm 'clear log; clear output;'; data class; set sashelp.class; if _n_ in (2,3) then height=.; run; proc contents varnum short; run; proc glm; class _character_; model _numeric_ = sex; run; * To maintain variable order 1) transpose 2) establish variable order 3) sort 4) use BY statement in GLM ; step1: proc transpose data=class out=tall(rename=(col1=y)); by name sex; *unique ID for each row; var _numeric_; *the default; run; step2_a: proc transpose data=class(obs=0) out=vorder; var _numeric_; run; step2_b: data vorder(keep=_name_ vorder index=(_name_)); set vorder; vorder + 1; run; step2_c: data tall; set tall; set vorder key=_name_/unique; run; step3: proc sort; by vorder; run; proc print; run; step4: proc glm; by _name_ /*_label_*/ notsorted; class sex; model y = sex; run; [/pre] ... View more