topic Re: By group in SAS Programming

By group

peiy5920 — Fri, 15 May 2020 19:27:59 GMT

Hi Everyone,

My data like this:

ID CD

1 3

1 4

1 5

2 6

2 7

2 8

How do I change data like this:

ID CD1 CD2 CD3

1 3 4 5

2 6 7 8

Thanks in Advance.

Re: By group

ed_sas_member — Fri, 15 May 2020 19:32:05 GMT

Hi,
You can use proc transpose:

Proc transpose data=have out=want (drop=_:) prefix=CD;
Var CD;
By ID;
Run;

Re: By group

Reeza — Fri, 15 May 2020 19:32:49 GMT

Transposing data tutorials:
Long to Wide:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/

This is called a transpose and you can use PROC TRANSPOSE.

If you want just a report, PROC FREQ or TABULATE will do it.

Re: By group

peiy5920 — Fri, 15 May 2020 19:41:48 GMT

Thank you for your link.

Re: By group

peiy5920 — Sat, 16 May 2020 01:26:31 GMT

Hi,

My data like this:

ID CD time treatment

1 3 1 2

1 4 2 2

1 5 3 2

2 6 1 4

2 7 2 4

2 8 3 4

How do I change data like this:

ID CD1 CD2 CD3

1 3 4 5

2 6 7 8

From your link, I wrote my code:

proc transpose data=AIDS out= Output (drop = _NAME_) prefix=CD_;
id time;
var CD;
by ID;
run;

If I add another variable treatment in the data, like this

ID CD1 CD2 CD3 treatment

1 3 4 5 2

2 6 7 8 4

What should I do? I appreciate your help.

Re: By group

Reeza — Sat, 16 May 2020 07:18:23 GMT

Add the variable to the BY statement or a COPY statement.

Re: By group

peiy5920 — Sat, 16 May 2020 14:58:18 GMT

Thanks a lot!