SHAZAM Community
Ask Your Question

Revision history [back]

To generate monthly means from the data (see below about replacing the semicolons with commas and adjusting for missing values) simply load the file, create and save means using:

read(testdata1.csv) / names
set skipmiss
stat / mean=means

To generate monthly means from the data (see below about replacing the semicolons with commas and adjusting for missing values) simply load the file, create and save means using:

read(testdata1.csv) / names
set skipmiss
stat / mean=means

The result is:

NAME        N    MEAN        ST. DEV      VARIANCE     MINIMUM      MAXIMUM
 YR1980       31   16.000      9.0921      82.667       1.0000       31.000
 JAN          31   21.997      3.7186      13.828       14.900       31.700
 FEBR         31   19.219      4.9212      24.218       10.600       28.600
 MARCH        31   26.394      4.3367      18.807       20.500       37.900
 APRIL        31   29.348      5.0025      25.025       20.400       39.400
 MAY          31   31.787      3.0804      9.4892       25.500       37.200
 JUNE         31   31.781      2.0271      4.1089       27.400       35.800
 JULY         31   34.055      3.8160      14.562       19.200       37.700
 AUG          30   34.970      2.4419      5.9629       28.200       38.300
 SEPT         30   28.493      2.2111      4.8889       21.000       31.400
 OCTOB        30   27.907      2.6245      6.8882       19.400       30.900
 NOV          30   25.973      2.0758      4.3089       20.000       28.800
 DEC          29   21.741      3.7812      14.298       15.400       28.800
click to hide/show revision 3
No.3 Revision

To generate monthly means from the data (see below other answer about replacing the semicolons with commas and adjusting for missing values) simply load the file, create and save means using:

read(testdata1.csv) / names
set skipmiss
stat / mean=means

The result is:

NAME        N    MEAN        ST. DEV      VARIANCE     MINIMUM      MAXIMUM
 YR1980       31   16.000      9.0921      82.667       1.0000       31.000
 JAN          31   21.997      3.7186      13.828       14.900       31.700
 FEBR         31   19.219      4.9212      24.218       10.600       28.600
 MARCH        31   26.394      4.3367      18.807       20.500       37.900
 APRIL        31   29.348      5.0025      25.025       20.400       39.400
 MAY          31   31.787      3.0804      9.4892       25.500       37.200
 JUNE         31   31.781      2.0271      4.1089       27.400       35.800
 JULY         31   34.055      3.8160      14.562       19.200       37.700
 AUG          30   34.970      2.4419      5.9629       28.200       38.300
 SEPT         30   28.493      2.2111      4.8889       21.000       31.400
 OCTOB        30   27.907      2.6245      6.8882       19.400       30.900
 NOV          30   25.973      2.0758      4.3089       20.000       28.800
 DEC          29   21.741      3.7812      14.298       15.400       28.800