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.
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.
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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: