Data Science and Data Preparation Article Overview by Gerhard

[#1]

This is a navigation article for all my SAS Communities contributions. It is used as a central navigation point for the content that I provided at this platform and is updated with every new article that I publish.

Last updated: 2022-01-10

Articles are clustered by different content dimensions, thus they might appear more than once in the list below.

Most Recent Articles

• Feature Engineering #1 - Using Correlation Analysis to Describe Behavior over Time
• Feature Engineering #2 - Accordance with predefined pattern
• Feature Engineering #3 – Describing the Trend over Time

Feature Engineering

• Feature Engineering 1 - Using Correlation Analysis to Describe Behavior over Time
• Feature Engineering #2 - Accordance with predefined pattern
• Feature Engineering #3 – Describing the Trend over Time
• 3 ways to consider movable holidays in SAS

 

Data Quality for Analytics

• The structure of MISSING VALUES in your data - get a clearer picture with the %MV_PROFILING macro
• Using the TIMESERIES procedure to check the continuity of your timeseries data
• Replace MISSING VALUES in TIMESERIES DATA using PROC EXPAND and PROC TIMESERIES
• Have a look at your TIMESERIES data from a bird's-eye view - Profile their missing value structure
• Using SAS Enterprise Miner for Predictive Modeling Simulation Studies
• Using the GLMSELECT procedure to calculate individual reference values in outlier detection
• Early Picture of the Data Quality Status of Your Analysis Data? SAS® Visual Analytics Shows You How

Data Assembly

• Transpose your analysis data with the %MAKELONG and %MAKEWIDE macro

Tipps and Tricks

• Automatically highlight data-driven events with reference lines in line-charts
• 3 ways to consider movable holidays in SAS

Analytics and SAS/STAT Procedures

• Encoding of CLASS Variables in Regression Analysis - Better understand the ORDINAL encoding

• Display the hidden estimate for the reference category in EFFECT coding for better interpretability

• %CALC_REFERENCE_CATEGORY displays the "hidden" coefficient in EFFECT encoding for CLASS variables

Simulating Data and Models

• Using SAS Enterprise Miner for Predictive Modeling Simulation Studies
• Simulate timeseries data with a SAS DATA Step and SAS Functions

SAS Global Forum Papers

• SUGI2006: Efficient “One-Row-per-Subject” Data Mart Construction for Data Mining
• SGF2015: Early Picture of the Data Quality Status of Your Analysis Data? SAS® Visual Analytics Shows You How
• SGF2018: Getting More Insight into Your Forecast Errors with the GLMSELECT and QUANTSELECT Procedures

References

Find more details in my webinars at Youtube:

• DataPreparation4DataScience 
• Data Science Use Cases

and on Medium | LinkedIn | Github | SAS-Books

Most of the content of these articles is taken from my SAS Press books

• Data Quality for Analytics Using SAS
• Applying Data Science - Business Case Studies Using SAS
• Data Preparation for Analytics Using SAS

[Phil_NZ]

Hi @gsvolba 

Thank you for sharing, but when I click onto your GitHub, it leads to your LinkedIn profile.

Warm regards.

[gsvolba]

Hi Phil, 
thanks for pointing this out! I just corrected it.

it is https://github.com/gerhard1050 
best regards, Gerhard