![sas interview questions listen data sas interview questions listen data](https://image.slidesharecdn.com/sassql-091113122824-phpapp01/95/sas-proc-sql-29-728.jpg)
![sas interview questions listen data sas interview questions listen data](https://bs-uploads.toptal.io/blackfish-uploads/uploaded_file/file/13011/image-1550836783450-7490e0c77553977e391ef41983965853.png)
Your final task before writing your own PROC TABULATE step is to specify the statistics needed.
![sas interview questions listen data sas interview questions listen data](https://images.sumry.me/storage/images/9ba720ff673c279da431eb082024e881.png)
Proc tabulate data=clinic.diabstat class type sex var totalclaim premium table type table type premium table type,premium table type,premium,sum run Two-dimensional tables always have row and column headings one-dimensional tables only have column headings. Commas, one type of operator, separate the dimensions of the table. Dimension expressions can also contain operators that you use when combining elements to produce the table you want. SAS Techies 2009 TABLE page-expression, row-expression, column-expression Dimension expressions contain elements.
![sas interview questions listen data sas interview questions listen data](http://1.bp.blogspot.com/-KYBMI9-CtnI/U3NDzmAGUaI/AAAAAAAAAY0/c19ZR0Z81dE/s1600/SAS+Interview+Questions+and+Answers.gif)
SAS Techies 2009 11/13/09 You use the TABLE statement to specify the number of dimensions in the table (page, row, column) the variables in the table ( Sex, Height ) the statistics to be calculated (MAX) SAS Techies 2009 the same variable cannot appear in both the CLASS statement and the VAR statement in the same step. (PROC TABULATE prints each value of a class variable.) Analysis Variables Unlike class variables, analysis variables must be numeric are used for arithmetic analysis often contain continuous values. have only a few distinct values, in most cases. TABLE defines the table to display your data -uses variables and statistics to form the table.Ĭlass variables can be character or numeric. SAS Techies 2009 11/13/09 PROC TABULATE invokes the procedure and identifies your data set CLASS specifies variables used to classify data VAR analyze data - uses variables and statistics to form the table. To set up a table with PROC TABULATE, you need to identify the data you are analyzing, and then determine which variables, if any, you need to classify your data which variables, if any, you need to analyze your data the type of table you need to represent your data. SAS Techies 2009 proc tabulate data=diabstat class type var premium table type premium run proc tabulate data=clinic.admit class sex var height weight table sex,height*min weight*min run proc tabulate data=clinic.admit class sex actlevel var height weight table actlevel,sex,height*min weight*min run 11/13/09 Height Weight Min Min Sex 61.00 118.00 F M 69.00 147.00 ActLevel HIGH ActLevel LOW Height Weight Min Min Sex 66.00 140.00 F M 72.00 168.00 Height Weight Min Min Sex 61.00 118.00 F M 71.00 154.00 modify virtually every feature of a table calculate percentages produce sub-reports without sorting data summarize data and produce a report in one step generate multiple tables in one step. PROC TABULATE creates customized one-, two-, and three-dimensional tables that display any of a large number of descriptive statistics. Sharad C Narnindi Attic Technologies,Inc 2005Ĭreating SAS Tables, Listings, Basic Statistics Procedures with SAS Graphs ODS HTML Proc Report and Other Utility Procedures TLG’s 11/13/09 SAS Techies 2009ĭescriptive Distributive SAS Techies 2009 11/13/09.