topic Re: infile date in a single record in SAS Programming

infile date in a single record

reone — Thu, 30 May 2013 10:30:06 GMT

Hi to all!!!

I have to read one file with only one SINGLE record and put it in SAS table with more records. the file is with this one record:

19941231 C 19950216 19950216 16000000 18300000 19951231 C T 19960226 19960226 17060000 20150000 19961130 19961207 19961207 10000000 18000000 ...... .................. ..................................... ......................

obviously the record is more long.

In general I make infile with multiple record and I hadn't any problems but I have some problems to create a sas program which reads only this record.

have you some idea?

Re: infile date in a single record

UrvishShah — Thu, 30 May 2013 11:15:36 GMT

Can you please define your multiple records in a meaningful way to prepare the SAS Codes from it...

In your post, what all those number represants ??? if you simply want to read one line which contains many variables then use double trailing @@ in your INPUT statement like this...

Input variable_name @@;

-Urvish

Re: infile date in a single record

reone — Thu, 30 May 2013 11:48:19 GMT

hi,

I can't define the files which I have to read.....

the layout is this:

data-elaboration 8 (aaaammgg)

filler1 $1

ch $1

filler2 $1

sw $1

filler3 $1

data-initialization 8 (aaaammgg)

filler4 $1

data-fin 8 (aaaammgg)

filler5 $1

hour-ini 8

filler5 $1

hour-fin 8

filler7 $32

the filler are always missing(' '), and ch or sw can be missing(' ') or one single charachter.

and the files contains only one record:

19941231 C 19950216 19950216 16000000 18300000 19951231 C T 19960226 19960226 17060000 20150000 19961130 19961207 19961207 10000000 18000000 19961231 19970105 19970105 10000000 18000000............................................................... ....................................

if you have some idea I'm gratefull...

thanks...

Re: infile date in a single record

data_null__ — Thu, 30 May 2013 12:24:13 GMT

This looks about right.

filename FT15F001 temp lrecl=1024; 
parmcards; 
19941231 C   19950216 19950216 16000000 18300000                                19951231 C T 19960226 19960226 17060000 20150000                                19961130     19961207 19961207 10000000 18000000                                19961231     19970105 19970105 10000000 18000000
;;;;
   run; 
   
data grate;
   infile FT15F001;
   input elab 8. +1 ch $1. +1 sw $1. +1 init 8. +1 fin 8. +1 hourIni 8. +1 hourFin 8. +32 @@;
   run;   

Re: infile date in a single record

UrvishShah — Thu, 30 May 2013 12:32:18 GMT

Try following code...

data want;

input data_elaboration 8.

filler1 $1.

ch $1.

filler2 $1.

sw $1.

filler3 $1.

data_initialization 8.

filler4 $1.

data_fin 8

filler5 $1.

hour_ini 8.

filler6 $1.

hour_fin 8.

filler7 $1. @@;

cards4;

12345678 C T 12358789 12547898 20145789 4578912

;;;;

Hope it helps...

-Urvish

Re: infile date in a single record

reone — Thu, 30 May 2013 12:51:50 GMT

Hi,

can you try with the file which I have attached in this response...

because, my programm don't finish..

Re: infile date in a single record

data_null__ — Thu, 30 May 2013 13:08:05 GMT

I reckon LRECL=N is what you need. Notice I remove @@;

data grate;
   infile '~/prova' recfm=N;
   input elab 8. +1 ch $1. +1 sw $1. +1 init 8. +1 fin 8. +1 hourIni 8. +1 hourFin 8. +32; 
   run;  

Re: infile date in a single record

reone — Thu, 30 May 2013 13:40:17 GMT

THANKS!!!!!!!