Date: Mon, 4 Nov 1996 10:14:49 -0800
Reply-To: gxx18300@ggr.co.uk
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Bruce Rogers <gxx18300@GGR.CO.UK>
Organization: Medical IR, Glaxo Wellcome
Subject: Re: DATE INPUT
Lars Ladfors wrote:
>=20
> mY PROBLEM IS THAT VARIABLE M2 TO BE IMPORTED FROM THE TEXT-FILE LAD.TX=
T
> I YYMMDD AND
> I DONT KNOW HOW TO "TELL" THE PROGRAM ABOUT THIS IN THE INPUT-STATEMENT.
>=20
> data ENK.MYOWN;
> infile 'C:\DOK\ENK=C4T\DATA\lad.txt' lrecl=3D414;
> input
>=20
> m1 1-2
> pnr $12-21
> m2 22-27
> m3 28-33
> p 34-39
> ;
>=20
> FORMAT M2 date.;
>=20
> ruN;
>=20
> yOURS
>=20
> LARS
Lars,=20
FORMATs define how values are written, INFORMATs (INput FORMAT) define
how they should be read. Try :
data ENK.MYOWN;
infile 'C:\DOK\ENK=C4T\DATA\lad.txt' lrecl=3D414;
INFORMAT M2 YYMMDD6.;
input
m1 1-2
pnr $12-21
m2 22-27
m3 28-33
p 34-39
;
run;
A preferred (IMHO) alternative is to explicitly use the input formatS on
the INPUT statement :=20
data ENK.MYOWN;
infile 'C:\DOK\ENK=C4T\DATA\lad.txt' lrecl=3D414;
input
@1 m1 2.
@12 pnr $10.
@22 m2 YYMMDD6.
@28 m3 6.
@34 p 6.
;
run;
HTH
Bruce