Reading a ~ separated raw file

SOORISAS — Tue, 10 Jun 2014 10:13:04 GMT

Hi,

I've a problem in reading file like below:

NAME:ANDREW~DOB:12-25-1986

NAME:DECK~DOB:04-04-1956

PLEASE HELP IN READING CORRECTLY

Re: Reading a ~ separated raw file

Scott_Mitchell — Tue, 10 Jun 2014 10:38:17 GMT

See how this works for you.

DATA WANT;

INFILE DATALINES DLM='~';

INPUT @"NAME:" NAME $

@"DOB:" DOB;

INFORMAT DOB MMDDYY10.;

FORMAT DOB DATE9.;

DATALINES;

NAME:ANDREW~DOB:12-25-1986

NAME:DECK~DOB:04-04-1956

;

RUN;