SAS Programming for beginners

Master the proc print procedure to create list reports, select variables with var, filter observations with where and comparison operators, and compute by-group sums and column totals.

Learn to use SAS system options to customize report appearance—control date display, line and page sizes, and page numbering—and apply system and user-defined formats in proc print, including dollar currency.

Learn to format sas data using numeric formats (width eight, two decimals), dollar formats, and comma separators, plus character formats; explore sas date formats such as mdy, date7., and date9.

Create user defined formats in SAS using proc format for character and numeric data, apply them in proc print, and control display of names and salaries.

Learn how to use the SAS output delivery system (ods) to generate HTML or PDF reports, set file paths, name outputs like emp.html or emp.pdf, and view results.

Create a SAS data set from a raw data file using column input, defining flight id, travel date, city, and class as numeric variables, then save permanent data set.

Convert non structured raw data to sas dates stored as days since 1960-01-01 using in format. Apply pointer control to extract flight id and related fields.

Learn how to rename a variable in SAS using proc datasets, modifying the data set mxd in a library, then use proc contents to verify the city became destination.

Import excel data into SAS Studio using the import wizard, create a work library data set from the Excel file, and run content procedure and proc print to inspect structure.

Learn how SAS compiles data step, initializes the program data vector, iterates observations to compute total from class one and class two, and formats travel date in the onboard dataset.

Explore how SAS functions perform arithmetic operations and compute sample statistics, handle missing values, and manipulate dates with date functions to extract year, quarter, month, and day of week.

Master conditional processing in SAS using if-then logic, do-end blocks, upcase for case sensitivity, and length to control string width, with revenue calculations from destination data.

Master subsetting rows in a SAS data step using subsetting if and delete statements to filter observations when total is greater than 175.

Learn how to create SAS date values from quoted strings using a trailing d, interpret ddmmmYYYY form, and apply date constants with comparison and logical operators to subset data.

Concatenate SAS data sets with the set statement to create a new data set, then merge by a common variable, by month, rename duplicates, and compute differences.

Explore merging two SAS data sets with a match merge by employee id, including sorting, using the in= option to show contributors, and handling missing flight numbers.

Explore generating summary reports in SAS by using proc freq, proc means, proc report, and proc tabulate to create frequency counts, descriptive statistics, and cross-tabulated tables with formatting.

Explore how the report procedure creates listing, summary, and cross-tab reports with subtotals and grand totals; compare it with proc print and learn about column and define options.

Learn to create visually appealing SAS charts with PROC GCHART, including bar and pie charts, using ODS HTML outputs, and apply options like quit, explode, and color fills.