How to compare two dates in the different categories of the same varia...

sah_biostat · Posted 07-18-2023 06:10 PM

Hello team,

I would like to compare the two dates of the same variable but of the different categories.

My task here is to compare startdt of ttdeath with the startdt of ttadjcvd and if both are equal then I need to make ttdeath row values same as the ttadjcvd.

Can you please help me in this.

Thank you

mkeintz · Posted 07-18-2023 09:32 PM

Are you saying that you have a dataset, in which the variable PARAMCD has a single instance of the value TTDEATH, and a single instance of the value TTADJCVD? Also, is there a known order of observations in the dataset?

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

sah_biostat · Posted 07-19-2023 01:59 AM

Yes there are different values in the paramcd but for the one condition there are two instances and if start date of ttadjcvd equal to the startday of the ttdeath then I need to change the data of ttdeath to ttadjcvd

How to compare two dates in the different categories of the same variable

Re: How to compare two dates in the different categories of the same variable

Re: How to compare two dates in the different categories of the same variable