PROC SQL;
CREATE TABLE KH.POS
( ACNO CHAR(19) ,
JYYF CHAR(4),
JYQD CHAR(2),
JYCS INT,
JYJE DEC(15,2),
CUNO CHAR(8),
CTDT CHAR(6)
);
QUIT;
PROC IMPORT DATAFILE= "E:\POS.TXT"
OUT= KH.POS
DBMS=','
REPLACE;
RUN;
DATA KH.POS;
INFILE 'e:\POS.txt';
INPUT @1 ACNO $19. @22 JYYF $6. @30 JYQD $2. @34 JYCS @42 JYJE 10.2 @51 CUNO $8. @60 KHRQ $6.;
RUN;
DATA KH.POS;
INFILE 'e:\POS.txt';
INPUT ACNO $19. JYYF $6. JYQD $2. JYCS JYJE KHRQ $6.;
DLM=',';
GETNAMES=NO;
RUN;
proc import datafile='e:\POS.txt'
out=pos
dbms=dlm
replace;
delimiter=','; /* the data file is , delimited */
datarow=7;
run;