Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAS A00-260 Exam - Topic 9 Question 101 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 101
Topic #: 9
[All A00-260 Questions]

Given the table below as a source table for the Transpose transformation in SAS Data Integration Studio:

In the Options tab in the Properties window for the Transpose transformation, if the columns are assigned as follows:

Select columns to transpose (VAR statement): Payment

Select a column for Output column names (ID statement): Month

Select columns whose values define groups of records to transpose (BY statement): Name

Which of the following tables is a possible resulting target table?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Noel
7 days ago
I'm a bit confused about how the values in the Payment column will be displayed after transposing. I hope I remember the correct format!
upvoted 0 times
...
Anglea
13 days ago
This question seems similar to one we did in our last mock exam. I feel like Option B might be the right choice, but I need to double-check the grouping logic.
upvoted 0 times
...
Silva
18 days ago
I think the ID statement is crucial for naming the output columns, but I can't recall how it interacts with the VAR statement.
upvoted 0 times
...
Viola
23 days ago
I remember we practiced transposing data in class, but I'm not sure how the BY statement affects the output.
upvoted 0 times
...

Save Cancel