Sumayya asraf SAS Trainer,SAS programmer
No reviews yet

Strong presence of 10+ years in multiple domains, including 7+ year in data analytics. Currently working as SAS Trainer at Techsage Software Solutions
7+ years of SAS proficiency with expertise in programming
Working as a SAS trainer in multiple domain (Banking, Clinical, Retail) in various reputed training centers

I provide SAS Base & Advanced
SAS / statistical analysis system is an integrated software solutions system which helps to facilitate data entry, retrieval and management. Report writing and graphics design are also some of the other benefits of thorough SAS training. SAS is also a programming language used for applications development.

Course Module of Base SAS

What Is SAS?
• Introduction
• Getting Data into SAS
• A Sample SAS Program
• SAS Names
• SAS Data Sets and SAS Data Types

Writing Your First SAS Program
• A Simple Program to Read Raw Data and Produce a Report
• Enhancing the Program
• More on Comment Statements
• How SAS Works (a Look Inside the “Black Box”)
• Problems
Reading Raw Data from External Files
• Introduction
• Reading Data Values Separated by Blanks
• Specifying Missing Values with List Input
• Reading Data Values Separated by Commas (CSV Files)
• Using an Alternative Method to Specify an External File Contents
• Reading Data Values Separated by Delimiters Other Than Blanks or Commas
• Placing Data Lines Directly in Your Program (the DATALINES Statement)
• Specifying INFILE Options with the DATALINES Statement
• Reading Raw Data from Fixed Columns—Method 1: Column Input
• Reading Raw Data from Fixed Columns—Method 2: Formatted Input
• Using a FORMAT Statement in a DATA Step versus in a Procedure
• Using Informats with List Input
• Supplying an INFORMAT Statement with List Input
• Using List Input with Embedded Delimiters
• Problems
Creating Permanent SAS Data Sets
• Introduction
• SAS Libraries—The LIBNAME Statement
• Why Create Permanent SAS Data Sets?
• Examining the Descriptor Portion of a SAS Data Set Using PROC CONTENTS
• Listing All the SAS Data Sets in a SAS Library Using PROC CONTENTS
• Viewing the Descriptor Portion of a SAS Data Set Using the SAS Explorer
• Viewing the Data Portion of a SAS Data Set Using PROC PRINT
• Viewing the Data Portion of a SAS Data Set Using the SAS VIEWTABLE Window
• Problems
Subsetting and Combining SAS Data Sets
• Introduction
• Subsetting a SAS Data Set
• Creating More Than One Subset Data Set in One DATA Step
• Adding Observations to a SAS Data Set
• Interleaving Data Sets
• Combining Detail and Summary Data
• Merging Two Data Sets
• Omitting the BY Statement in a Merge
• Controlling Observations in a Merged Data Set
• When Does a DATA Step End?
• Merging Two Data Sets with Different BY Variable Names
• Merging Two Data Sets with Different BY Variable Data Types
• One-to-One, One-to-Many, and Many-to-Many Merges
• Updating a Master File from a Transaction File
• Problems
Creating Formats and Labels
• Adding Labels to Your Variables
• Using Formats to Enhance Your Output
• Regrouping Values Using Formats
• More on Format Ranges
• Storing Your Formats in a Format Library
• Permanent Data Set Attributes
• Accessing a Permanent SAS Data Set with User-Defined Formats
• Displaying Your Format Definitions
Reading and Writing Data from an Excel Spreadsheet
• Introduction
• Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set
• Creating an Excel Spreadsheet from a SAS Data Set
• Using an Engine to Read an Excel Spreadsheet
• Using the SAS Output Delivery System to Convert a SAS Data
• Set to an Excel Spreadsheet
• Problems
Performing Conditional Processing
• Introduction
• The IF and ELSE IF Statements
• The Subsetting IF Statement
• The IN Operator
• Using Boolean Logic (AND, OR, and NOT Operators)
• A Caution When Using Multiple OR Operators
• The WHERE Statement
• Some Useful WHERE Operators
• Problems
Performing Iterative Processing: Looping
• Introduction
• DO Groups
• The Sum Statement
• The Iterative DO Loop
• Other Forms of an Iterative DO Loop
• DO WHILE and DO UNTIL Statements
Working with Dates
• Introduction
• How SAS Stores Dates
• Reading Date Values from Raw Data
• Computing the Number of Years between Two Dates
• Demonstrating a Date Constant
• Computing the Current Date
• Extracting the Day of the Week, Day of the Month, Month, and Year from a SAS Date Creating a SAS Date from Month, Day, and Year Values
• Substituting the 15th of the Month when the Day Value Is Missing
• Using Date Interval Functions

