topic Re: avgmin=mean(min(of col1-col1070)); in SAS Programming

avgmin=mean(min(of col1-col1070));

Steelers_In_DC — Thu, 26 Sep 2013 20:51:39 GMT

If I am using the subject in code but don't want to hardcode 1070 what are my options? I'm looking into using an array but wondering if there is something simple to add here like end or last.

Thanks,

Re: avgmin=mean(min(of col1-col1070));

data_null__ — Thu, 26 Sep 2013 20:54:01 GMT

of COL:

However your use of mean(min(of does not make sense.

Re: avgmin=mean(min(of col1-col1070));

Astounding — Thu, 26 Sep 2013 20:56:43 GMT

Are you asking for the right thing? After all, you would get the same number if you removed the MEAN function.

Re: avgmin=mean(min(of col1-col1070));

plf515 — Thu, 26 Sep 2013 21:08:10 GMT

Or, if you don't want ALL of COL, but want COL1 through COL XXXX you can just define a macrovariable and use it

%let endnum = 1070;

then use COL1-COL&endnum;