I need to consolidate fields and see that using a crosstable is the best way to do that. Below is my script. I don't think I am making this load as efficient as possible and my guess is bc I am using a resident load with each crosstable? (although that is what I need sourced). If you look at the first crosstable I want the options for the end users to have a PRIN DIAG field (prev loaded), a SEC DIAG field (prev loaded), and then a DIAGNOSIS field which is combo of both. To load my script pre-crosstable it used about 4 gigs of ram. When I added the 3 crosstables I killed it after it had consumed close to 9 gigs of ram. Just wondering if someone can verify I am using the best practice? Attached is the full script (crosstables are pg. 4-5).
