column parsing question

Reply
New Contributor
Posts: 2

column parsing question

I am trying to parse a date that is entered like so  1999-12-30   in a .CSV file.  I know this is easy but I can't remember how to do it

Super User
Posts: 10,028

Re: column parsing question

yymmdd10. ?

Occasional Contributor
Posts: 8

Re: column parsing question

See picture below.. used EG to generate a starting shell of an import data step using the yymmdd10. informat Xia mentioned above.. obviously if you are not on windows the DLM and other options will be different, as well as the file and variable names.

Untitled.png

New Contributor
Posts: 2

Re: column parsing question

Posted in reply to crosskonaftw

thanks for the replies.

Ask a Question
Discussion stats
  • 3 replies
  • 283 views
  • 1 like
  • 3 in conversation