How to transpose by and get one record per subject

RAVI2000 — Fri, 12 Nov 2021 22:26:38 GMT

Hello everyone,

how to obtain single record per subject?

I tried below code:

proc transpose data = have;
by param;
var aval;
id trta;
run;

Its giving me an error.

Error: ID value "T1" occurs twice in the same by group.

Error: ID value "T2" occurs twice in the same by group.

Error: ID value "T1" occurs twice in the same by group.

Error: ID value "T2" occurs twice in the same by group.

Error: All BY groups were bad.

Re: How to transpose by tmax t1 and tmax t2 and get one record per subject

PaigeMiller — Fri, 12 Nov 2021 21:49:34 GMT

Use

by subjid;