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?)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.