need help with something like a pivot

Unstefan — Wed, 17 Oct 2018 11:42:37 GMT

Hello,

Need some help with the following situation :

- need to cumulate the amount for variable nocont

but in SAS

I try with summary but doesn't work

nocont	tip	date	amount
A	x	17-Oct-18	2.00
B	y	17-Oct-18	3.00
C	z	17-Oct-18	4.00
A	x	17-Oct-18	100.00
C	z	17-Oct-18	1234.24
C	z	17-Oct-18	34.00
B	y	17-Oct-18	279.00
D	g	17-Oct-18	45.00
E	j	17-Oct-18	38.00
F	k	17-Oct-18	339.00

Re: need help with something like a pivot

RW9 — Wed, 17 Oct 2018 12:11:44 GMT

Post test data in the form of a datastep. Show what the output should be from that datastep. Explain (with log if needed) what "doesn't work". From what you post:

proc summary data=have;
  class nocont;
  output out=want sum()=;
run;

Should work.

topic Re: need help with something like a pivot in ODS and Base Reporting

need help with something like a pivot

Re: need help with something like a pivot