MENU

Fun & Interesting

PROC REPORT in SAS|Combining the power of PROC TABULATE, PROC FREQ, PROC MEANS into One Procedure

Learnerea 28,575 3 years ago
Video Not Working? Fix It Now

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

Comment