Jump to content

Recommended Posts

Posted


*********************************CONTENTS**********************************
[b][color=purple]Part1:  Basic concepts[/color][/b]
[color=teal]1. Introduction to Base sas[/color]
- Overview
- Components of base sas
[color=teal]2. Explore the workspace/understanding sas session[/color]
- Explorer window
- Editor window
- Log window
- Output window
- Results window
[color=teal]3. Sas programs[/color]
- Components of sas program
- Characteristics of sas program
- Layout of sas program
- Processing of sas program
- Log, output, results
[color=teal]4. Sas libraries[/color]
- How sas files are stored
- Creating libraries
- Storing files temporarily/permanently
- Referencing sas files
[color=teal]5. Sas datasets[/color]
- Overview of dataset
- Descriptor portion
- Data portion
- Attributes
- Missing values
- Temporary and permanent sas datasets

[b][color=purple]Part2: Getting your data into sas[/color][/b]
[color=teal]1. Introduction to data step processing[/color]
- Overview n sas dataset
- How the data step works
- Supplying information to create sas dataset
- How to read the data: styles of input
- Indicating the location of your data
[color=teal]2. Starting with raw data: basics[/color]
- List input method
- Column method
- Formatted method
- Mixed method
[color=teal]3. Starting with raw data: beyond the basics[/color]
- Line-hold specifiers
- Column pointers
- Line pointers
- Format modifiers
[color=teal]4. Starting with sas datasets[/color]
- Understanding the basics
- Reading selected observations/variables
- Keeping/dropping selected variables
- Creating more than one dataset in single data step
[b][color=purple]Part3: Basic Programming [/color][/b]
[color=teal]1. Understanding data step processing[/color]
- Understanding assignment statement
- Making uniform changes to data by creating variable
- Adding information to  some  observations but not others
- Making uniform changes to data without creating variables
- Using variables efficiently and Conditionally deleting observations
[color=teal]2. Working with numeric variables[/color]
- About numeric variables in sas
- Calculating with numeric variables
- Comparing numeric variables
- Storing numeric variables efficiently
[color=teal]3. Working with character variables[/color]
- About character variables in sas
[color=teal]4. Acting on selected observations[/color]
- Understanding the selection process
- Selecting observations based on condition
- Understanding construct conditions
- Comparing characters
[color=teal]5. Creating subsets of observations[/color]
- Selecting observations for a new dataset
- Conditionally writing multiple observations to one or more sas datasets
[color=teal]6. Working with grouped or sorted observations[/color]
- Understanding the basics of grouping data
- Working with grouped data
- Working with sorted data
[color=teal]7. Using more than one observation in a calculation[/color]
- Cumulating total for an entire dataset
[color=teal]8. Finding shortcuts in sas programming[/color]
- Performing more than one action in an if-then statement/do-loops
- Performing the same action for series of variables/arrays
[color=teal]9. Working with dates[/color]
- Understanding how sas handles dates
- Entering dates
- Displaying dates
[b][color=purple]Part4: Combining sas datasets[/color][/b]
[color=teal]1. Concatenating[/color]
[color=teal]2. Interleaving[/color]
[color=teal]3. Merging[/color]
[color=teal]4. Updating[/color]
[color=teal]5. Modifying[/color]
[color=teal]6. Conditionally processing observations from multiple sas datasets[/color]
[b][color=purple]Part5: Procedures[/color][/b]
- Contents -Copy  -Append -Datasets -Sort
- Format -Print -Options -Transpose -Import
- Export -Freq -Tabulate -Report -Means
- Summary -Sql -Gplot -Gchart -Univariate
[b][color=purple]Part6: Understanding your sas session[/color][/b]
[color=teal]1. Analyzing your sas session with the sas log[/color]
[color=teal]2. Directing sas output and sas log[/color]
[color=teal]3. Diagnosing and avoiding errors[/color]
[b][color=purple]Part7: Designing your own output[/color][/b]
[color=teal]1. Writing lines to the sas log or output file
[color=teal]2. Understanding and customizing sas output: the basics
[color=teal]3. Output delivery system[/color]
[b][color=purple]Part8: Macros[/color][/b]
[color=teal]1. Introduction to macro facility[/color]
[color=teal]2. Macro processing[/color]
[color=teal]3. Macro variables[/color]
[color=teal]4. Scope of macro variables[/color]
[color=teal]5. Macro expressions and Macro quoting[/color]
[color=teal]6. Interfaces with macro facility[/color]
[color=teal]7. Storing and reusing macros[/color]
[color=teal]8. Macro facility error messages and debugging[/color]
[b][color=purple]Part9: Sql[/color][/b]
[color=teal]1. Introduction to the sql procedure
- What is the sql procedure?
- Terminology
- Comparing proc sql with the sas data step
[color=teal]2. Retrieving data from a single table

- Overview of the select statement
- Selecting columns in a table
- Creating new columns
- Sorting data
- Retrieving rows that satisfy a condition
- Summarizing data
- Grouping data
- Filtering grouped data
- Validating a query
[color=teal]3. Retrieving data from multiple tables

- Introduction
- Selecting data from more than one table by using joins
- Using sub queries to select data
- When to use joins and sub queries
- Combining queries with set operators
[color=teal]4. Creating and updating tables and views
- Introduction
- Creating tables
- Inserting rows into tables
- Updating data values in a table
- Deleting rows
- Altering columns
- Creating an index
- Deleting a table
- Using sql procedure tables in sas software
- Creating and using integrity constraints in a table
- Creating and using proc sql views
[color=teal]5. Programming with the sql procedure
- Introduction
- Using proc sql options to create and debug queries
- Improving query performance
- Accessing sas system information using dictionary tables
- Using proc sql with the sas macro facility
- Formatting proc sql output using the report procedure
- Accessing a dbms with sas/access software
- Using the output delivery system (ods) with proc sql
[font=georgia][color=orange][/color][/font]


For more details please contact us at [email protected].

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...