Hello,
I hope you could help me to solve the following problem:
We're using SPSS to select participants for a weekly survey. SPSS gets all the data from our SQL-databases, does some calculation and finally merges all data in one SPSS file and create an Excel file. In this Excel file I select/mark the participants for the survey. My target is to automatize this selection.
For the selection I have 5 variables to deal with: sex, age-group, education, abo, frequency reading. For each variable I knew the distribution on each value. An example: For a survey with 1000 participants I need in the variable sex: 57% male and 43% female, in the variable age-group: 15% (18-29yrs) / 35% (30-49yrs) / 35% (50-69yrs) / 15% (70+yrs)...
All these variables are independent from each other: There is no "I need 5.7% male between 18-29 years".
My question is: Can I do this selection in SPSS? Or is it better to write a VBA macro?
Thanks for your help/hints/opinions.
Kind regards
Tobias
Locked
