Business Online Course by Udemy, On Sale Here
Learn SAS programming through data workout. See sorting, merging, appending, graphs, tabulate, statistical procedure etc
An excellent training about Business Analytics & Intelligence
SAS Programming from Scratch & Practice Case Studies workout
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, univariateData operations like merge, append, sort, truncate rows / columns wise, derive new fields, analysis for each classGraphs vertical bar chart / pie charts / stacked chartsStatistical 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 follows-Section 1: Getting access to SAS and understand SAS environment-Getting free access to learn SASGet familiar with SAS environmentUnderstand what isProgram editorLog windowOutput windowLibrary etc-Section 2: Most used data operations in SAS-Get 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 columnsprecautionDirect data entry in SASHow to be careful for character formatFrequency Distribution for categorical variablesUnderstandVarious 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 AnalysisUnderstandProc Univariate and Proc MeansAdvantages of both the approachesRequesting few statistics only in the outputSorting Data UnderstandHow 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 dataUnderstandWhat 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 datasetsUnderstandWhat 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 SASUnderstandHow 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 SQL-Section 3: Statistical procedures and report enhancements-Conducting 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
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.