About elolvido

elolvido · ‎04-20-2021

Thanks for the help, I'm going to try this out and report back! Yes, I'm sure there is a more efficient solution in R as well, I'm no master there either I'm afraid. But even with the most efficient R code I think it'd be a problem, given how slowly it runs basic functions compared to SAS when using large datasets (just loading the file takes twice the time).

ChrisNZ · ‎03-18-2021

I agree that option NODUPREC must be used carefully, as @Reeza show us is outlined in the documentation. The issues of option KEEP= not working as expected, as @data_null__ demonstrates, seems at odds with what this option is supposed to mean. Shouldn't this be seen as a defect? @skcussas You should start by reading the documentation before asking a question. This behaviour of option NODUPREC is nothing new.

elolvido · ‎06-15-2020

Ah yes, it is the end date I am rounding up to. Variable is a date not a datetime. Thanks very much for the solution and breakdown!

Online Status	Offline
Date Last Visited	‎05-13-2021 06:37 PM

Re: for loop from R to SAS

Re: for loop from R to SAS

for loop from R to SAS

Re: proc sort with nonduprecs does not work with data = ds(keep=)

Re: proc sort with nonduprecs does not work with data = ds(keep=)

Re: rounding up dates with rounding unit

Re: rounding up dates with rounding unit

rounding up dates with rounding unit

Re: for loop from R to SAS

Re: for loop from R to SAS

Re: proc sort with nonduprecs does not work with data = ds(keep=)

Re: proc sort with nonduprecs does not work with data = ds(keep=)

proc sort with nonduprecs does not work with data = ds(keep=)

Re: for loop from R to SAS

Re: proc sort with nonduprecs does not work with data = ds(keep=)

Re: rounding up dates with rounding unit