Back to SPR List Previous Next
SPREADSHEET Procedure before FREQUENCIES stops the freq output
Minor Closed - Fixed Found:XS.01.10 23 OCT 2008 Fixed:XS.01.11 23 OCT 2008

DETAILS
 If a SPREAD SHEET procedure is executed before a FREQUENCIES procedure then that second
 procedure does not produce any output.

 In the example below the file FREQS1a.TXT is not created by the first retrieval. In both
 cases the tabulate output is created.
EXAMPLE PROGRAM
 retrieval
 . process cases
 .   process record employee
 .     get vars all
 .     perform procs
 .   end record
 . end case
 . SPREAD SHEET  VARIABLES = NAME GENDER SSN
                 TITLE     = "Spreadsheet First"
 							
 . FREQUENCIES INTEGER    = EDUC (1 , 6) /
               FILENAME   = "FREQS1a.TXT"  /
               TITLE      = 'Education Levels in Company' /
               STATISTICS = ALL /
 						
 . TABULATE HEADER = (GENDER) FILENAME = 'TABLE1A.HTM'

 end retrieval

 retrieval
 . process cases
 .   process record employee
 .     get vars all
 .     perform procs
 .   end record
 . end case
 							
 . FREQUENCIES INTEGER    = EDUC (1 , 6) /
               FILENAME   = "FREQS1b.TXT"  /
               TITLE      = 'Education Levels in Company' /
               STATISTICS = ALL /

 . SPREAD SHEET VARIABLES = NAME GENDER SSN
                TITLE     = "Spreadsheet Second"

 . TABULATE HEADER = (GENDER) FILENAME = 'TABLE1B.HTM'

 end retrieval
WORKAROUND
Move the SPREAD SHEET procedure to after the FREQUENCIES.
Back to SPR List Previous Next