What is Base SAS?
The Basic SAS programming Concepts which includes Accessing, Exploring, Filtering, Preparing, Processing, Analyzing, and Transforming of Data and finally generating output in external file formats.
steps involved in this process:
- Creating New Data Sets using Data step.
- Accessing the data Through Libraries into SAS.
- Importing data into SAS environment using INFILE and PROC IMPORT.
- Exploring the Data using PROC PRINT, PROC FREQ, PROC MEANS and PROC UNIVARIATE.
- Filtering The data using WHERE Expression and Macro Variables.
- Formatting ,Sorting the Data and Removing duplicate rows using Formats and PROC SORT.
- Computing New Columns using Numeric, Character and other functions.
- Conditional processing of Data using IF-THEN,IF-THEN-ELSE, DO , DO-WHILE, DO-UNTIL loops.
- Analyzing and Reporting the Data using PROC FREQ ,PROC MEANS and PROC REPORT.
- Transforming the data using PROC TRANSPOSE.
- Exporting the results in differents Formats (Excel,RTF,PDF,CSV)using ODS(Output Delivery System).