Learn SAS: Manage Data (Part 3)
I am currently enrolled in WGU's MSDA program (Master of Science in Data Analytics) and am working towards the SAS Base Programmer certification. I wanted to create a series of videos teaching what I've learned to help me reinforce that knowledge and hopefully help you learn a little more quickly.
This video covers the following:
Use SAS functions to convert character data to numeric and vice versa.
• Explain the automatic conversion that SAS uses to convert values between data types.
• Use the INPUT function to explicitly convert character data values to numeric values.
• Use the PUT function to explicitly convert numeric data values to character values.
Process data using DO LOOPS.
• Explain how iterative DO loops function.
• Use DO loops to eliminate redundant code and to perform repetitive calculations.
• Use conditional DO loops.
• Use nested DO loops.
Restructure SAS data sets with PROC TRANSPOSE.
• Select variables to transpose with the VAR statement.
• Rename transposed variables with the ID statement.
• Process data within groups using the BY statement.
• Use PROC TRANSPOSE options (OUT=, PREFIX= and NAME=).
Use macro variables to simplify program maintenance.
• Create macro variables with the %LET statement
• Use macro variables within SAS programs.