topic What's the concept of "nesting" in SAS? in SAS Studio

What's the concept of "nesting" in SAS?

jc3992 — Mon, 05 Mar 2018 22:48:23 GMT

Hello everyone,

The code provided by our instructor was as below:

PROC TABULATE DATA = boats;
   CLASS Port Locomotion Type;
   TABLE Port, Locomotion*Type;
   TITLE 'Number of Boats by Port, Locomotion, and Type';
RUN;

Under "Table" command,

The "," (comma) means "crossing", and the "*"( the asterisk) means "nesting"

I am a bit confused about these two concepts.

I know "crossing" is like row and column,

but what about "nesting"?

Is there anybody would like to elaborate a little bit for me?

Thank you very much!

Re: What's the concept of "nesting" in SAS?

ballardw — Mon, 05 Mar 2018 23:00:18 GMT

Nesting means to for each level of Locomotion each level of type will have a column or row of output (depending on which dimension the nested expression is in.

If you have a data set run the code.

Or look at this with a data set you should have:

proc tabulate data=sashelp.class;
   class sex age;
   var height weight;
   tables sex*age,
          height*max weight*mean;
run;

which generates rows of data having age values within sex values. Note that M has a row for age 16 but F doesn't as there aren't any values of age=16 for females in that data set.

A secondary form of nesting involves the STATISTICS choices. The example above shows one statistic for height and weight. Using parentheses we can specify multiple statistics "nested" for an analysis variable:

proc tabulate data=sashelp.class;
   class sex age;
   var height weight;
   tables sex*age,
          (height weight) * (mean max);
run;

Requests mean and maximum values for both height and weight.

Re: What's the concept of "nesting" in SAS?

jc3992 — Tue, 06 Mar 2018 00:38:55 GMT

Thank you!

Understand!

Thanks for the example!