I have three variables: income (with 5 possible values); state (with 50 possible values), and age group (with 7 possible values).

5x50x7 = 1,750 so this means there are 1,750 possible combinations of these variables.

I need to create a list of all 1,750 of these possible combinations. For example:

incomegroup #1 "<$10,000/year", state #1 ("Alabama"), agegroup #1 (age 0-9)

incomegroup #1 "<$10,000/year", state #1 ("Alabama"), agegroup #2 (age 10-19)

incomegroup #1 "<$10,000/year", state #1 ("Alabama"), agegroup #3 (age 20-29)

incomegroup #1 "<$10,000/year", state #1 ("Alabama"), agegroup #4 (age 30-39)

incomegroup #1 "<$10,000/year", state #1 ("Alabama"), agegroup #5 (age 40 or older)

incomegroup #1 "<$10,000/year", state #1 ("Alaska"), agegroup #1 (age 0-9)

incomegroup #1 "<$10,000/year", state #1 ("Alaska"), agegroup #2 (age 10-19)

incomegroup #1 "<$10,000/year", state #1 ("Alaska"), agegroup #3 (age 20-29)

incomegroup #1 "<$10,000/year", state #1 ("Alaska"), agegroup #4 (age 30-39)

incomegroup #1 "<$10,000/year", state #1 ("Alaska"), agegroup #5 (age 40 or older)

incomegroup #1 "<$10,000/year", state #1 ("Arizona"), agegroup #1 (age 0-9)

incomegroup #1 "<$10,000/year", state #1 ("Arizona"), agegroup #2 (age 10-19)

incomegroup #1 "<$10,000/year", state #1 ("Arizona"), agegroup #3 (age 20-29)

incomegroup #1 "<$10,000/year", state #1 ("Arizona"), agegroup #4 (age 30-39)

etc etc etc until the last (#1750) possible combination.

Is there a way to do this using a macro in SPSS? A macro of some sort with looping.