topic Re: Data Step By Processing in SAS Programming

Data Step By Processing

pchappus — Mon, 29 Oct 2018 20:43:52 GMT

I don't understand why this isn't working. I want to sum up all the Qtrly_Paids for each Paid_Qtr. I know how to do this in proc sql but can't figure out why this isn't working in a data step.

DATA RDS_Final;
	RETAIN PAID_QTR QTR_Paids;
	SET work.RDS_Qtr_Pds(KEEP=Paid_Qtr Qtr_Paids);
	
	FORMAT 
		Pd_Clm_From_Rds COMMA20.;
	
	BY Paid_Qtr;
	IF first.Paid_Qtr THEN Pd_Clm_From_Rds = 0;
	Pd_Clm_From_Rds + Qtr_Paids;
	
	DROP Qtr_Paids;
RUN;

Re: Data Step By Processing

novinosrin — Mon, 29 Oct 2018 20:47:00 GMT

log message plz

Re: Data Step By Processing

Astounding — Mon, 29 Oct 2018 20:47:27 GMT

You got most of the way there.

Your result includes all the original observations, with the cumulative total so far.

To subset and get only the final totals, add this statement at the end of the DATA step:

if last.Paid_Qtr;

Re: Data Step By Processing

pchappus — Mon, 29 Oct 2018 20:51:09 GMT

I really need to look into first. last. and by processing more...

It seems like a simple concept that I'm missing.