Automated Cosmetic Claim Analysis (SAS)

Project Overview

This project presents an automated SAS macro for evaluating cosmetic claims using questionnaire data. It processes responses ("Yes"/"No") to assess whether differences between formulas are statistically significant using Chi-Square and Fisher’s exact tests.

Key Features

• Automatic detection of questions: Dynamically parses variables to identify claim questions.
• Long format conversion: Transforms dataset into a tidy long format.
• Statistical testing: Runs both Chi-Square and Fisher’s tests on each claim.
• PDF Reporting: A full report is automatically generated (raw data, formatted tables, and visual p-value graphs).

Technologies Used

• SAS (Base + ODS) for data manipulation, statistical testing, and report generation
• ODS PDF for stylized output

Conclusion

This tool enables quick, standardized, and automated analysis of claim support in cosmetic studies. It is particularly useful for R&D and evaluation teams aiming to make data-driven decisions without manual processing.

Available for freelance support in automating cosmetic efficacy reporting pipelines.