How to transpose by and get one record per subject

[RAVI2000]

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 "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: ID value "T2" occurs twice in the same by group.

Error: All BY groups were bad.

[PaigeMiller · Accepted solution]

Use

by subjid;