Steve, I use the crosstab to create tables in some of my applications. Here is a snippet of code that I use in one of my routines.
SET ZERO OFF OUTPUT shoe_grid.dat CROSSTAB SUM auth_qty FOR mfg_size BY mfg_width FROM upc_master + WHERE mfgcode = .vMFG AND mfg_style = .vMFG_STYLE OUTPUT SCREEN LOAD asq_grid FROM shoe_grid.dat AS ASCII In this case the crosstab data is output to a file and then I use the data in the file to create a table. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Wills, Steve Sent: Wednesday, March 19, 2008 12:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Saving CROSSTAB Results ... Is there a good way to save the output/results of a CROSSTAB to a table (or XLS file)? I know there's an old, "legacy" document somewhere - I think I even have the old RBExchange magazine in the attic - but surely there's a newer, better way. Thanks, Steve in Memphis J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
