Hi All.

I am trying to make a recursive count in a column so that effectively each row is numbered. Any suggestions?

Column
1
2
3
4
5
6 (and so on)

Hi Max,
you can use RANKED function to display count in the column.

TABLE FILE CAR
PRINT CAR MODEL 
RANKED BY HIGHEST 5 RETAIL_COST
END

  
TABLE FILE CAR
LIST
    RETAIL_COST
    DEALER_COST
 BY COUNTRY
 BY CAR
END
-EXIT

OR

  
TABLE FILE CAR
SUM
    RETAIL_COST
    DEALER_COST
       COMPUTE CNTR/I3 = CNTR + 1; NOPRINT
 BY TOTAL CNTR
 BY COUNTRY
 BY CAR
END
-EXIT

Simply as...

Count up to 10 cars:

DEFINE FILE CAR
ID /I5 = ID + 1;
END
TABLE FILE CAR
BY ID
BY CAR
END

Count up to 18 models:

DEFINE FILE CAR
ID /I5 = ID + 1;
END
TABLE FILE CAR
BY ID
BY MODEL
END

Or to have a count reset on BY:

TABLE FILE CAR
PRINT COMPUTE ID /I5 = IF COUNTRY EQ LAST COUNTRY THEN ID + 1 ELSE 1;
      MODEL
BY COUNTRY
END

This message has been edited. Last edited by: MartinY,

Thanks for the replies guys - I got it!