auserj / advanced_programming_for_sas

Big_Data, Database_Organization, Statistical_Analysis

Advanced Programming for SAS

Goal

Major topics include SQL processing with SAS and the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. This Repository helps you to learn the Advanced Programming for SAS and research methods.

Research Process:

• Identify and formulate the problem
• Determine the research design
• Design the sample and method of data collection
• Collect the data
• Analyze the data
• Interpret, discuss, and present the finfdings
• Follow-Up

The Workflow of data:

• Create structure
• Enter/Import data
• Clean data (Missing data/Outliers/data entry error)
• Describe data
• Transform data
• Create a Codebook

Hypothesis Testing:

• Formaulate the Hypothesis
• Choose the significant level
• Select an approriate test
• Calculate the test statistic
• Make the test decision
• Interpret the results

Regression Analysis:

• Check the regression analysis data requirements
• Specify and estimate the regression model
• Test the regression analysis assumptions
• Interpret the regression results
• Validate the regression results
• Use the regression model

Usage

Windows users

• In VirtualBox, select the SAS University Edition vApp, and then select Machine > Start. It might take a few minutes for the virtual machine to start.
• In a web browser on your local computer, enter http://localhost:10080.
• From the SAS University Edition: Information Center, click Start SAS Studio.

Codebook (Tutorial)

• Performing Queries Using PROC SQL
• Performing Advanced Queries Using PROC SQL
• Combining Tables Horizontally Using PROC SQL
• Combining Tables Vertically Using PROC SQL
• Creating and Managing Tables Using PROC SQL
• Creating and Managing Indexes Using PROC SQL
• Creating and Managing Views Using PROC SQL
• Managing Processing Using PROC SQL
• Introducing Macro Variables
• Processing Macro Variables at Execution Time
• Creating and Using Macro Programs
• Storing Macro Programs
• Creating Indexes
• Combining Data Vertically
• Combining Data Horizontally
• Using Lookup Tables to Match Data
• Formatting Data
• Modifying SAS Data Sets and Tracking Changes

Code (Sample)

• SAS_SQL_Access.sas
• SAS_Subsetting.sas
• SAS_Functions.sas
• SAS_Correlation_and_Linear_Regression.sas
• SAS_Regression.sas
• SAS_Graphing.sas

License

This project is licensed under the MIT License - see the LICENSE file for details