- Guaranteed To Run
- All Courses
- ALL MICROSOFT COURSES
- WORKPLACE WELLNESS PROGRAMS
- SFC-ELIGIBLE COURSES
- SG ENABLE (TT-CDC Grant)
- About Us
- Insights
- Rewards Account Login
Experienced SAS macro programmers who want to learn advanced techniques
Learn how to
• Create hierarchical, menu-driven macro applications
• Exploit stored compiled and autocall macro facilities
• Exploit macro quoting functions
• Generate data-driven macro calls
• Perform table lookup operations
• Apply SAS or user-defined formats to macro variables
• Automatically convert data set variables to macro variables
• Search for all CSV, Excel, or Microsoft Access files in a directory and all subdirectories and automatically import each file, worksheet, or table into a SAS data set
• Search for all SAS programs in a directory and all subdirectories and automatically submit every program
• Exploit SAS I/O and external file functions
• Create your own macro functions
• Create macro functions that return the number of observations in a data set or a subset of a data set
• Create a macro function that validates whether a selected variable exists in a selected data set and returns the variable’s type
• Create custom windows and menus that interactively gather and validate user-supplied parameter values.
Module 1: Macro Storage
Module 2: Protecting Special Characters
Module 3: Reading SAS Data
Module 4: Reading External Data
Module 5: Table Lookup Techniques
Module 6: Validating User Input
Avantus Training began from the need to develop a skilled pool of technology talent for the community; keeping abreast of the constantly evolving IT landscape. Since, we have been recognized for our ability to be a life-long training partner and mentor for every individual.