Associate Consultant at Huquo
Views:2992 Applications:147 Rec. Actions:Recruiter Actions:0
Senior Analyst - SAS/Data Integration (2-8 yrs)
- To migrate SAS Data from Unix Servers to Linux Serves using SAS Procedures and test the data accuracy.
- To develop various SAS Macros for data migration and to test the accuracy of data migrated.
- Daily activities include gathering SAS libraries and their sizes to be migrated for the particular day.
- Migrate data to Linux using PROC Download and PROC Copy
- Test and compare all files that include datasets, index, views, catalogs etc. using
- PROC Contents and PROC Compare.
- Responsible for Preparing AML related data as per Business Requirement using SAS Procedures.
- Removing Duplicates records using SAS NODUP and NODUPKEY.
- Used SAS Functions (INTCK(), TODAY()) for picking transitions dates that were required by the business.
- Writing SQL queries to fetch required data from database tables as per requirements.
- Using SAS procedures for cleaning and analysing data
- Modifying data using SAS/BASE, SAS/SQL and SAS/MACROS.