Pragati Nale
- Role
- Sas Analyst at GuruSchools LLC
- Location
- New York, NY, US
- LinkedIn followers
- 500 followers
About Pragati Nale
Experience in SAS programming on different platforms, also having worked in …
Experience
Sas Analyst
Mar 2016 — Present
Worked for various Fortune clientele in Pharmaceutical, Banking, Healthcare and Insurance domains. Responsibilites : Base SAS: • Get Data in various format into SAS:(read.txt file.csv file, Excel file, format input (using SAS informat to read dates; use SAS format to display SAS date values). Proc Import) • Create temporary and permanent SAS data sets • Combine data sets (Concatenate, Append, interleave, Match Merge) • Use SAS Functions to manipulate SAS date values (Explanation on how SAS stores date and time values, SAS functions) • Use SAS Functions to manipulate character and numeric data values • Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements • Simplify data with multiple types of Array • Process data with DO LOOPS (the basic of DO LOOPS; constructing DO LOOPS; Conditionally Executing DO Loops using DO UNTIL and DO WHILE) • Work with data & Creating labels and formats. • SAS Statistical Procedures: Proc SORT; Proc PRINT; Proc MEANS; Proc FREQ; Proc UNIVARIATE, Proc Export, Proc Content. • Generate list reports using the PRINT procedure (using VAR, SUM, WHERE, ID and BY statements) • Generate reports using ODS statements (Identify ODS destinations, create HTML, PDF, RTF, and Excel files with ODS statements) • Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE Advanced SAS: • SAS/Macros- Creating Macro Variables/ Macro Programs, Debugging macros. Create data driven macro variables. Clear with concept of Global/local symbol table. Creating Macro program with parameters (keyword/positional/mixed). Conditionally processing macro calls. • SAS/SQL- Knowledge of Pass-through facility, query database. Types of Join Inner/Out/Full/Self Joins (Reflexive joins). Sub queries- Inner/Outer. In-line views. Creating portable Views. Can write quires to update/alter/modify existing tables. Knowledge of Set Operators- Except/Intersect/Union/Outer Union- Modifiers of set operators
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.