
This Lesson is based on the introduction to Data Science and the usage of SAS as a tool for its applications.
Install the SAS university edition on Windows using VirtualBox by following prerequisites, importing the appliance, and launching SAS Studio in your browser via localhost.
Explore SAS variables, including character, numeric, and date types, and learn how to define, assign, and display them using a simple SAS data step and proc print in SAS Studio.
Learn how to create and manipulate string values in SAS, including measuring string lengths, joining strings with the join_strings function, and printing results in SAS studio.
Explore the sas character function fundamentals, converting string values with upcase and lowcase, reversing text, and extracting specific words using scan for practical data manipulation.
Create and manipulate SAS arrays by defining a series of values, assigning data, and performing element-wise operations like mixing A1 and A2, then view the resulting output.
Explore how SAS executes arithmetic operations—addition, subtraction, multiplication, division, and exponential value—on two data columns, with examples showing results.
Learn how to read raw data from the local file system into SAS Studio, upload the data, and read it with a SAS program using a file method.
Export data from SAS to the local file system using proc export, showing how to export the built-in SAS baseball dataset to CSV format while exploring libraries and folders.
Learn to merge two SAS datasets from local files by defining paths and data names, then use merge by employee id to produce and print combined salary and department data.
Learn to subset variables in SAS using drop and keep to select or drop fields. See an example with employee id, name, salary, and department.
Learn how to use the SAS proc sort procedure to sort data in ascending or descending order, by salary and other variables, and generate a sorted output.
Learn how SAS Studio uses sql to create tables, read, update, and delete data from databases, and manage data with proc sql and temporary data sets.
Learn to read data with SAS proc sql from a cars dataset in SAS help, selecting make, model, type, invoice, and horsepower, and refine results with a where clause.
Learn to create a temporary data set, define an employee table with name, salary, department, and commission, and update salaries by 1.25 with preserved commissions.
Master SAS delete operation using delete from to remove rows from a created table, applying salary-based conditions and reviewing results with proc print in the work library.
Learn to use the SAS output delivery system (ODS) to export analysis results to Word format and other formats, download, and share externally for reports and presentations.
Explore standard deviation in SAS studio with proc means on the cars1 data set, focusing on numerical variables like invoice, horsepower, length, and weight.
Explore the SAS frequency distribution concept and practice using proc freq to compute counts, percentages, and cumulative frequencies across variables like horsepower, make, type, and weight.
Learn to build histograms with proc univariate in SAS Studio, visualize horsepower data, customize axis labels, and interpret the distribution and normality statistics.
Explore creating SAS pie charts with proc template using the cars data from SAS help. Visualize make-by-make groupings (Audi, BMW) and customize category, labeling, and legends.
This Course is Designed for Beginners/Professionals to learn Data Visualization, Data Manipulation, Data Handling using SAS PROC procedures and SAS SQL, this learning process is going to give a great edge for the people who are working in the field of Data Science/Data Analysis/Data Management/Data Mining or wants to transform their career in any of these fields. SAS is an amazing tool to manage and work on complex data.