SPSS Statistics

Expand all | Collapse all

Create Simulation Data Error Message

  • 1.  Create Simulation Data Error Message

    Posted Fri September 10, 2021 10:10 AM
    Hi, I'm new to the SPSS Simulation Builder. Unfortunately when I run a simple model based entirely in the GUI point and click dialog, or, if I run my own syntax I keep getting the same error message. Could someone point me to a resource to resolve this? Or perhaps help explain why I'm getting the error message? Thanks! Message below:

    WARNING
    The procedure cannot access a file with the given file specification: simplan_131746 for keyword FILE of subcommand PLAN. The file specification is either syntactically invalid, specifies an invalid drive or directory, specifies a protected directory, specifies a protected file, or specifies a non-sharable file.
    Execution of this command stops.


    ------------------------------
    Matthew Monnot
    ------------------------------


  • 2.  RE: Create Simulation Data Error Message

    Posted Fri September 10, 2021 10:13 AM
    Hi. It looks like SIMPLAN created a plan file but SIMRUN can't find it for some reason. Can you post the syntax for both so I can see it, please?

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 3.  RE: Create Simulation Data Error Message

    Posted 20 days ago
    Hi Rick, Please see below:



    *Create simulation plan.
    FILE HANDLE simplan_131746 /NAME='C:\Users\Matt's
    Computer\AppData\Local\IBM\SPSS\Statistics\27\SimulationPlan_1.splan'.
    SIMPLAN CREATE
    /CONTINGENCY MULTIWAY=NO
    /SIMINPUT INPUT=NumberManagers(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=POISSON(MEAN=1.18 ) MAXVAL=8.0
    /SIMINPUT INPUT=StategicBatRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=34.45 STDDEV=12.56 ) MINVAL=20.0 MAXVAL=119.0
    /SIMINPUT INPUT=StategicPitchRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=0 STDDEV=.74 ) MINVAL=-3.16 MAXVAL=3.79
    /SIMINPUT INPUT=StrategicBat(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL (MEAN=0.01 STDDEV=0.80) MINVAL=-3.68 MAXVAL=3.58
    /SIMINPUT INPUT=SupportBat(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL (MEAN=0.00 STDDEV=0.37) MINVAL=-1.77 MAXVAL=2.68
    /SIMINPUT INPUT=StrategicBatRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=64683.90 STDDEV=28121.40 ) MINVAL=10609.0 MAXVAL=188853.0
    /SIMINPUT INPUT=StrategicFieldRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=.01 STDDEV=.75 ) MINVAL=-3.07 MAXVAL=3.2
    /SIMINPUT INPUT=StrategicFieldRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=68360.59 STDDEV=30605.04 ) MINVAL=10395.0 MAXVAL=1566333.0
    /SIMINPUT INPUT=StrategicFieldRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=36.26 STDDEV=15.50 ) MINVAL=20.0 MAXVAL=146.0
    /SIMINPUT INPUT=StrategicPitchOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=31.89 STDDEV=10.86 ) MINVAL=20.0 MAXVAL=99.0
    /SIMINPUT INPUT=StrategicPitchRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=64911.97 STDDEV=29730.16 ) MINVAL=13002.0 MAXVAL=20737.0
    /SIMINPUT INPUT=SupportBatRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=199987.40 STDDEV=83028.27 ) MINVAL=19683.0 MAXVAL=572825.0
    /SIMINPUT INPUT=SupportBatRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=306.18 STDDEV=136.77 ) MINVAL=34.0 MAXVAL=2176.0
    /SIMINPUT INPUT=SupportFieldRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=4855.60 STDDEV=5236.70 ) MINVAL=200.0 MAXVAL=48380.0
    /SIMINPUT INPUT=SupportFieldRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=474310.30 STDDEV=246330.30 ) MINVAL=52317.0 MAXVAL=1566333.0
    /SIMINPUT INPUT=SupportFieldRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=4855.60 STDDEV=5236.70 ) MINVAL=200.0 MAXVAL=48380.0
    /SIMINPUT INPUT=SupportPitchOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=191.44 STDDEV=154.57 ) MINVAL=0.0 MAXVAL=1230.0
    /SIMINPUT INPUT=SupportPitchRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=.00 STDDEV=.62 ) MINVAL=-6.35 MAXVAL=5.55
    /SIMINPUT INPUT=SupportPitchRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=142846.40 STDDEV=98412.04 ) MINVAL=2057.0 MAXVAL=592565.0
    /SIMINPUT INPUT=WinningPercentage(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
    DISTRIBUTION=NORMAL(MEAN=.5 STDDEV=.08 ) MINVAL=0.23 MAXVAL=0.75
    /CORRELATIONS VARORDER= WinningPercentage StrategicPitchRole SupportPitchRole StrategicBat
    SupportBat StrategicFieldRole SupportFieldRole StrategicPitchOrg SupportPitchOrg SupportBatRoleOrg
    SupportBatRoleOrg StrategicFieldRoleOrg SupportFieldRoleOrg StrategicPitchRoleComp SupportPitchRoleComp
    StrategicBatRoleComp SupportBatRoleComp StrategicFieldRoleComp SupportFieldRoleComp
    CORRMATRIX=
    1.000 ;
    0.111 , 1.000 ;
    ?0.004 , ?0.159 , 1.000 ;
    0.144 , 0.072 , 0.025 , 1.000 ;
    0.073 , 0.027 , 0.026 , ?0.230 , 1.000 ;
    0.139 , 0.053 , 0.035 , 0.534 , 0.091 , 1.000 ;
    0.083 , 0.031 , 0.022 , 0.228 , 0.544 , 0.059 , 1.000 ;
    ?0.197 , 0.005 , 0.030 , ?0.029 , ?0.005 , ?0.021 , 0.020 , 1.000 ;
    0.307 , 0.135 , ?0.080 , 0.017 , 0.001 , 0.020 , 0.010 , ?0.026 , 1.000 ;
    ?0.139 , ?0.063 , ?0.016 , ?0.001 , ?0.015 , ?0.013 , ?0.020 , 0.011 , ?0.256 , 1.000 ;
    0.312 , 0.030 , ?0.012 , 0.186 , ?0.085 , 0.081 , 0.038 , ?0.021 , 0.225 , ?0.134 , 1.000 ;
    ?0.140 , ?0.003 , 0.000 , 0.002 , ?0.089 , ?0.058 , ?0.081 , 0.076 , ?0.036 , 0.254 , ?0.055 , 1.000 ;
    0.334 , 0.013 , 0.012 , 0.078 , ?0.016 , 0.132 , ?0.022 , ?0.032 , 0.225 , ?0.104 , 0.552 , ?0.047 , 1.000 ;
    ?0.029 , ?0.014 , 0.002 , ?0.004 , ?0.005 , 0.001 , ?0.017 , 0.027 , ?0.074 , 0.293 , ?0.006 , 0.254 , 0.035 , 1.000 ;
    0.301 , 0.100 , ?0.034 , 0.021 , ?0.004 , 0.017 , ?0.009 , ?0.019 , 0.329 , 0.240 , 0.151 , 0.157 , 0.203 , 0.245 , 1.000 ;
    0.001 , ?0.006 , ?0.019 , 0.023 , 0.000 , 0.013 , ?0.011 , ?0.009 , ?0.196 , 0.865 , ?0.090 , 0.247 , ?0.062 , 0.358 , 0.397 , 1.000 ;
    0.277 , 0.019 , ?0.020 , 0.112 , ?0.074 , 0.028 , 0.004 , ?0.026 , 0.085 , 0.264 , 0.432 , 0.112 , 0.301 , 0.222 , 0.469 , 0.407 , 1.000 ;
    0.021 , ?0.011 , ?0.001 , 0.020 , ?0.041 , ?0.018 , ?0.045 , 0.033 , ?0.081 , 0.539 , ?0.048 , 0.620 , ?0.012 , 0.402 , 0.439 , 0.671 , 0.385 , 1.000 ;
    0.267 , 0.002 , ?0.008 , 0.042 , 0.007 , 0.095 , ?0.009 , ?0.029 , 0.063 , 0.290 , 0.255 , 0.092 , 0.464 , 0.205 , 0.469 , 0.429 , 0.726 , 0.409 , 1.000 ;
    0.042 , 0.000 , ?0.002 , 0.005 , ?0.009 , ?0.005 , ?0.010 , 0.021 , ?0.103 , 0.537 , ?0.029 , 0.370 , 0.016 , 0.661 , 0.484 , 0.692 , 0.476 , 0.815 , 0.465 , 1.000
    LOCK=NO
    /AUTOFIT NCASES=ALL FIT=AD BINS=100
    /STOPCRITERIA MAXCASES=100000
    /MISSING CLASSMISSING=EXCLUDE
    /PLAN FILE=simplan_131746 DISPLAY=YES.
    *Run simulation plan.
    DATASET DECLARE MoneyBall.
    SIMRUN
    /PLAN FILE=simplan_131746
    /CRITERIA REPRESULTS=TRUE SEED=629111597
    /PRINT ASSOCIATIONS=YES DESCRIPTIVES=YES PERCENTILES=NO
    /OUTFILE FILE=MoneyBall.

    ------------------------------
    Matthew Monnot
    ------------------------------



  • 4.  RE: Create Simulation Data Error Message

    Posted 20 days ago
    1. I assume the question marks I see are actually negative signs for correlations.)

    2. As I look at the VARORDER...
      VARORDER= WinningPercentage StrategicPitchRole SupportPitchRole StrategicBat
      SupportBat StrategicFieldRole SupportFieldRole StrategicPitchOrg SupportPitchOrg SupportBatRoleOrg
      SupportBatRoleOrg StrategicFieldRoleOrg SupportFieldRoleOrg StrategicPitchRoleComp SupportPitchRoleComp
      StrategicBatRoleComp SupportBatRoleComp StrategicFieldRoleComp SupportFieldRoleComp

      I see a few errors (typos):
      -- SupportBatRoleOrg appears twice
      -- StategicBatRoleOrg <> StrategicBatRoleOrg in VARORDER
      -- StategicPitchRole <> StrategicPitchRole in VARORDER

    I have to keep digging because I think there is more going on here.


    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 5.  RE: Create Simulation Data Error Message

    Posted 20 days ago
    Edited by Rick Marcantonio 20 days ago
    One of my colleagues started eliminating some of the MIN/MAX restrictions and found this to work:

    DATASET CLOSE ALL.
    NEW FILE.
    FILE HANDLE simplan_131746 /NAME='/Users/rick/tmp/test.splan'.
    SIMPLAN CREATE
     /CONTINGENCY MULTIWAY=NO
     /SIMINPUT INPUT=NumberManagers(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=POISSON(MEAN=1.18 ) MAXVAL=8.0
     /SIMINPUT INPUT=StrategicBatRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=34.45 STDDEV=12.56 )
     /SIMINPUT INPUT=StrategicPitchRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=0 STDDEV=.74 )
     /SIMINPUT INPUT=StrategicBat(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL (MEAN=0.01 STDDEV=0.80)
     /SIMINPUT INPUT=SupportBat(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL (MEAN=0.00 STDDEV=0.37)
     /SIMINPUT INPUT=StrategicBatRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=64683.90 STDDEV=28121.40 )
     /SIMINPUT INPUT=StrategicFieldRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=.01 STDDEV=.75 )
     /SIMINPUT INPUT=StrategicFieldRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=68360.59 STDDEV=30605.04 )
     /SIMINPUT INPUT=StrategicFieldRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=36.26 STDDEV=15.50 )
     /SIMINPUT INPUT=StrategicPitchOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=31.89 STDDEV=10.86 )
     /SIMINPUT INPUT=StrategicPitchRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=64911.97 STDDEV=29730.16 ) MINVAL=13002.0 MAXVAL=20737.0
     /SIMINPUT INPUT=SupportBatRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=199987.40 STDDEV=83028.27 ) MINVAL=19683.0 MAXVAL=572825.0
     /SIMINPUT INPUT=SupportBatRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=306.18 STDDEV=136.77 ) MINVAL=34.0 MAXVAL=2176.0
     /SIMINPUT INPUT=SupportFieldRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=4855.60 STDDEV=5236.70 ) MINVAL=200.0 MAXVAL=48380.0
     /SIMINPUT INPUT=SupportFieldRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=474310.30 STDDEV=246330.30 ) MINVAL=52317.0 MAXVAL=1566333.0
     /SIMINPUT INPUT=SupportFieldRoleOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=4855.60 STDDEV=5236.70 ) MINVAL=200.0 MAXVAL=48380.0
     /SIMINPUT INPUT=SupportPitchOrg(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=191.44 STDDEV=154.57 ) MINVAL=0.0 MAXVAL=1230.0
     /SIMINPUT INPUT=SupportPitchRole(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=.00 STDDEV=.62 ) MINVAL=-6.35 MAXVAL=5.55
     /SIMINPUT INPUT=SupportPitchRoleComp(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=142846.40 STDDEV=98412.04 ) MINVAL=2057.0 MAXVAL=592565.0
     /SIMINPUT INPUT=WinningPercentage(FORMAT=F,2) OUTPUT=YES TYPE=MANUAL(LOCK=NO)
     DISTRIBUTION=NORMAL(MEAN=.5 STDDEV=.08 ) MINVAL=0.23 MAXVAL=0.75
     /CORRELATIONS VARORDER= NumberManagers WinningPercentage StrategicPitchRole SupportPitchRole StrategicBat
      SupportBat StrategicFieldRole SupportFieldRole StrategicPitchOrg SupportPitchOrg StrategicBatRoleOrg
      SupportBatRoleOrg StrategicFieldRoleOrg SupportFieldRoleOrg StrategicPitchRoleComp SupportPitchRoleComp
      StrategicBatRoleComp SupportBatRoleComp StrategicFieldRoleComp SupportFieldRoleComp
      CORRMATRIX=
    1.000 ;
    0.111, 1.000 ;
    -0.004, -0.159, 1.000 ;
    0.144, 0.072, 0.025, 1.000 ;
    0.073, 0.027, 0.026, -0.230, 1.000 ;
    0.139, 0.053, 0.035, 0.534, 0.091, 1.000 ;
    0.083, 0.031, 0.022, 0.228, 0.544, 0.059, 1.000 ;
    -0.197, 0.005, 0.030, -0.029, -0.005, -0.021, 0.020, 1.000 ;
    0.307, 0.135, -0.080, 0.017, 0.001, 0.020, 0.010, -0.026, 1.000 ;
    -0.139, -0.063, -0.016, -0.001, -0.015, -0.013, -0.020, 0.011, -0.256, 1.000 ;
    0.312, 0.030, -0.012, 0.186, -0.085, 0.081, 0.038, -0.021, 0.225, -0.134, 1.000 ;
    -0.140, -0.003, 0.000, 0.002, -0.089, -0.058, -0.081, 0.076, -0.036, 0.254, -0.055, 1.000 ;
    0.334, 0.013, 0.012, 0.078, -0.016, 0.132, -0.022, -0.032, 0.225, -0.104, 0.552, -0.047, 1.000 ;
    -0.029, -0.014, 0.002, -0.004, -0.005, 0.001, -0.017, 0.027, -0.074, 0.293, -0.006, 0.254, 0.035, 1.000 ;
    0.301, 0.100, -0.034, 0.021, -0.004, 0.017, -0.009, -0.019, 0.329, 0.240, 0.151, 0.157, 0.203, 0.245, 1.000 ;
    0.001, -0.006, -0.019, 0.023, 0.000, 0.013, -0.011, -0.009, -0.196, 0.865, -0.090, 0.247, -0.062, 0.358, 0.397, 1.000 ;
    0.277, 0.019, -0.020, 0.112, -0.074, 0.028, 0.004, -0.026, 0.085, 0.264, 0.432, 0.112, 0.301, 0.222, 0.469, 0.407, 1.000 ;
    0.021, -0.011, -0.001, 0.020, -0.041, -0.018, -0.045, 0.033, -0.081, 0.539, -0.048, 0.620, -0.012, 0.402, 0.439, 0.671, 0.385, 1.000 ;
    0.267, 0.002, -0.008, 0.042, 0.007, 0.095, -0.009, -0.029, 0.063, 0.290, 0.255, 0.092, 0.464, 0.205, 0.469, 0.429, 0.726, 0.409, 1.000 ;
    0.042, 0.000, -0.002, 0.005, -0.009, -0.005, -0.010, 0.021, -0.103, 0.537, -0.029, 0.370, 0.016, 0.661, 0.484, 0.692, 0.476, 0.815, 0.465, 1.000
     LOCK=NO
     /AUTOFIT NCASES=ALL FIT=AD BINS=100
     /STOPCRITERIA MAXCASES=100000
     /MISSING CLASSMISSING=EXCLUDE
     /PLAN FILE=simplan_131746 DISPLAY=YES.
    *Run simulation plan.
    DATASET DECLARE MoneyBall.
    SIMRUN
     /PLAN FILE=simplan_131746
     /CRITERIA REPRESULTS=TRUE SEED=629111597
     /PRINT ASSOCIATIONS=YES DESCRIPTIVES=YES PERCENTILES=NO
     /OUTFILE FILE=MoneyBall.

    Not quite sure what's up with this; we have to keep looking at it to see.






  • 6.  RE: Create Simulation Data Error Message

    Posted 18 days ago
    Rick, Thanks. This is very helpful.

    First, Yes the negative signs came through as questions marks in the original corr matrix. Apologies. 

    Second, I'm curious as to what is going on as well. Using dropdown menus shows the same min/max restriction syntax when paste is selected. Please let me know if there are additional details and thanks for the quick response. 

    Best, Matt

    ------------------------------
    Matthew Monnot
    ------------------------------