Calculating Mean for Specific Range of Imported Data

[amir17]

I imported my .xlsx file into SAS and have no problem calculating the mean for the entire sheet using the below code:

PROC MEANS DATA=WORK.MYDATA;
run;

But what code do I add if I want to calculate the mean just for a specified range of cells (e.g. A2-A50)? I'm working with version 9.2.

[novinosrin]

List your variable names in the var statement in proc means

PROC MEANS DATA=WORK.MYDATA mean;
var A2--A50;
run;

[amir17]

I don't have any variables actually named "A2" or "A50." I meant the cells A2, A3, A4, etc. within an Excel spreadsheet. Any advice on this?

[novinosrin]

run a proc contents on your imported dataset 

like

PROC contents DATA=WORK.MYDATA;
run;

Then you should be able to get the name of the  variables to list in the var statement

[Reeza · Accepted solution]

That's not how SAS works, you can't access specific cells easily. Usually, you reference a column or row at the same time. You can also specify to treat groups consistently. I suggest you post some actual data that shows what you have and what you want out of that.

[amir17]

I see. Thanks for the info. Much appreciated.

[Astounding]

Do you know the names of your variables? If they are actually named a1-a99 for example you could add before the RUN statement:

var a2-numeric-a50;