Working with Numeric Functions
• Introduction
• Functions That Round and Truncate Numeric Values
• Functions That Work with Missing Values
• Setting Character and Numeric Values to Missing
• Descriptive Statistics Functions
• Computing Sums within an Observation
• Mathematical Functions
• Computing Some Useful Constants
• Generating Random Numbers
• Special Functions
• Functions That Return Values from Previous Observations
• Problems

Working with Character Functions
• Introduction
• Determining the Length of a Character Value
• Changing the Case of Characters
• Removing Characters from Strings
• Joining Two or More Strings Together
• Removing Leading or Trailing Blanks
• Using the COMPRESS Function to Remove Characters from a String
• Searching for Characters
• Searching for Individual Characters
• Searching for Words in a String
• Searching for Character Classes
• Using the NOT Functions for Data Cleaning
• Describing a Real Blockbuster Data Cleaning Function
• Extracting Part of a String
• Dividing Strings into Words
• Comparing Strings
• Performing a Fuzzy Match
• Substituting Characters or Words
• Problems

Working with Arrays
• Introduction
• Setting Values of 999 to a SAS Missing Value for Several Numeric Variables
• Setting Values of NA and? to a Missing Character Value
• Converting All Character Values to Lowercase
• Using an Array to Create New Variables
• Changing the Array Bounds
• Temporary Arrays
• Loading the Initial Values of a Temporary Array from a Raw Data File
• Using a Multidimensional Array for Table Lookup
• Problems
Displaying Your Data
• Introduction
• The Basics
• Changing the Appearance of Your Listing
• Changing the Appearance of Values
• Controlling the Observations That Appear in Your Listing
• Adding Additional Titles and Footnotes to Your Listing
• Changing the Order of Your Listing
• Sorting by More Than One Variable
• Labeling Your Column Headings
• Adding Subtotals and Totals to Your Listing
• Making Your Listing Easier to Read
• Adding the Number of Observations to Your Listing
• Double-Spacing Your Listing
• Listing the First n Observations of Your Data Set
• Problems

Creating Customized Reports
• Introduction
• Using PROC REPORT
• Selecting Variables to Include in Your Report
• Comparing Detail and Summary Reports
• Producing a Summary Report
• Using Two Grouping Variables
• Changing the Order of Variables in the COLUMN Statement
• Changing the Order of Rows in a Report
• Applying the ORDER Usage to Two Variables
• Creating a Multi-Column Report
• Producing Report Breaks
• Computing a New Variable with PROC REPORT
• Computing a Character Variable in a COMPUTE Block
• Creating an ACROSS Variable with PROC REPORT
• Using an ACROSS Usage to Display Statistics
• Problems
Summarizing Your Data
• Introduction
• PROC MEANS—Starting from the Beginning
• Adding a BY Statement to PROC MEANS
• Using a CLASS Statement with PROC MEANS
• Applying a Format to a CLASS Variable
• Deciding between a BY Statement and a CLASS Statement
• Creating Summary Data Sets Using PROC MEANS
• Outputting Other Descriptive Statistics with PROC MEANS
• Asking SAS to Name the Variables in the Output Data Set
• Outputting a Summary Data Set: Including a BY Statement
• Outputting a Summary Data Set: Including a CLASS Statement
• Using Two CLASS Variables with PROC MEANS
• Selecting Different Statistics for Each Variable
• Problems
Counting Frequencies
• Introduction
• Counting Frequencies
• Selecting Variables for PROC FREQ
• Using Formats to Label the Output
• Using Formats to Group Values
• Problems Grouping Values with PROC FREQ
• Displaying Missing Values in the Frequency Table
• Changing the Order of Values in PROC FREQ
• Producing Two-Way Tables
Creating Tabular Reports
• Introduction
• A Simple PROC TABULATE Table
• Describing the Three PROC TABULATE Operators
• Using the Keyword ALL
• Producing Descriptive Statistics
• Combining CLASS and Analysis Variables in a Table
• Customizing Your Table
• Demonstrating a More Complex Table
• Computing Row and Column Percentages
• Displaying Percentages in a Two-Dimensional Table
• Computing Column Percentages
• Computing Percentages on Numeric Variables
• Understanding How Missing Values Affect PROC TABULATE Output
• Problems

