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 how to assign a library, upload datasets, and view descriptor and data portions with proc print and proc contents using hr data, including character and numeric data types.

Learn how to use the SAS label option in PROC PRINT to display spaced column headings like last name and annual salary, and compare it with the split option.

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.

Explore SAS data step programming to read SAS data sets and create variables, including calculating a total from first class and economy, using set and infile statements.

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.

Learn to select variables in SAS using drop and keep in a data step, dropping class one and class two to produce an output with total.

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.

Create cross tabular frequency reports with proc freq to analyze two variables, show salary distribution by job code, and summarize n, mean, std, min, max using proc means.

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.

Explore SAS analysis variables using the asterisk operator in table statements to compute mean or sum statistics for salary by location, preparing you for data visualization and part two programming.

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.