PPD Interview Questions, Process, and Tips

Creating and sorting multiple visits in SAS, flagging highest and lowest age

• Use PROC SORT to sort the data by visit type (Unscheduled vs Planned) and age

• Use PROC RANK to flag the highest and lowest age

• Consider using IF-THEN statements to identify and flag the highest and lowest age

RELREC stands for Relative Record Number. It is a unique identifier assigned to each record in a dataset.

• RELREC is used to uniquely identify each record in a dataset.

• It is typically created by assigning a sequential number to each record as it is added to the dataset.

• For example, the first record added to a dataset would have a RELREC of 1, the second record would have a RELREC of 2, and so on.

Merge SUPPPQUAL with parent domain by using common identifiers and joining the datasets.

• Identify common identifiers between SUPPPQUAL and parent domain

• Use a join operation to merge the datasets based on the common identifiers

• Ensure data integrity and consistency after merging