Proc transposed help

[Gil_]

I have a proc transpose
Proc sort = combine;
By number;
Run;
Proc transpose data =combine out =combine2 ;
By date number cost ;
Var balance;
Id service type;
Run

I get error message the id value occurs twice in the by group

My table looks
Number. Date. Balance. Cost. Service type
123. 01/04/19. 120. 23A. VENDOR
123. 01/05/19. 133. 23A. VENDOR
234. 02/02/19. 150. 24B. CUSTOMERS
245. 02/06/19. 210. 25B. CUSTOMERS
I

[novinosrin]

what do you want as output?

[Gil_]

Number date Balance. Vendor. CUSTOMERS
123. 01/04/19 120:: vendor
123. 01/05/19 133. Vendor
234. 02/02/19. 150. Customer
245. 02/06/19. 210. Customer

[PGStats · Accepted solution]

Your BY variables should be the same in the sort and transpose step.

[Gil_]

Thanks pgstats. I did and i get same.
Proc sort = combine;
By number;
Run;
I even removed col not needed just kept
Number balance. Service type
Still get error message