Hi Bruno,
I just changed the delimiter settings to pipe "|" via Control Panel, opened the Excel file, and saved it as a CSV file with the extension .txt.
Here is the SAS log. I'm converting the txt file using SAS EG.
57 %macro import_data; 58 data work.pipe212; 59 infile "&input.\&source..txt" 60 lrecl=32767 61 firstobs=2 62 encoding="WLATIN1" 63 termstr=CRLF 64 dlm='|' 65 missover 66 dsd 67 ignoredoseof; 68 input 69 %do i=1 %to &total; 70 &&field&i 71 %end; 72 ; 73 run; 74 %mend; 75 %import_data;
NOTE: The infile "E:\SAS_AC\98 SAS References\Import Pipe DLM to SAS\SOL_PIPE.txt" is: Filename=E:\SAS_AC\98 SAS References\Import Pipe DLM to SAS\SOL_PIPE.txt, RECFM=V,LRECL=32767, File Size (bytes)=196517682, Last Modified=29Sep2015:16:50:58, Create Time=29Sep2015:16:50:40
NOTE: 69312 records were read from the infile "E:\SAS_AC\98 SAS References\Import Pipe DLM to SAS\SOL_PIPE.txt". 3 The SAS System 16:02 Wednesday, October 7, 2015
The minimum record length was 606. The maximum record length was 32767. One or more lines were truncated. NOTE: The data set WORK.PIPE212 has 69312 observations and 66 variables. NOTE: Compressing data set WORK.PIPE212 decreased size by 96.57 percent. Compressed is 792 pages; un-compressed would require 23104 pages. NOTE: DATA statement used (Total process time): real time 6.11 seconds cpu time 4.52 seconds
Thank you,
Angelique
... View more