About Mary001

Mary001 · ‎04-22-2021

THANK YOU SO MUCH, Tom and Chris!!! You guys are a lifesaver!

Kurt_Bremser · ‎03-04-2020

@Mary001 wrote: Hi All, Yes, the sql is going to a db2 database to get the filtered data. "The TODAY() function does not work with most databases in a passthru." = Does this mean I need to find a db2 solution? Absolutely. As soon as you enter explicit pass-through, you (temporarily) leave the world of SAS.

Mary001 · ‎02-25-2020

THANK YOU so much everyone!!! You guys are amazing! I re-ran with the updated sql from Paige and received the correct results 🙂 Thanks again!

Online Status	Offline
Date Last Visited	‎04-22-2021 04:37 PM

Re: Multiple "select" statements using 1 db connection?

Multiple "select" statements using 1 db connection?

Re: intnx for previous eom date, not working in proc sql

intnx for previous eom date, not working in proc sql

Re: Can not get a distinct list with date/time field.

Re: Can not get a distinct list with date/time field.

Can not get a distinct list with date/time field.

Re: Multiple "select" statements using 1 db connection?

Re: intnx for previous eom date, not working in proc sql

Re: Can not get a distinct list with date/time field.