SAS Training in Noida
SAS is a software suite developed by SAS Institute for advanced analytics, multivariate analysis, business intelligence, data management, and predictive analytics. SAS was developed at North Carolina State University from 1966 until 1976, when SAS Institute was incorporated.
- Lectures: 12
- Students: 5
- Duration: 10 weeks
Convergent Learning Solutions offers Best SAS Training in Noida according to current industry standards. Our training programs allow professionals to secure their placement in the MNC. One of Noida’s most recommended SAS training associations, practicing practical knowledge / practical implementation of live projects and ensuring work with the help of advanced level SAS training courses . SAS training in Noida is conducted by qualified corporate experts with over 8 years experience in implementing real-time SAS projects.
Content
Introduction to SAS programs Submitting a SAS program Submitting a SAS program Mastering fundamental concepts Diagnosing and correcting syntax errors Diagnosing and correcting syntax errors Examining descriptor and data portions Accessing SAS data libraries Accessing relational databases Accessing relational databases Introduction to reading data Using SAS data as input Subsetting observations and variables Adding permanent attributes Adding permanent attributes Using standard delimited data as input Using nonstandard delimited data as input Introduction to validating and cleaning data Examining data errors when reading raw data files Validating data with the PRINT and FREQ procedures Cleaning invalid data Cleaning invalid data Creating variables Creating variables conditionally Subsetting observations Subsetting observations Introduction to combining data sets Appending a data set Concatenating data sets Merging data sets one-to-one Merging data sets one-to-many Merging data sets with nonmatches Merging data sets with nonmatches Using global statements Adding labels and formats Creating user-defined formats Subsetting and grouping observations Directing output to external files Directing output to external files Using the FREQ procedure Using the MEANS procedure Using the TABULATE procedure Using the TABULATE procedure Creating bar and pie charts Creating plots Enhancing output Enhancing output Enhancing output Outputting multiple observations Writing to multiple SAS data sets Selecting variables and observations Selecting variables and observations Creating an accumulating total variable Accumulating totals for a group of data Accumulating totals for a group of data Reading raw data files with formatted input Controlling when a record loads Additional techniques for list input Additional techniques for list input Manipulating character values Manipulating numeric values Converting variable type Converting variable type Using the PUTLOG statement Using the DEBUG option Using the DEBUG option DO-loop processing SAS array processing Using SAS arrays Using SAS arrays Rotating with the DATA step Using the TRANSPOSE procedure Using the TRANSPOSE procedure Using the TRANSPOSE procedure Controlling I/O Controlling data set size Compressing SAS data sets Controlling memory Controlling the page size and the number of available buffers Controlling the page size and the number of available buffers Creating and using an index Creating a sample data set Creating a sample data set Introduction to lookup techniques In-memory lookup techniques Disk storage techniques Disk storage techniques Using formats as lookup tables Using a picture format Using a picture format DATA step merges and SQL procedure joins Using an index to combine data Combining summary and detail data Combining data conditionally Combining data conditionally Combining data conditionally Overview of the SQL procedure Specifying columns Specifying rows Specifying rows Presenting data Summarizing data Summarizing data Introduction to SQL joins Complex SQL joins Complex SQL joins Introduction to set operators The EXCEPT operator The INTERSECT operator The UNION operator  The OUTER UNION operator  The OUTER UNION operator Creating views with the SQL procedure Creating tables with the SQL procedure Creating tables with the SQL procedure Setting SQL procedure options Dictionary tables and views Dictionary tables and views Introduction to indexes Creating indexes Maintaining tables Maintaining tables LIBNAME access to DBMS data Executing DBMS-specific SQL using the SQL Pass-Through Facility Executing DBMS-specific SQL using the SQL Pass-Through Facility Executing DBMS-specific SQL using the SQL Pass-Through Facility Course logistics Purpose of the macro facility Program flow Program flow Introduction to macro variables Automatic macro variables Macro variable references User-defined macro variable Delimiting macro variable names Macro functions Macro functions Defining and calling a macro Macro parameters Macro storage Macro storage Creating macro variables in the DATA step Indirect references to macro variables Retrieving macro variables in the DATA step Creating macro variables in SQL Creating macro variables in SQL |