Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This syntax should do the trick. There is no need to migrate back and forth between SPSS and R solely for this task.</p> <pre><code>*making fake data, 4 million records and 150 variables. input program. loop i = 1 to 4000000. end case. end loop. end file. end input program. dataset name Temp. execute. vector X(150). do repeat X = X1 to X150. compute X = RV.NORMAL(0,1). end repeat. *This is the command you are interested in, puts the stats table into a new dataset. Dataset declare IQR. OMS /SELECT TABLES /IF SUBTYPES = 'Statistics' /DESTINATION FORMAT = SAV outfile = 'IQR' VIEWER=NO. freq var = X1 /format = notable /ntiles = 4. OMSEND. </code></pre> <p>This takes along time still with such a large dataset, but thats to be expected. Just search the SPSS help files for "OMS" to find the example syntax with how OMS works.</p> <hr> <p>Given the further constraint that you want to calculate the IQR for many groups, there is a few different ways I could see to proceed. One would be just use the split file command and run the above frequency command again.</p> <pre><code>split file by group. freq var = X1 X2 /format = notable /ntiles = 4. split file end. </code></pre> <p>You could also get specific percentiles within ctables (and can do whatever grouping/nesting you want for that). Potentially a more useful solution at this point though is to make a program that actually saves separate files (or reduces the full dataset the specific group while still loaded), does the calculation on each separate file and dumps it into a dataset. Working with the dataset that has the 4 million records is a pain, and it does not appear to be necessary if you are just splitting the file up anyway. This could be accomplished via macro commands. </p>
    singulars
    1. This table or related slice is empty.
    1. POHow to aggregate on IQR in SPSS?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndy W
    1. USAndy W
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAs a note my memory was exceeded when trying to run this on all 150 variables at once, but was not when only specifying one variable.
      singulars
      1. PO
      1. USAndy W
    2. COthank you very much, I think I get the point in saving the Descriptives in a new database - it seems really useful! My only problem that I cannot figure out how to do this with a break variable (as I would like to aggregate by that one), so to get a database with these values but for every category of the break variable (with around 2000 categories). I see I could do this in a loop (repeat from 1 to ~2000) by filtering the cases for the given category, but it would result in a bunch of files. Do you have an idea how to improve your answer? Thanks again, you definitely deserved upvote.
      singulars
      1. PO
      1. USdaroczig
    3. COsorry for late reply, I was "playing" quite much (besides a lot other things) with OMS to test this method. While OMS seems really nice, splitting such big file on a regular basis **is** really resource hungry - the syntax was running for two days for only one variable :) So I will go with @JKP's suggestion which seems to be really fast compared to the OMS/splitting, so the check-mark goes there. Anyway: thank you *very much* for your really kind help and also for pointing my attention to OMS!
      singulars
      1. PO
      1. USdaroczig
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload