Скачать или смотреть Introduction to PROC TABULATE (SAS)

For the best experience, please watch on full screen mode, at high resolution.

Example Code From Video:

title 'PROC TABULATE Demonstration';
proc tabulate data = SetA;
where VARC = 'Red'; /* This line filters the data so that only observations where the variable VARC is equal to 'Red' */
class VARD; /* The class statement specifies categorical variables. */
var VARB; /* The var statement indicates that VARB is a numerical variable that will be analyzed. */
table VARD ALL, /* VARD ALL: This means that the output will display each level of the VARD variable, along with an overall summary (ALL). */
VARB * (N Mean); /* This specifies that for each level of VARD, two statistics will be calculated for VARB: the count (N) and the mean (Mean). */
run;

/****************************************************************************************************/

title 'PROC TABULATE Demonstration (2)';
proc tabulate data = SetA;
class VARD; /* The class statement specifies categorical variables. */
var VARB; /* The var statement indicates that VARB is a numerical variable that will be analyzed. */
table VARD ALL, /* VARD ALL: This means that the output will display each level of the VARD variable, along with an overall summary (ALL). */
VARB * (N Mean); /* This specifies that for each level of VARD, two statistics will be calculated for VARB: the count (N) and the mean (Mean). */
run;

/****************************************************************************************************/

title 'PROC TABULATE Demonstration (3)';
proc tabulate data = SetA;
class VARA; /* The class statement specifies categorical variables. */
var VARB; /* The var statement indicates that VARB is a numerical variable that will be analyzed. */
table VARA ALL, /* VARD ALL: This means that the output will display each level of the VARD variable, along with an overall summary (ALL). */
VARB * (N Mean); /* This specifies that for each level of VARD, two statistics will be calculated for VARB: the count (N) and the mean (Mean). */
run;

/****************************************************************************************************/

title 'PROC TABULATE Demonstration (4)';
proc tabulate data = SetA;
class VARA; /* The class statement specifies categorical variables. */
var VARB; /* The var statement indicates that VARB is a numerical variable that will be analyzed. */
table VARA ALL, /* VARD ALL: This means that the output will display each level of the VARD variable, along with an overall summary (ALL). */
VARB * (N Median); /* This specifies that for each level of VARD, two statistics will be calculated for VARB: the count (N) and the mean (Mean). */
run;

Check out the GitHub for sample code and data:

https://github.com/RDScientist/DataRepo/

Also, check out the website for other articles and tutorials:

https://www.reflectionsofadatascienti...

Please come visit us for all of your data science needs!