Introducing the ODS
• Introduction
• Sending SAS Output to an HTML File
• Creating a Table of Contents
• Selecting a Different HTML Style
• Choosing Other ODS Destinations
• Selecting or Excluding Portions of SAS Output
• Sending Output to a SAS Data Set
• Problems

Using Advanced Features of User-Defined Formats and Informats
• Introduction
• Using Formats to Recode Variables
• Using Formats with a PUT Function to Create New Variables
• Creating User-Defined Informats
• Reading Character and Numeric Data in One Step
• Using Formats (and Informats) to Perform Table Lookup
• Using a SAS Data Set to Create a Format
• Updating and Maintaining Your Formats
• Using Formats within Formats
• Using Multilabel Formats
• Using the INPUTN Function to Perform a More Complicated Table Lookup
• Problems

Restructuring SAS Data Sets
• Introduction
• Converting a Data Set with One Observation per Subject to a Data Set with Several Observations per Subject: Using a DATA Step
• Converting a Data Set with Several Observations per Subject to a Data Set with One Observation per Subject: Using a DATA Step
• Converting a Data Set with One Observation per Subject to a Data Set with Several Observations per Subject: Using PROC TRANSPOSE
• Converting a Data Set with Several Observations per Subject to a Data Set with One Observation per Subject: Using PROC TRANSPOSE
• Problems

Subjects

  • SAS Beginner-Expert

  • SAS Programming Beginner-Expert

  • Clinical SAS Beginner-Expert

  • SAS Base Beginner-Expert

  • SAS Advanced Beginner-Expert

  • SAS Clinical Beginner-Expert

  • Base SAS Beginner-Expert

  • Advanced SAS Beginner-Expert

  • Data analysis in SAS Beginner-Expert

  • Data Science with SAS Beginner-Expert

Experience

  • SAS programmer & SAS Trainer (Dec, 2021–Present) at Freelancing
  • As SAS Programmer and Trainer (Dec, 2015–Nov, 2021) at Techsage Software Solutions Pvt. Ltd, Bangalore
    • Accessing data from databases.
    • Coordinating with cross functional teams to retrieve data via SAS from data systems owned by CDM.
    • Transforms various formats (e.g. Excel, csv) received from both internal and external clients into SAS datasets.
    • Identifying data discrepancies through edit checks and back end reports to be reviewed by Data Managers.
    • Handle multiple therapeutic projects within timelines
    • Maintaining clinical data quality
    • Identifying clinical data issues and reporting to clients
  • As SAS Programmer and Trainer (Nov, 2012–Dec, 2015) at Syncorp Clincare Technology Pvt. Ltd, Bangalore
    • Trained in various data management skills like Merging, Handling missing values, Reading raw data files, creating data structures, Handling programming errors, Accessing and Managing data, Concatenating, and Interleaving of SAS datasets.
    • Has been trained on SAS/ODS procedures. Expertise with SAS/BASE, SAS/MACRO, SAS/SQL, AND SAS/ ODS.
    • Well-trained in importing and exporting EXCEL and ACCESS files using LIBNAME, PROC IMPORT, PROC EXPORT.
    • Broadly used SAS/MACRO for creating macro variables, macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.
    • Comprehensively prepared reports using SAS report generating procedures like PROC PRINT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, PROC TRANSPOSE, PROC SQL and PROC REPORT.
    • Well versed with using data _null_, SAS formats, Informats and functions, data manipulation & report.
    • Considerably experience in Data Merging, Data subsetting with the use of PROC SQL, MERGE and SET statements.
    • Trained on SAS/SQL for creating summary reports, Displaying query results, Generating Tables and Views, SQL joins and Set operators.
    • Doing efficient Programming using different methods i.e. by creating MACROs and supplying different kind of parameters for automation of code. Generated like-structured outputs using MACROS.
    • Using DO Loops for multiple iterations as well as using them in MACROs. Using Different Conditions in MACROs for executing SAS statements based on conditions and generating different outputs from the same MACRO.

Education

  • MSc bio engineering technology (Jun, 2001–Jun, 2003) from KSR College of Engineering Erode
  • bsc zoology (Jun, 1999–Jun, 2001) from govt.brennan college thalassery

Fee details

    ₹12,000–15,000/month (US$143.71–179.64/month)

    Base SAS 12000
    Advanced SAS 12000

Reviews

No reviews yet. Be the first one to review this tutor.