BASE SAS- Foundation tool for SAS Programmers

1. Basics of SAS Data Access

Accessing different files into SAS library

Accessing flat files from different sources using Proc Import and sending the datasets to external source file like flat files using Proc Export

Accessing the external database source data like ORACLE /SQL SERVER/TERADATA/MYSQL etc.. Into sas library.

Accessing very large volume of data from external source

Imporving performance

INPUT styles refer to how you read and interpret data from raw text files (or data lines) using the INPUT statement

INFILE statement in SAS is essential when you're reading external (raw) data files (like .txt, .csv, .dat, etc.) into SAS datasets.

Controlling and Filtering

Reading and writing the date formats and custom formats

SAS functions are built-in tools that perform specific operations on data values, such as computations, transformations, and data cleaning. They help programmers manipulate character strings, numbers, dates, and other variables efficiently, making data analysis faster, cleaner, and more powerful.

Understand and master various conditional techniques in SAS using IF, IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSE OUTPUT. These statements are the foundation for decision-making logic in SAS and are widely used in data manipulation, validation, subsetting, and custom derivations in real-time industry projects.

Combining 2 or more datasets into one dataset via vertically /horizontally.

the RETAIN statement is used to accumulate values across iterations of a DATA step by preventing SAS from reinitializing specified variables to missing at the beginning of each new observation

Control statements and arrays in SAS provide powerful ways to:

• Automate repetitive tasks

• Process data conditionally

• Handle multiple variables efficiently

This guide covers essential techniques for DO loops, DO-WHILE/UNTIL, ARRAY processing, and more.

The Program Data Vector (PDV) is a critical concept in SAS that determines how data is processed during DATA step execution. It acts as a temporary storage area where SAS:

• Builds observations before writing to the output dataset

• Manages variables and their attributes

• Controls data flow during processing

A brief explantion on other statements which are not covered on above lesson. 

A powerful procedure used in reporting the summary tables and listing reportings.

Converting the columns to rows and rows to columns

Couple of procedures will be covered 

Delivering the sas output to different third party like HTML,RTF,PDF.and adding customizing techiques to make the report lokk and feel.