Q&A BY TAG 'SAS'

You must sign in to ask a question. If you do not have an account, you can register here

formatting date to ddMMMyyyy which is equivalent to date9
answered 17-07-2020 07:56:14 -0400

Good day I have a datetime format represented as 07DEC2005:00:00:00.000000 please note this is a date not character. I now want to convert to 'ddMMMyyyy' but still to be in a date format not as text or character. i have tried this sql code formatdate...

Answers: 1

SAS DENODO Dates

Using Denodo Views in SAS Enterprise Guide
answered 01-08-2018 12:44:54 -0400

Denodo platform 6.0 Good morning, I'm wondering if there's any documentation around best practices when querying Denodo views from a BI tool, specificallySAS Enterprise Guide. The main use case we're wondering about is joining a SAS data set to a Den...

Answers: 4

SAS QueryOptimization

How to import MULTIPLE SAS7BDAT files into Dendo?
answered 15-02-2018 06:42:43 -0500

I would like to import SAS7BDAT files into Denodo. I have received a SAS WRAPPER from Denodo. By using this wrapper, I am able to import the SAS file into Denodo but the problem is I can import ONLY ONE FILE at a time. I would like to import MULTIPLE f...

Answers: 1

Wrapper SAS import Mulitple Files

How can I import the SAS7BDAT file into Denodo with Metadata?
answered 02-02-2018 19:23:08 -0500

I would like to import the SAS7BDAT file to Denodo with Metadata. How can I do that? The metadata will go in the "Column Description".

Answers: 1

SAS import Metadata