Greens Technology
15 First Street Padmanabha Nagar, Adyar, Chennai
      Greens Technology Contact

Data Integration Table Course content

Integrated Course Outline

Base SAS

  • Navigate the SAS windowing environment
  • Read various types of data into SAS data sets
  • validate and clean SAS data sets
  • Create SAS variables and subsets data
  • Control SAS data set input and output
  • Summarize , read, and write different types of data
  • perform DO loop and SAS array processing
  • Transform character, numeric , and data variables

Advance SAS

  • Create a framework for developing macro application
  • Develop reusable macros
  • Read and process macro parameters
  • Pass and process macro paramters
  • Query and subset data
  • Summarize and present data
  • Combine tables, including complex joins and merges
  • Create and modify table views and indexes
  • Replace multiple DATA and PROC steps with SQL query
  • Control memory , I/O, and CPU resources
  • Create and use indexes
  • Combine data horizontally and vertically
  • Use hash and hiter DATA step component objects, arrays , and formats as lookup tables
  • Compress SAS data sets
  • Sample your SAS data sets

SAS Data Integration

  • Register source data and target tables
  • Create jobs and explore the functionality of the job Editor
  • Work with many of the various transformations
  • Enhance table relationships using integrity constrains, key, and indexes
  • work with slowly changing dimensions
  • Create custom transformation with the Transformation Generation Wizard
  • Document and deploy jobs
  • Administer SAS Data integration Studio

  • Dinesh J
    CEO, Greens Technology
    Trainer, Exp: 12 yrs
    Mobile: +91 8939915577
  • Corporate training given to following

  • My students are working with