SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I want to generate the median of a variable, and I understand that PROC SQL is only capable of calc median horizontally and not vertically. Now my question is, if I use proc means, is there a way to output the median to a macro variable? I'm hoping to find a more code-efficient way instead of having to write another datastep to call symput to a macro variable.

my current code:
proc means data=tmp_aaa noprint;
var pvol;
output out=tmp_median_aaa median=tmp_median_aaa;
;
run;

data tmp_median_aaa;
set tmp_median_aaa;
call symput('tmp_median_aaa', tmp_median_aaa);
run;
3 REPLIES 3
DanielSantos
Barite | Level 11
Hello.

From my knowledge this is the most efficient way of doing this.

You could use the SELECT INTO: feature of PROC SQL to populate a macro var after doing the necessary aggregation. But as you already pointed out, there is no support for MEDIAN(X) summary functions (vertically), just the common datastep MEDIAN function (horizontally).

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.
Paige
Quartz | Level 8
I don't think there is a more "code efficient" way than using call symput. This is the way I do it.
deleted_user
Not applicable
I agree with the other posters. A very (very) slight improvement would be to avoid outputting the median data set again, as in:

data _null_;
set tmp_median_aaa;
call symputx('tmp_median_aaa', tmp_median_aaa);
run;

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 7621 views
  • 0 likes
  • 3 in conversation