PROC REPORT in SAS|Combining the power of PROC TABULATE, PROC FREQ, PROC MEANS into One Procedure
PROC REPORT in SAS|Combining the power of PROC TABULATE, PROC FREQ, PROC MEANS into One Procedure|Learnerea
Whenever you are doing some analytical work or exploratory data analysis, you require some method or technique which could help you to put the numbers in a way you want to see it and that's where the PROC REPORT comes to help. Here in this video we have tried to explain the PROC REPORT in the simplest form and from the perspective of statistical analysis which will help you to understand this procedure quickly and once you start using this in your work, you can take it to the next level very easily.
In this video we have covered -
00:00 - Introduction to PROC REPORT
00:31 - Introduction to PROC REPORT Syntax and its statments/elements in detail
03:14 - Understanding basics of PROC REPORT with an example
04:43 - Writting a basic PROC REPORT in SAS
05:17 - Understanding COLUMNS statement in PROC REPORT
05:56 - Giving heading in PROC REPORT
06:46 - Grouping columns together under one header using COLUMNS statement in PROC REPORT
08:00 - Understanding DEFINE statement in PROC REPORT
09:02 - GROUP option/action in DEFINE statement
10:32 - ACROSS option/action in DEFINE statement|Taking count of non-missing records by two colums one as row heading and another as column heading
12:09 - All the options which can be used in DEFINE statement
12:30 - Using numeric variables to get required statistics by each of the categories
14:37 - Using statistical option MEAN with DEFINE statement to find the MEAN for each of the categories mentioned on column heading and on row heading
15:02 - Renaming the column headings
18:36 - Repeating all the items of subgroup in each of the groups using COMPLETEROWS
19:50 - Filtering the report by category in grouped item using WHERE statement
20:35 - Calculating total for each of the Group using BREAK statement either before the group starts or at where the group ends using AFTER and BEFORE statement
22:10 - Calculating total of all the columsn at the bottom using RBREAK statement
22:58 - Producing report for each of the groups separatly on different page using PAGE option in BREAK statement
23:21 - Creating a calculated variable or conditional variable in PROC REPORT using COMPUTE statement
#SASTutorials #SASforBeginners #Learnerea #SASTraining #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial #ProcReport #ProcReportinSAS