SAS Programming 2 Finance Case Study
SAS Programming 2 Finance Case Study
PGF2 : PGF2V1
This case study challenges learners to apply SAS Programming 2 data manipulation techniques to real-world banking data. Participants prepare, clean, and analyze data to generate reports for management and marketing, focusing on practical business questions and data quality.
Learn How To
- Explore and validate large financial datasets.
- Prepare and clean data for reporting and analysis .
- Merge, filter, and transform data using advanced SAS programming.
- Generate business reports and answer operational questions.
- Analyze social media influence and product usage.
- Export results and automate reporting tasks.
Who Should Attend
- SAS programmers who have completed SAS Programming 1 and want to advance their data manipulation skills..
- Data analysts and reporting professionals in finance.
- Anyone interested in practical SAS programming for business applications.
Prerequisites
- SAS Programming 1: Essentials
- SAS Programming 2 Data Manipulation Techniques
SAS Products Covered
Base SAS
Course Outline
- Explore product, contract, and customer data for quality and consistency.
- Prepare and split datasets into valid and invalid records.
- Identify social media influencers and high-risk customers.
- Analyze household structures and prepare targeted marketing lists.
- Generate Excel reports on product usage and profitability.
- Analyze revenue and cost by product and product group.
- Create dynamic reports using macro variables and advanced data steps.