Hi All, I am trying to read a comma separatef flat file with following layout. 000000001687561, 000000001915561, 000000002877561, 000000004974561, 000000005703561, 000000006139561, 000000006594561, 000000006612561, 000000006806561, 000000007 108561, 000000007114561, 000000007581561, 000000007682561, 000000008259561, 000000008594561, 000000008864561, 000000009334561, 000000009840561, 000000010167561, 00 01333566192, 041501334051192, 041501340710192, 041501367218192, 041501462985192 I need to read this flat file in on column. Let us say. obs id 1 000000001687561 2 000000001915561 3 000000002877561 4 ... 5 ..... I am having issue reading the last record of each line as it goes to next line to complete the record. I am using the following code. Is there better code for this? Can someone please help me out ? data test (drop=rec_no i); Thanks ! infile "c:\aa.txt" dlm = ',' dsd missover ; length id $ 15 ; retain rec_no 0 ; rec_no + 1 ; do i = 1 to 40 input i $ @; if i = ' ' then delete ; output ; end ; run ;
... View more