topic Proc transposed help in ODS and Base Reporting

Proc transposed help

Gil_ — Wed, 06 Feb 2019 20:08:33 GMT

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

Re: Proc transposed help

novinosrin — Wed, 06 Feb 2019 20:10:25 GMT

what do you want as output?

Re: Proc transposed help

Gil_ — Wed, 06 Feb 2019 20:50:26 GMT

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

Re: Proc transposed help

PGStats — Thu, 07 Feb 2019 04:19:50 GMT

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

Re: Proc transposed help

Gil_ — Thu, 07 Feb 2019 04:41:35 GMT

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