Reading a ~ separated raw file

[SOORISAS]

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

[Scott_Mitchell]

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;