The following question will ask you to provide a line of missing code.
The following program is submitted to output observations from data set ONE that have more than
one record per patient
proc sort data=one out=two;
by subjid;
run;
data two;
set two;
<insert code here>
if (first.subjid ne 1 or last.subjid ne 1)then output;
run;
In the space below, enter the line of code that will correctly complete the program (Case is
ignored. Do not add leading or trailing spaces to your answer.).
Ans: BYSUBJID; (should be the answer. But in testing engines for SAS certification site, it gives you the wrong answer when BYSUBJID is given. The correct answer says BYSUBJID;BYSUBJID;
What is the reason?)
That must be some kind of typo. More than one by statement in a data step results in a syntax ERROR (221-185).
Yes That is the right answer.
But the testing dumps says its a wrong answer.
It shows correct answer is:
BYSUBJID;
BYSUBJID;
I am not sure weather this format is followed in the real certification exam also.
there is an another example:
Which CDISC filename contains the following items?
• Variable attributes
• Controlled terminology
• Computational methods
Enter your answer in the space below (Case is ignored. Do not add leading or trailing spaces to
your answer.).
Answer: DEFINE.XML,DEFINE.PDF,DEFINE (are we supposed to mention all the 3 for the answer?)
That must be some kind of typo. More than one by statement in a data step results in a syntax ERROR (221-185).
Which CDISC filename contains the following items?
• Variable attributes
• Controlled terminology
• Computational methods
Enter your answer in the space below (Case is ignored. Do not add leading or trailing spaces to
your answer.).
Answer: DEFINE.XML,DEFINE.PDF,DEFINE (are we supposed to mention all the 3 for the answer?)
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.