topic Re: SAS EG is not able to read SAS DI Work table date format and populating 1JAN1960 for all rows in SAS Enterprise Guide

SAS EG is not able to read SAS DI Work table date format and populating 1JAN1960 for all rows

sanjana30 — Fri, 06 Oct 2023 12:46:14 GMT

I have written a Job in SAS DI with required date format yymmddn8. in work table , the SAS output needs to be converted in .csv . For exporting to .csv im using standard proc export statement however the resultant .csv file has 1JAN1960.

Please suggest.

Re: SAS EG is not able to read SAS DI Work table date format and populating 1JAN1960 for all rows

LinusH — Mon, 09 Oct 2023 07:26:00 GMT

First. it seems that you didn't get your format applied, since 1Jan1960 is in date9. format.

Then it seems that all you date values are 0, so check your data input, mappings etc.

If you still need more hands on help, provide your code, and input data in the form of data step with a datalines statement.