I am reading a dataset that is created and being update by a SAS program. Unfortunately the Date is stored as SAS Date format and it's not possible to change the source format as lot of other SAS programs are reading this data. As a Webfocus fan I am trying to create some reports in WF. Is there a way to convert the SAS date in Webfocus?

Example of the data I am getting...

SASDATE
17,695.00
17,696.00
17,695.00
17,696.00

This message has been edited. Last edited by: CRICKETMIND,

  
-SET &BASE_DATE = '19600101';
DEFINE FILE CAR
  BASE_DT/YYMD  WITH COUNTRY = '&BASE_DATE.EVAL';
  CUR_DATE/YYMD WITH COUNTRY = DATEADD(BASE_DT,'D',17695);
END
TABLE FILE CAR
SUM
    DEALER_COST
    RETAIL_COST
FST.CUR_DATE
  BY COUNTRY
  BY CAR
END
-EXIT 

Or, create a FUNCTION

SAS Support when GOOGLEd

So its just a number of days since value then.

You could also use just a single function to calculate the SAS date, by using the fact that the SAS base date difference to the WF base date is 21550 days.

However, using either method, I would suggest that you trap the SQL created to ensure that the method that you use can be passed through the adapter - especially if you have large amounts of data!

COMPUTE SAS_DATE/YYMD = DATECVT(17695 + 21550, 'YYMD', 'YYMD');

Thanks to Tom for pointing the way of course!


T

Thanks for your solutions. I was checking if there were a WF function available to convert SAS date.

Both solutions work great.