topic Re: Reading dates into SAS in SAS Programming

Reading dates into SAS

maroulator — Fri, 05 Sep 2014 17:12:25 GMT

I am trying to import the column in the attached file into SAS; I have been using the following code and I am getting an error in the input line. I am using SAS 9.2; could someone provide some insight as to why this doesn't work?

data WORK.NCDebt;

infile '/SourcePath/Example.csv';

informat Maturity yymmdd8.;

format Maturity yymmdd8.;

input Maturity :yymmdd8.;

run;

Re: Reading dates into SAS

ballardw — Fri, 05 Sep 2014 17:24:20 GMT

Your dates should be read with a mmddyy informat. The while 5 might pass as a year 15 is not a month (the MM part) and 2014 is right out for the day of the month.

and why make an attachment instead of posting:

5/15/2041

5/15/2039

5/15/2038

5/15/2021

5/15/2020

7/2/2015

1/20/2015

11/20/2014

9/16/2014

9/15/2016

Re: Reading dates into SAS

Hima — Fri, 05 Sep 2014 17:32:51 GMT

DATA WORK.Example1;

LENGTH

F1 8 ;

FORMAT

F1 YYMMDD8. ; /** CHANGE THE FORMAT AS YOU NEED TO DISPLAY OUTPUT */

INFORMAT

F1 YYMMDD10. ;

INFILE 'xxxxx/Example.csv'

LRECL=10

ENCODING="LATIN1"

TERMSTR=CRLF

DLM='7F'x

MISSOVER

DSD ;

INPUT

F1 : ?? MMDDYY10. ;

RUN;