Length statement before merge statement

KingstonCole — Tue, 07 Jan 2020 12:20:33 GMT

Hi everyone! Can someone help me with this question? I took a practice SAS exam a couple days ago and there was this question that is absolutely driving me insane. The question was about using a length statement before the merge statement. I have always thought that if you add the length statement before the merge then the length statement chooses the length of the column. However, I got the answer wrong because apparently SAS uses the first table in the merge statement to choose the length and not the length statement even though it was written before. I feel like I am missing something here. Can someone help?

Re: Length statement before merge statement

Kurt_Bremser — Tue, 07 Jan 2020 12:37:45 GMT

We've covered exactly this question quite recently (see https://communities.sas.com/t5/SAS-Programming/Length-statement-before-merge-statement/m-p/613827#M179330).

Please post the source of the practice exam ("practice exams" not provided by SAS are often unusable junk), the exact question and answer.

The correct answer to your question as posted is of course that the length statement takes precedence.

@KingstonCole wrote:

Hi everyone! Can someone help me with this question? I took a practice SAS exam a couple days ago and there was this question that is absolutely driving me insane. The question was about using a length statement before the merge statement. I have always thought that if you add the length statement before the merge then the length statement chooses the length of the column. However, I got the answer wrong because apparently SAS uses the first table in the merge statement to choose the length and not the length statement even though it was written before. I feel like I am missing something here. Can someone help?

topic Re: Length statement before merge statement in New SAS User

Length statement before merge statement

Re: Length statement before merge statement