I have voluminous amounts of data in SPSS. (tens of thousands of subjects each with hundreds of variables) How can I map those data directly into Vensim without moving it to Excel first? The dataset is too large for Excel.
Also, I've created models with equations based on arbitrary numbers. I'd like to use the actual data so the model matches the data. How can I do this?
PattiCat
Modeling actual data
-
Administrator
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
-
bob@vensim.com
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
With that quantity of data the most efficient way to transfer it will be to the .dat format file that vensim uses, possibly along with a .cin file which is used for constants or initial conditions. Chapter 16 of the users guide covers using data. If you want to have a subscript for each subject in the data set, and the subjects are numbered, the convention is to create a subscript element with the subject number as in
subject : s12743,s21877...
unless these numbers are sequential it is also usually easiest to create a subscript definition file programmatic ally, and then paste that into Vensim. 10,000 is too many to do at once, so you will need to break it up into about 10 groups of 1000 then combing them as in
sgroup1 : s1,s2
sgroup2: s3,s4
subject : sgroup1,sgroup2
subject : s12743,s21877...
unless these numbers are sequential it is also usually easiest to create a subscript definition file programmatic ally, and then paste that into Vensim. 10,000 is too many to do at once, so you will need to break it up into about 10 groups of 1000 then combing them as in
sgroup1 : s1,s2
sgroup2: s3,s4
subject : sgroup1,sgroup2
-
bob@vensim.com
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm