topic Import dates variable from CSV in SAS Programming

Import dates variable from CSV

ChristyN — Thu, 18 Aug 2016 21:54:30 GMT

Hello, I am trying to import from a csv file and the source format of a date variable is: 1994 04 11 00:00:00

This is piece of the program I am using. It was working fine before there was change in the system default for the format:

input
ID :10.
Date : DATE12.

Thanks in advance.

ballardw — Thu, 18 Aug 2016 17:56:52 GMT

try YYMMDD10. for an informat.

Or to minimize future issues use an informat statement:

informat date anydtdte32. ;

and don't have the format on the input.

ChristyN — Thu, 18 Aug 2016 21:53:53 GMT

Perfect! Thanks so much...You are my SAS Idol 😉