topic To DOW or not to DOW? or DOW Hash? in SAS Programming https://communities.sas.com/t5/SAS-Programming/To-DOW-or-not-to-DOW-or-DOW-Hash/m-p/46408#M9563 I am working on a project where I have built an episode file of nursing home stays (this was built with a DOW structure - up to 24 stays per episode). I have 3 files (hospitalizations (up to 23 per person), ER visits, and MDS assessments) which can be linked to the episode file. I would like to do repeated passes through the claims files based on (for example) a given diagnosis AND the closest date in terms of proximity to a given date on the episode file, attaching variables from the chosen claim to the episode file. It would be great to somehow do this with macro parameters and a DOW routine - but I'm having a hard time figuring out how to combine the two separate parameters (diag/MDS assessment type, date) into the DOW loop. Naturally, these files are extremely large. Any thoughts? TIA.<BR /> <BR /> Louise Thu, 07 Apr 2011 21:04:58 GMT louisehadden 2011-04-07T21:04:58Z To DOW or not to DOW? or DOW Hash? https://communities.sas.com/t5/SAS-Programming/To-DOW-or-not-to-DOW-or-DOW-Hash/m-p/46408#M9563 I am working on a project where I have built an episode file of nursing home stays (this was built with a DOW structure - up to 24 stays per episode). I have 3 files (hospitalizations (up to 23 per person), ER visits, and MDS assessments) which can be linked to the episode file. I would like to do repeated passes through the claims files based on (for example) a given diagnosis AND the closest date in terms of proximity to a given date on the episode file, attaching variables from the chosen claim to the episode file. It would be great to somehow do this with macro parameters and a DOW routine - but I'm having a hard time figuring out how to combine the two separate parameters (diag/MDS assessment type, date) into the DOW loop. Naturally, these files are extremely large. Any thoughts? TIA.<BR /> <BR /> Louise Thu, 07 Apr 2011 21:04:58 GMT https://communities.sas.com/t5/SAS-Programming/To-DOW-or-not-to-DOW-or-DOW-Hash/m-p/46408#M9563 louisehadden 2011-04-07T21:04:58Z