About Jakob_midspar

Jakob_midspar · ‎04-26-2018

Great solution, thanks for your input. Cheers, Jakob

Jakob_midspar · ‎04-25-2018

The interpreter only understands '21apr2018'd as legit input not 21295.

Jakob_midspar · ‎04-25-2018

That's how far I've gotten myself - but still needs the gnyffs and the d ( '21apr2018'd ) for it to be recognized as a SAS date constant.

Jakob_midspar · ‎04-25-2018

Sure, I can try and clarify as to why I need that SAS date constant instead of simply the SAS date. I'm getting data from a Teradata source using an ODBC connection and apparently the interpreter can only translate a SAS date constant to Teradata and not the SAS date itself, beats me why!

Jakob_midspar · ‎04-25-2018

Hi Community I'm in need of a function or a format that can help me convert a SAS date to a SAS date constant. What I have is a variable containing a SAS date e.g. 21295, (21. of April 2018), what I need is to convert the SAS date to a SAS date constant i.e. '21apr2018'd. How can I do this without choosing a date9. format for the SAS date and concatenating it with ''d? Cheers, Jakob

Online Status	Offline
Date Last Visited	‎04-26-2018 09:44 AM

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Re: Why would someone use SAS?

Re: Why would someone use SAS?

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Re: Can I convert a SAS date to a SAS date constant?

Can I convert a SAS date to a SAS date constant?