topic Proc transpose in SAS Programming

Proc transpose

v307086 — Thu, 01 Feb 2024 18:30:42 GMT

Hi all,
I want to know what if I don't use by statement in the proc statement and only use id and var statement, what will happen? Please help!

I have a code snippet with me.

If I use "by" statement in proc transpose (code snippet below). Then my output looks likes this

and If i don't include "by" statement, then my output looks like this(which is my desired output)-

So, I have confusion about when to use by statement and when not?

Thank you in advance.

Re: Proc transpose

PaigeMiller — Thu, 01 Feb 2024 18:36:16 GMT

So, I have confusion about when to use by statement and when not?

If you want output that looks like the first table, you use a BY statement. If you want output that looks like the second table, then you don't use a BY statement.

Re: Proc transpose

v307086 — Thu, 01 Feb 2024 18:38:35 GMT

Yes sir, But what's exactly the use of by statement here. and when to use to it and when not, how will i know?

Re: Proc transpose

PaigeMiller — Thu, 01 Feb 2024 18:47:34 GMT

A BY statement puts results from each level of the BY variable (1, 2, 3 or 4) on its own row. Without the BY statement, results for 1, 2, 3 and 4 are on the same row.