loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Base SAS

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Inqra- Institute of Qualified Researchers and Analysts

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Base SAS

Base SAS

Koramangala 6th Block, Bangalore

30,000

No Reviews Yet
0 Interested

About the Course


Description of the course:
PROGRAMMING 1:
Focus point on the key factors of the course: i) The process of reading the raw data sets including the SAS Data sets
ii) The process of investigating the data and create summarized data through descriptive statistics and generating frequency tables
iii) The incorporation of new variables and recoding data values
iv) How to subset data
v) How to combine multiple data sets based on the business requirement
vi) The process of creating reports (HTML, listing, summary and graph
reports).
The objective remains in writing Base SAS codes.
However if the objective lies in not to write programs and incorporate a menu- driven point-and-click approach, the course of “The Process of writing Queries and incorporate Reporting using SAS Enterprise Guide should be taken”.

PROGRAMMING 2:
The focus lies with an intermediate level objective of managing both input and the output SAS data sets including the DATA steps, having the competency of being able to work with different data types and hence manipulate and transform the data for various business requirements, Combine the multiple data
sets , Create Summarization of data. The skill sets are also developed for incorporation of Arrays and DO
loops for iterative processing of data Content of the Course:

Topics Covered

Content of the Course:
First Module of Programming:
i)Introduction
? Overview of the different platforms of SAS
? Comparison of SAS against the different competitors
? Overview of the Foundation SAS
? Integrating the opportunities, strengths, weaknesses, threats and the way the business world sees SAS.
ii) The process of starting with Base SAS
? An introduction to the programming world in Base SAS.
? How to submit a program in the environment of Base SAS.
iii) How the SYNTAX in Base SAS works
? The amalgamation of the fundamental concepts
? How to diagnosis an error in syntax and the process of debugging and correcting syntax errors.
iv) The world of SAS Data Sets
? The difference between descriptor and data portion and how to examine each of them in the
output.
? The concept of encapsulated library in SAS & the process of accessing the libraries.
? The process of accessing the different relational databases in SAS.
v) How to read the SAS Data Sets
? An introduction to the world of reading different types of data.
? The process of incorporating SAS Data Set as an input.
? The phenomena of sub setting (Both variables as well as observations).
? How to add permanent attributes
vi) How to read the Excel Worksheets
? The process of incorporating Excel Data as an input.
? The process of doing more with Excel Work Sheets.
vii) How to read the Delimited Raw Data Files
? The process of incorporating standard delimited data as an input.
? The process of incorporating non-standard delimited data as an input.
viii) How to validate & clean data
? An introduction to the process of validation and cleaning data.
? How to examine the errors in data when reading the raw data files.
? The process of validating data with the PRINT and FREQ procedures.
? The process of validating data with the MEANS and UNIVARIATE procedures.
? How to clean the invalid data.
ix) The process of manipulating data
? How to create new variables.
? How to create variables with the conditional statements.
? How to subset the observations.
x) The world of combining the SAS data sets.
? An introduction to the world of combining data sets.
? How to Append a data set.
? The incorporation of Concatenation of data sets.
? Merging Data Sets (One-to-one).
? Merging Data Sets (One-to-many).
? Merging Data Sets (With nonmatches).
xi) Report Enhancements
? Incorporation of the global statements.
? How to add labels and formats.
? The process of creation of user-defined formats.
? The process of grouping and sub setting observations.
? The process of directing the outputs to the external files.
xii) Creation of the Summarized Reports
? Using the Proc Freq Procedure
? Using the Proc Means Procedure
? Using the Proc Tabulate Procedure
xiii) The incorporation of SAS/Graph & introduction to graphics.
? How to create pie charts and bar graphs Programmatically.
? How to create plots.
? How to enhance the outputs.

Second Module of Programming:

i)Introduction
? A brief overview of the course and the integration of the learning so far from a business
problem.
? The review of the SAS Syntax.
? The process of navigating the windowing environment of SAS.
ii) How to incorporate the control mechanism on input as well as the output.
? How to incorporate outputs for multiple observations.
? How to write to multiple data sets.
? The mechanism of selecting the variables as well as the observations.
iii) The art of creating summarized data.
? The art of creating a variable having the characteristic of accumulating the total.
? The art of creating accumulating totals for a group of data.
iv) Process of reading the Raw Data Files
? How to read the raw data files having a formatted input.
? The art of control mechanisms at the time of loading a record.
? The enhanced and additional techniques that can be incorporated for inputs which are listing in
nature.
v) Transformation of Data
? The skill of manipulating the character values.
? The skill of manipulating the numeric values.
? The skill of converting the variable type as per the business requirement/ client specifications.
vi) The techniques of Debugging
? How to incorporate the PUTLOG statements.
? How to incorporate the DEBUG option.
vii) How to iteratively process data
? The incorporation of DO LOOPS
? The incorporation of ARRAYS
? The processing mechanism of DO LOOPS
? The processing mechanism of ARRAYS
viii) How to restructure a given Data Set by the client/ business.
? The process of rotating, incorporating the powerful SAS Data Steps.
? The trick of using the procedure of TRANSPOSE.
ix) The requirement of combining multiple SAS Data sets.
? The trick of match merging for the advanced data manipulation techniques.
x) An exposure to the various other diverse SAS Languages.
? A feel and flavor of the other SAS Languages through an overview.
? An exposure of SQL procedures (More extensively in Advanced SAS for Programming).
? An exposure of Macro (More extensively in Advanced SAS for Programming).

Who should attend

1) Any Graduate or Masters
2) Working professionals
3) Willing to learn and make a better career in SAS

Pre-requisites

1) No SAS experience or programming experience is required,
2) Although you should have some computer experience and the need to learn how to program beyond point-and-click techniques.

What you need to bring

1) Laptop with windows 7 and 64 bit operating system
2) Notepad

Key Takeaways

Plan and write simple SAS programs to solve common data analysis problems
Summary: create simple list and summary reports, define new data columns (variables) execute conditional code navigate the SAS windowing environment.
You will be eligible for applying jobs related to "SAS Programming or data management"
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Document

Data Management & Reporting Using...

There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Accredited Trainers

Bpharm, MSc Stat, Clinical Research, BE


1) Leading Corporate SAS Trainer in India
2)Working in SAS Data management for BIG MNC,s as a Consultant,
2) Ex Trainer of "SAS India"
3) Globally Certified Programmer,
Seats Left-

Students Interested 0

Course Id: 27853