PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Create an index when creating a data file.
Create an index for an existing data file.
Combining Data Horizontally
Only keep matched observations between two files.
Only keep unmatched observations between two files.
Use an index to merge a smaller data file with a larger one.
Combining Data Vertically
Combine datasets vertically; use the SET dataset statement and list the datasets to be included.
Lookup Tables to Match Data
Write a SAS program for retrieving the city and state information from the second dataset which adds this information to the first dataset.
Create an output dataset by restructuring the values in a SAS dataset and transposing selected variables into observations.
Sorting SAS Datasets
z/OS: Calculate a sort work area based on the keys and the columns of data.
Controlling Data Storage Space
Compress and uncompress a SAS datasets.
Create a view to prevent users from continually submitting queries and omitting unwanted columns or rows.
Scalable Performance Data Engine
Process large datasets by accessing data from multiple physical files into partitions.
Given a set of procedures and code, modify the supplied program to execute only the necessary statements.
Eliminate unnecessary passes and read and write only essential data.
Updating SAS Datasets
Modify SAS datasets in place.
Create, use, and report with an audit trail.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.