Aggregate Help

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

zxdrew
Posts: 1
Joined: Wed Jul 13, 2016 8:31 pm

Aggregate Help

Postby zxdrew » Wed Jul 13, 2016 8:37 pm

I'm trying to modify a code that's been around for awhile in my office. I keep getting hung up by the Mitigate_1 variable at the bottom. Is there anything that seems out of place. There are 1600 lines above the save outfile that don't seem to be the issue. It runs fine until the mitigate_1 variable. Any help would be appreciated.

SAVE OUTFILE 'P:\Work\NF\FY14 Recoupment Code ReRun\Temp\TEMPORARY FILE.SAV'.

AGGREGATE
/ OUTFILE = 'P:\Work\NF\FY14 Recoupment Code ReRun\Temp\AGGR.SAV'
/ BREAK R501
/ R606_1 = SUM(R606)
/ R609_1 = SUM(R609)
[100 rows with variable name values moving up by 1 excluded]
/ FFS2_1 = SUM(FFS2)
/ FFS3_1 = SUM(FFS3)
/ FFSPR_1 = SUM(FFSPR)
/ FFS_1 = SUM(FFS)
/ BOX_A_1 = SUM(BOX_A)
/ BOX_E_1 = SUM(BOX_E)
/ BOX_P_1 = MEAN(BOX_P)
/ BOX_Q_1 = MEAN(BOX_Q)
/ BOX_K_1 = MIN(BOX_K)
/ BOX_L_1 = MIN(BOX_L)
/ DIET_1 = SUM(DIET)
/ FAC_1 = SUM(FAC)
/ DCCOST_1 = SUM(DCCOST)
/ DCREV1_1 = SUM(DCREV1)
/ DCREV2_1 = SUM(DCREV2)
/ DCREV3_1 = SUM(DCREV3)
/ POTDAY_1 = SUM(POTDAYS)
/ MITIGATE_1 = PGT(MITIGATE 0)
/N_BREAK = N.

SAVE OUTFILE 'P:\Work\NF\FY14 Recoupment Code ReRun\Temp\AGGR.SAV'.

Who is online

Users browsing this forum: No registered users and 2 guests

cron