topic Re: Multiple Fields As Columns in SAS Procedures

Multiple Fields As Columns

CraigKaercher — Wed, 01 Oct 2014 21:28:14 GMT

This has to be a really simple question but I have been looking through examples and cannot find a good one. Here is my input:

DATA LISTINP;

infile "~/Pgm1ExtInp.txt";

INPUT ID HEIGHT WEIGHT GENDER $ AGE;

RUN;

I want to sum HEIGHT and WEIGHT as columns in the resulting table so the result would look something like:

GENDER HEIGHT WEIGHT

SUM SUM

Male 210 650

Female 190 600

I am trying to use the PROC TABULATE but it is not working. There seem to be at least a hundred examples of how I could break up HEIGHT by GENDER across HEIGHT values and the same for WEIGHT but none where I can just get those values as columns. If this were a SQL statement it would be:

SELECT GENDER, SUM(HEIGHT), SUM(WEIGHT)

FROM LISTINP

GROUP BY GENDER

ORDER BY GENDER;

I have to think the answer looks something like:

PROC TABULATE DATA=LISTINP;

TITLE 'Summary of Height and Weight';

class GENDER;

var HEIGHT, WEIGHT;

table GENDER , HEIGHT * WEIGHT;

But that doesn't work. All help appreciated. Thanks.

RUN;

Re: Multiple Fields As Columns

ballardw — Wed, 01 Oct 2014 21:42:35 GMT

PROC TABULATE DATA=LISTINP;

TITLE 'Summary of Height and Weight';

class GENDER;

var HEIGHT WEIGHT;

table GENDER , (HEIGHT WEIGHT)*sum;

run;

Or: height*sum weight*sum; the statistic isn't formally needed as defaults to sum for VAR but I prefer to explicitly state the statistic so I can debug easier.

Your request with height*weight is going to attempt to nest (cross) height and weight.

Also, remove the comma from the VAR statement.

Re: Multiple Fields As Columns

CraigKaercher — Wed, 01 Oct 2014 21:58:40 GMT

Thank You! That does it. You will probably be seeing a number of simple questions from me disguised as discussions soon. Thanks again.

Re: Multiple Fields As Columns

ballardw — Wed, 01 Oct 2014 23:06:33 GMT

If they are questions please post them as questions, Even simple ones. Discussions can't get marked as answered. If a question has been adequately answered then the rest of us, unless curious, know that additional comment is not required and we can spend time on the items that need help.