" /> Computer System Analyst | Compu21

Setup Menus in Admin Panel


Setup Menus in Admin Panel

Computer System Analyst

  I. Fundamental SAS and Statistics Getting Started Using SAS Software SAS interface / Windows and Commands in the Programs …



    I. Fundamental SAS and Statistics

    Getting Started Using SAS Software

    • SAS interface / Windows and Commands in the Programs
    • The SAS Language / Syntax and naming conventions
    • Data sets, variables and observations
    • Programming logic / Data library
    • SAS data Sets / The Two Parts of a SAS program
    • Reading the SAS Log / Using System Options

     Getting Data into the SAS System

    • Basic statements / Methods for getting data into the SAS System
    • Reading raw data / Hierarchical files and mixed records types
    • Packed-decimal data / Random sample
    • Mix input styles (column, formatted, pointer control)

     Working with SAS Data Sets

    • Creating and redefining variables (numeric, character,and date)
    • Functions / Date values
    • Grouping observations / Subsetting the data
    • Informats / Format / Arrays
    • Checking the structure and the attribute of  SAS data set

    Modifying and Combining Data Sets

    • Modifying a data set using the SET statement
    • Stacking and interleaving data sets
    • One-to-one match merge / One-to-many match merge
    • Merging summary statistics with the original data
    • Updating master data set with transactions Proc transpose
    • Automatic variables

    Debugging SAS Programs

    • Data step debugger / PUT statement

    Using Utility, Reporting, and Basic Statistical Procedures

    • Proc Sort                  *  Proc Print
    • Proc Means              *  Proc Freq
    • Proc Tabulate          *  Proc Report
    • Proc SQL                  *  Proc Gchart
    • Proc Format            *  Proc Datasets
    • Proc Tabulate          *  Proc Rank
    • Proc Univariate       *  Proc Summary
    • Proc Corr                  *  Descriptive statistics

    SAS Macro (introduction)

    • Macro concepts / Macro variable
    • Substituting text with Macro variables
    • Creating Module Code with Macros
    • Adding parameters / Macros with conditional logic
    • CALL SYMPUT   Debugging Macro Errors

    II. Advanced SAS


    •  Data Sample and Distribution
    •  Hypothesis and test
    •  Uni-variate Analysis
    •  Bi-variate Analysis
    •  Multi-variate Analysis


    • Linear Regression
    • Logistical Regression
    • Poisson regression
    • Survival Analysis
    • Two Step Models
    • GEE Model
    • Mixed Model
    • Time Series Analysis
    • Colinearity Diagnosis


    • Factor Analysis
    • Cluster Analysis
    • Sensitive Analysis
    • Propensity Score Analysis
    • Instrumental Variable Analysis


    • Clinical Trials
    • Advanced SQL
    • Advanced MACRO
    • Advanced Tables and Graphs
    • Monte Carlo Simulations
    • Power Calculation
    • Random Sampling
    • Odd Ratio vs. Relative Risk
    • Weight and Survey Procedures

    III. VBA w/ Excel Macros

    Module 1

    • Preliminary comments on VBA
    • Power and value of this language
    • Limits and restrictions of the standard Excel User Interface
    • Extending Excel’s built-in capabilities
    • Survey of general solutions
    • Visual Basic Editor (VBE)/Integrated Development Environment (IDE)

    Module 2

    • Building code automatically
    • The role of variables and constants
    • Data Types
    • Variable and procedure scopes
    • Enumerations
    • Arrays
    • Naming convections
    • Object Browser

    Module 3

    • Control flow – beyond linear execution
    • If…Then statement
    • For…Next statement
    • For each statement
    • Do loop statement
    • Select Case statement
    • Interacting with the user & collecting inputs

    Module 4

    • Writing subroutines
    • Calling a subroutine
    • Creating code shells
    • Parameters to a procedure
    • ByRef and ByVal purposes
    • Writing functions
    • Calling functions
    • Terminating a program arbitrarily
    • Linking to external projects and libraries

    Module 5

    • Workbooks object
    • Core members
    • Workbook object
    • Core members
    • Worksheet object
    • Core members
    • Range object
    • Core members
    • Error handling to boost program robustness
    • Trouble-shooting/Debugging

    Module 6

    • User Form:
    • As central I/O point
    • For improving Excel real estate
    • Consolidated controls
    • Guides decision making
    • Data validations
    • Providing choices to the user
    • Miscellaneous topic

    IV. MS SQL Server

    • Chapter 1

    “Introduction to Microsoft SQL Server 2005/2008,” introduces you to SQL Server and explains what SQL Server is. The chapter provides a cohesive overview of SQL Server so that you can understand how all the pieces fit together.

    • Chapter 2

    “Using Transact-SQL on a SQL Server Database,” introduces you to Transact-SQL and provides details about how to create and execute Transact-SQL statements in order to manage a SQL Server database and its data. The chapter also introduces you to the SQL Server programming tools that allow you to use Transact-SQL to interface with the database.

    • Chapter 3

    “Designing a SQL Server Database,” introduces you to the process of creating a SQL Server database. It describes the basic concepts of database design and provides information about planning a database, identifying system requirements, and developing a logical data model.

    • Chapter 4

    “Implementing SQL Server Databases and Tables,” explains how to create and manage a SQL Server database. It then discusses data types and how to identify which ones to use when creating a table. The chapter also describes how to create these tables—using the data type information—and how to modify the tables after they have been created.

    • Chapter 5

    “Implementing Data Integrity,” provides an overview of the various methods that you can use to maintain data integrity and a description of the types of data integrity that you will find in a SQL Server database. The chapter also provides detailed information about the various types of integrity constraints that you can use to enforce data integrity and how to implement them in a database.

    • Chapter 6

    “Accessing and Modifying Data,” provides detailed information about four Transact-SQL statements (SELECT, INSERT, UPDATE, and DELETE) and describes how each statement is used in Query Analyzer to retrieve and modify data. This chapter also introduces you to other methods for adding, modifying, and deleting data.

    • Chapter 7

    “Managing and Manipulating Data,” describes more techniques for managing and manipulating data, including how to import and export data, how to manipulate heterogeneous data, how to use Transact-SQL cursors, and how to extract data in XML format.

    •  Chapter 8

    “Implementing Stored Procedures,” introduces you to the types of stored procedures available in SQL Server 2005 and how to create, execute, and alter them. You are also introduced to programming stored procedures.

    •  Chapter 9

    “Implementing Triggers,” introduces you to triggers and how to use them to extend data integrity and implement complex business logic. You will learn when it is appropriate to implement triggers and when basic constraints will suffice. You will also learn how to program triggers and how to use system commands and functions commonly used in trigger programming.

    • Chapter 10

    “Implementing Views,” introduces you to views and the various functionality that they support. You will learn how to use views to insert, update, and modify data.

    • Chapter 11

    “Implementing Indexes,” introduces you to the structure and purpose of indexes and the types and characteristics of indexes. You will learn how to determine when an index is appropriate, the type of index to create, and how to create it.

    • Chapter 12

    “Managing SQL Server Transactions and Locks,” introduces you to the fundamentals of transactions and locks and describes how transactions and locks are used to process data modifications.

    •  Chapter 13

    “Designing and Administering SQL Server 2005 Security,” introduces you to SQL Server security. You will learn how to design SQL Server security to accommodate user requirements and protect the database from unauthorized access.

    • Chapter 14

    “SQL Server Monitoring and Tuning,” examines how to use SQL Profiler to monitor a database system and explores methods of improving database performance through partitioning and index tuning.i

    Course Reviews

    No Reviews found for this course.

    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts