topic Re: Calculating Mean for Specific Range of Imported Data in SAS Procedures

Calculating Mean for Specific Range of Imported Data

amir17 — Thu, 28 Feb 2019 18:12:24 GMT

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.

Re: Calculating Mean for Specific Range of Imported Data

novinosrin — Thu, 28 Feb 2019 18:17:09 GMT

List your variable names in the var statement in proc means

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

Re: Calculating Mean for Specific Range of Imported Data

Astounding — Thu, 28 Feb 2019 18:21:52 GMT

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;

Re: Calculating Mean for Specific Range of Imported Data

amir17 — Thu, 28 Feb 2019 18:34:03 GMT

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?

Re: Calculating Mean for Specific Range of Imported Data

novinosrin — Thu, 28 Feb 2019 18:36:13 GMT

run a proc contents on your imported dataset

PROC contents DATA=WORK.MYDATA;
run;

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

Re: Calculating Mean for Specific Range of Imported Data

Reeza — Thu, 28 Feb 2019 18:37:08 GMT

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.

Re: Calculating Mean for Specific Range of Imported Data

amir17 — Thu, 28 Feb 2019 18:41:02 GMT

I see. Thanks for the info. Much appreciated.