topic Re: using id statement in proc traspose in SAS Procedures

using id statement in proc traspose

NoorulIyn — Thu, 23 Apr 2015 19:36:23 GMT

This was a question in a certification guide.Could someone explain this y id statement is declared 3 times ?

This question will ask you to provide a line of missing code. Given the following data set LABS(only first 10 lines shown):

What statement that completes the program to produce the desired output

Response:

	IDLABTEST;,IDLABTEST;,
	IDLABTEST;
	IDLABTEST;,IDLABTEST;,IDLABTEST

Re: using id statement in proc traspose

Reeza — Thu, 23 Apr 2015 19:56:07 GMT

Can you point a reference to the certification guide?

All of those look incorrect to me since they don't have a space after the word ID.

Re: using id statement in proc traspose

NoorulIyn — Thu, 23 Apr 2015 20:15:18 GMT

Unfortunately i dont have the link since i copied and closed.But is it possible to have 3 id statements in proc transpose

Re: using id statement in proc traspose

art297 — Thu, 23 Apr 2015 20:35:55 GMT

: Out of curiosity I did a google search for "idlabtest sas" and came across the following: http://wenku.baidu.com/view/b58a1605a8114431b90dd8a3.html

The problem wasn't multiple choice but, rather, fill in the blank.

However, what the site showed as the answer was obviously incorrect:

Answer: IDLABTEST;,IDLABTEST;,IDLABTEST

How they came up with that is a really good question!

Re: using id statement in proc traspose

Reeza — Thu, 23 Apr 2015 23:16:53 GMT

Problem with automating extractions.

I was initially going to say contact tech support, but then realized that the question/answer wasn't in a standard SAS format and figured it came from a site like this.

At any rate, the answer above is wrong. You get what you pay for in these cases :smileymischief: