BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ttp
Fluorite | Level 6 ttp
Fluorite | Level 6

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?)

 

 

1 ACCEPTED SOLUTION
4 REPLIES 4
ttp
Fluorite | Level 6 ttp
Fluorite | Level 6

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?)

ttp
Fluorite | Level 6 ttp
Fluorite | Level 6

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?)

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2316 views
  • 1 like
  • 2 in conversation