Overview

Learn SAS programming from industrial usage perspective. SAS is one of the most used tool for data science, analytics and statistical analysis domain. This course is designed to give you good start on SAS programming quickly. The course has following highlightsGetting free access to SASImporting dataGetting basic feel of data- through contents, print, freq, univariate Data operations like merge, append, sort, truncate - rows / columns wise, derive new fields, analysis for each class Graphs - vertical bar chart / pie charts / stacked charts Statistical procedureTitle and labels for enhancementsTabulate for pivot table kind of workPutting together analysis with ODS HTML and colorful titleproc transpose to transpose the dataproc compare to compare datasetsThe course content in detail is as followsSection 1 - Getting access to SAS and understand SAS environmentGetting free access to learn SASGet familiar with SAS environmentUnderstand what isProgram editorLog windowOutput windowLibrary etc.Section 2 - Most used data operations in SASGet familiar with the Data for workoutImport data in SASViewing Meta DataViewing DataUnderstand various options to print Few records starting from a particular observationFew columns / all columnsDirect data entry in SASHow to be careful for character formatFrequency Distribution for categorical variablesUnderstand Various parts of the outputDefault and quantity based sorting orderStoring proc freq output into a SAS datasetWhy one should avoid proc freq for numeric variableNumeric Variable AnalysisUnderstand Proc Univariate and Proc MeansAdvantages of both the approachesRequesting few statistics only in the outputSorting Data Understand -How to sort on the basis of one variable / two variablesHow to keep original data as it is and store sorted data in a new datasetHow to sort data in descending orderHow to remove duplicatesWhat is first. and last. option and how to use itMerging n Dealing with missing dataUnderstand What is merging dataWhat are the Pre requisites of merging dataWhat is left join, right join and equi joinHow to do various kinds of joinHow is missing value represented for numeric and character variableSyntax for replacing missing value for a numeric variableSyntax for replacing missing value for a character variableAppending datasetsUnderstand What is appending datasets?How to append data?What happens when datsets have different columns and still you want to append it?Derive New fieldWrite if else logic to create a derived fieldLearn to use OR operatorUnderstand how to define length for proper display of variableArithmetic Logical n comparison OperatorsGet to know the different Arithmetic, Logical and Comparison operators we haveDemo of how to use them for the whole data setAlso see how to keep only those records, which meets certain criteriaTruncating data rows n columns wiseLearn how to keep or drop few fields from a given datasetLearn to keep or delete few records meeting certain criteriaPart of string using SubstrUnderstand the syntax for substringSee the workout examplein operatorUnderstand the usage of in operatorSee the demo to understand how does it make it easy to compare multiple string in one goCrossTab using SASUnderstand How to create cross tab in SAS?How to interpret the outputHow to supress some statistics from the result?Numeric Variable Analysis for each classUnderstand how to conduct analysis for each distinct value of a particular categorical variable easily using class statementDealing with datesUnderstand date 9 formatThe usage of mdy function to create dateFind days / years spend between two datesUse round function to get nicely formatted valueProc SQL n Fetching data from databaseUnderstand the utility of Proc SQLUnderstand the process of getting data from databases using proc SQLSection 3 - Statistical procedures and report enhancementsConducting linear regression analysis using SASUnderstand how to conduct linear regression analysis using SASHow to get the regression equation, coefficient of determination etc.How to interpret coefficient of determinationHow to make out, it is a positive or negative relationshipConducting Chi square analysis using SASUnderstand how to get chi square statistics for contingency tableHow to make sense of degree of freedom, chi square statistics, p value etc. Conducting one way ANOVA analysis using SASLearn the syntax of ANOVA analysis using SASLearn to interpret the box plot appearing with ANOVA analysisLearn to make sense of p value of ANOVAGraphs in SASLearn to Create vertical bar chartCreate horizontal bar chart How to get just the percentage or freq, percent allHow to create stacked bar chart (where bars of numeric variable can show distribution of a categorical variable)How to create a pie chartDifference between proc gchart and proc chartHow to create chart of a numeric variable for each class separatelyTitle and LabelHow to put specific title above the print / graph output etc.How does title 1 and title 2 differWhat is labelWhat is the use of these title and label statementProc tabulate - pivot table in SASUnderstand the syntax of proc tabulateSee proc tabulate and Excel pivot table side by sideODS HTML to package the output and rich text title (bold, colorful)Proc transpose to transpose the dataProc compare to compare datasetsSection 4 - Practice Case Studies - apply your knowledge to solve business problems

Skills

Reviews