Hastie, Could I ask what sort of analysis or report you plan on running with the resultant dataset? As others have commented, 40,320 variable is a lot of variables. If you will be doing additional analysis what statistical/analytical application (SAS, Stata, SPSS, R, etc.) and which procedure or routine do you plan on using? If you are preparing a report, what tool do you intend to use (Excel, Crystal Reports, SQL Server, etc.) Someone here might be able to suggest a more efficient way to organize the data.
... View more