SAS for Data Science

Explore creating and manipulating string values in SAS, measure string lengths, join_underscore_strings to combine strings, and view results through data, proc print, and output data.

Learn SAS string functions, especially substring and trim, with examples that extract substrings from specific positions, show end points, and trim by a given length.

Define SAS arrays to create a series of values and retrieve them, using a colors example, mix elements, and print results in the SAS interface with options to export.

Explore how SAS arithmetic operators—addition, subtraction, multiplication, division, and the exponential value—work on two data columns. See practical code examples and results in the SAS interface.

Explore how SAS do loop repeats a program under given conditions to accumulate values from 1 to 5, producing a final sum and a practical example.

This SAS data science lecture demonstrates the do while loop and the do loop, showing repetition until the condition is false, with an example that increments and prints values.

Explore the SAS do until loop that repeats a block of code until a condition becomes true, with hands-on demonstration showing how the loop stops when the condition is met.

Learn how SAS if statements support decision making by filtering employee data, such as salary, department, and joining date, and produce clear, printable outputs.

Explore how the SAS if then else statement segments employee salary data into high and low ranges, prints results, and exports outputs using department and salary details.

Learn to implement SAS if-then-else if statements to categorize salaries as below 600 (low), 600-700 (medium), and above 700 (high), producing a salary range in a data step.

Learn how the SAS if-then-delete statement filters data by a salary threshold, removing nonmatching records and producing an output data set of observations that meet the criteria.

Explore SAS mathematical functions by building a data set with five variables, applying inbuilt functions to compute max, min, median, random numbers, and sqrt, and view results with proc print.

Learn SAS date and time functions to calculate intervals between dates in years and months and to determine the day of the week in SAS studio.

Learn how SAS character functions manipulate string values, convert to upper or lower case, reverse letters, and extract specific words within a data step and print data.

Explore the SAS truncation function and its use in data processing to compute nearest, floor, and ceiling values. Compare how these functions affect rounding and output in practical SAS programs.

Learn how to use the SAS list input method to read raw data, define variables like employee ID, name, and department, and handle delimiter formats to produce correct output.

Explore the SAS name input method and how it differs from list input, showing how to align variables with data to produce a table of employee ID, name, and department.

Learn how SAS macros local variables work alongside global variables, define local names and types in the SAS environment, and print cars data set outputs like makes, types, and dates.

Explore how to define and call a SAS macro program, use percent macro, and generate outputs from the cars data set by selecting make and type.

Export SAS data to your local system using proc export, demonstrated with the built-in baseball dataset from SAS help.

Merge two SAS datasets by salary and department using a common key, employee id, then print the merged results to verify the combined data details.

Learn how to subset variables in SAS using drop and keep, selecting essential fields like employee name and department while excluding others such as employee ID and salary.

Explore SAS subsetting observations in SAS for data science to filter employees by salary conditions, define data and variables, and output results using proc print.

Learn how to sort data in SAS using PROC SORT, in ascending or descending order by salary and other variables, with by statements and output the sorted results.

Explore how SAS Studio uses structured query language (SQL) to create, read, update, and delete data across databases, by creating a temporary employees table and printing results.

Read the cars data set from SAS help with a sql-style query, selecting make, model, type, invoice, and horsepower, then apply a where clause.

Learn how to delete data in SAS with delete from and a salary-based condition, then verify results using proc print.

Explore the SAS output delivery system (ODS) and learn how to export analysis to Word, media, and other formats; download results for external reports and presentations.