To follow is the code I'm using. It seems to be working fine with the exception of the .first variable data step. Thanks for any additional help.
/* Calculate the median wait times to initial LTC placement by type of LTCF and situation (i.e. community & hospital)*/
/* First pull wait offers...
I want to thnak all of you who took the time to reply to my post.
I still haven't been able to always pull the first record but still working on it.
Thanks again.
Scenario: Want to pull only the first record of a dataset by user ID (may be duplicates for any given user) by earliest date and record number ID (may be duplicates for any given user). This is what I’ve tried so far and it is not always pulling the first visit.
proc sort data=FirstVisit...
Yes, the data will be entered via a form. KARL is an example of a predefined unique field assigned to each record of the database.
Can you suggest where I might find some sample VBA coding that would enable me to do what you’ve suggested? Thanks so much for your help.
When a record is first added to this particular database I’m working on, I would like a record to be automatically assigned the current date (e.g. 22-Jul-09) in a separate field. I also would like to be able to automatically assign each record with a unique alphanumeric identifier (e.g...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.