User the ODS output statement for HAZARDRATIOS. It's in the 9.2 documentation. ... View more

To use the simple syntax of the IN operator means that you have to pre-process your data to pull the conditions of interest out of the concept variable. It is really a case of 'pay me now or pay me later', at some point you have to parse the variable concept. TANSTAAFL ... View more

As I stated previously, you can use IF LAST. THEN OUTPUT; with a sorted file using a BY statement and being the last variable in the BY. From your explanation, I believe the BY variables are ID, DATE (suggest inputting as a SAS NUMERIC date, not character), SERVICE and TYPE. Use EQUALS on the SORT to ensure the incoming order is maintained for your AMT values. Again, see the recommended SAS support site DOC references for details, and also the EQUALS parameter discussion for PROC SORT. Scott Barry SBBWorks, Inc. ... View more

Hi, Linus: Thanks a lot. It is much better than the way I used before. Nice weekend, Tulip ... View more

Hi, Bill: I tried it and it worked so well. Again, thanks lot. Regards, Tulip ... View more

Thank you very much. I will try that. ... View more

Hi, Patrick: Thanks for your reply. By the way, the reason I could not use the olivier's short cut is that if I use var:, it will read more than necessary. There are hundreds of variable started with var. ... View more

thanks. that is a great help. ... View more