Hi, I have resolved by removing %stpbegin and %stpend and the options / nokeys nosastags, Thanks ... View more

@rakeon3 wrote: Thanks Patrick, but the input dataset can have multiple records with the same date. .... The current value of the different dt_rif is 9. However, they now want to modify this value. If they change from 9 to 10, the job must remove the oldest dates so that the output dataset contains the last ten distinct dates. @rakeon3 That's what the macro I've shared is doing. The HAVE dataset created for testing contains already two rows per date. ... View more

Hello @rakeon3  Perhaps I was not clear enough in my earlier post. You need to create the Oracle library in the metadata using SMC and register only those tables that you want to be displayed. There is a good article that is just right for the purpose https://support.sas.com/techsup/technote/ts771.pdf. There is another resource that may be helpful http://sasissues.blogspot.com/2015/05/how-to-create-library-for-oracle-in-sas.html. Creation of library are typically done by SAS Administrators. You can approach them for assistance. Once this is done, you can use the libname statement as mentioned in the earlier post. Hopefully this should help. ... View more