I have to import a DBF file with a specified layout, so i dont want to use the proc import because sometimes the proc runs wrong... When i try to import the DBF file using the infile statement, only the first line is loaded to the dataset..... Warning and errors dont appear in the log... How can i do this import? Thank you. data work.benefpagos;
infile '/sasdata/BSEG/HOLDING/riscos_ctba/solucoes/dataset/dev/BENEFPAGOS.DBF'
LRECL=183
encoding="LATIN1"
termstr=crlf
missover
dsd;
input COD_CIA : $CHAR5.
DT_SOLIC : $CHAR8.
NOM_PARTIC : $CHAR30.
NUM_PROP : $CHAR10.
NUM_PROC : $CHAR20.
TIPO_PROD : BEST32.
TIPO_PLANO : BEST32.
CPF_PARTIC : $CHAR11.
NOM_BENEF : $CHAR30.
CPF_BENEF : $CHAR11.
CNPJ_CIA : $CHAR14.
DT_EVENTO : $CHAR8.
VR_PROV : BEST32.
DT_PAGTO : $CHAR8.
VR_PAGO : BEST32. ;
run;
... View more