Advanced SAS Course by Solving Questions and Use Cases

Download two files, a flash file and picture file, which contain the same 100 questions for this course; open either to review all questions and check the video for explanations.

Explore how the macro evaluation function computes arithmetic in SAS macros, using percent signs for float calculations, and the evaluation (translation) function for expressions, with notes on data step behavior.

Explore macro do loop behavior in SAS, showing how local versus global macro variables affect loop indices and the final count output, including default argument handling and evaluation.

Use proc datasets to change the source dataset name and attributes for data management, including rename, modify, and alter statements.

Explore bufsize and bufno options in SAS data steps, explaining how buffer size affects memory and how the number of buffers speeds input and output operations for data sets.

Explore how to use the macro translation function to apply a data step date function and format to output the current date, demonstrating practical SAS macro techniques.

Master how to build a SAS macro function to export data with PROC EXPORT, resolving input and output parameters to create a CSV file from an internal source table.

Understand the %eval macro function and %do loop in SAS, including defining a macro and placing code inside it to compute four.

Define and resolve multiple macro variables in SAS by creating datasets A and B, using ampersand to assign values, filtering with where, and stacking A and B for final results.

Explore how to debug SAS macro programs by using an option that writes trace information to the source log window, revealing macro execution start, parameter values, each statement, and conditions.

Learn how an index in SAS data sets enables efficiently extracting a small subset of observations from a large dataset. The index requires unique values for efficient search.

Create a SAS data set index using modify, setting a unique index on the member ID field of the KLOP table in the library, and avoid using alter data set.

Learn to create and manage SAS table indexes using SQL, including create unique index on a field, with PROC SQL or PROC DATASETS modify and index statements.

Learn how to apply format and label options in PROC SQL to display income as a dollar value (dollar10.1) and assign a cosmetic label without changing the data.

Learn to delete rows from membership where the top three digits of the telephone number are not 'three seven eight' using substring in SAS PROC SQL.

this lecture demonstrates passing a macro variable into SAS SQL, showing that double quotes resolve the macro value, whereas single quotes do not, affecting the subset result.

Learn how to perform floating point arithmetic in SAS macros using %sysevalf and symput, then transfer the result from a data step to a global macro variable with call symput.

Master using a subquery in a where clause of proc sql to filter by the average age of all students, and select gender and id with valid sas syntax.

learn how to union two sas sql data sets with union or corresponding, where corresponding matches by name, not position, and the all option keeps duplicates.

Explore SAS SQL code that unions two datasets and then intersects to find records. Intersect matches by position, not by column name, yielding an empty result when first columns differ.

Learn to insert a record into a SAS data set with the insert into table values syntax, and compare using proc sql versus the data step for data manipulation.

Master how to pass and resolve string-like macro variables in SAS, using ampersand and dot notation in a proc print where clause to correctly extract the target records.

Merge the students and parents tables with a left join in proc sql, selecting all student attributes and the parent id, and explain why id and age may be missing.

Demonstrates using the symput function to move a data step variable into a macro variable, and printing the result with put while applying substring and compress.

Learn to use a SAS macro function and call execute to print the contents of three data sets—teachers, students, and parents—by dynamically invoking a macro per dataset.

Mask macro parameters in SAS by using code, quote, string, pquote, and bquote masking functions to pass lists like 1,2,3 as strings, avoiding misinterpretation of parameters.

Understand how the SQL keyword validate checks the query syntax without executing the expression, helping you validate complex SQL and avoid running lengthy queries.

Learn how the index name option in SAS data steps optimizes where statements by binding a created index to a column, speeding searches for specific values.

Learn how to remove a table from a SAS library using the drop table statement, and distinguish it from deleting records in SAS SQL.

Learn how to display the data structure and metadata of a sas data set in a library using describe table, describe view, or proc contents.

Save the gender value from the second record into a macro variable in SAS using a data step and call symput to transfer the value.

learn how to use the strip function in SAS to remove leading and trailing blanks in data steps, compare it with trim, and note its advantage for large data sets.

Learn cross joining in sas sql by combining a and b to form c with 12 rows and 2 columns, j from b overwriting j from a.

Learn how to create non-duplicated pair observations in SAS SQL by joining two datasets with a where clause, such as J < B2K, to avoid duplicates and enable correlation analysis.

Shows how a SAS macro uses a parameter s to perform inner, left, right, or full joins on tables a and b on the J column, producing a merged dataset.

SAS proc sql derives a new column am from max(amount) by item, adds m plus one, and filters with having m > 400; note calculated keyword for older versions.

Learn how proc sql options remove identical observations by comparing distinct and sort-based approaches. Deduplicate data using key fields like student name, gender, and age.

Use monotonic in sas proc sql to create a new id column with successive integers (one, two, three, four) and learn database alternatives with rule number and over functions.

Learn sound-alike query in SAS PROC SQL to search names or words with spelling variations in the where statement.

Identify the macro variable that holds the return code from a previously executed step in SAS. Learn how the status information from data steps and procedures signals successful execution.