Analyitc project

1) Created various analytical model like linear, mixed linear, logistic regression, ANOVA. 2) Analyzed data using various statistical PROCEDURES like PROC SUMMARY, PROC MEANS PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA . 3) Created SAS datasets from Oracle database by using SAS Macros. 4) Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE. 5) Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Conduct extensive data checks to ensure data quality. 6) Execute data crunching, write codes, merge/purge/ and split data, and do ad hoc queries/cut data programming in SAS 7) Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Oracle DB 8) Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements. 9) Developed new or modified SAS programs and using Libname methods to extract data from the Oracle DB and created study specific SAS datasets, which are used as source datasets for report generating programs. 10) Created Reports using PROC TABULATE and PROC REPORT. 11) Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction 12) Proposed a set of action plans to mitigate the risks identified with the sourcing decision 13) Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical PROCEDURES using PROCEDURES like PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS.