Hello,
I´m trying to import data from .TXT file to dataset. The original data has the following format:
Original data from .TXT
I´m using the following code:
DATA teste;
LENGTH
LOG_ID 8
LOG_DH_INICIO 8
LOG_DH_FIM 8
LOG_ID_PROPOSTA 8
FORMAT
LOG_ID BEST18.
LOG_DH_INICIO DATETIME18.
LOG_DH_FIM DATETIME18.
LOG_NM_POLITICA $CHAR14.
LOG_ID_PROPOSTA BEST13.
INFORMAT
LOG_ID BEST18.
LOG_DH_INICIO DATETIME18.
LOG_DH_FIM DATETIME18.
LOG_ID_PROPOSTA BEST13.
INFILE 'xxxxxxxxxxxxxxxxx'
LRECL=32767
FIRSTOBS=2
OBS=11
ENCODING="LATIN1"
DLM='3b'x
MISSOVER
DSD ;
INPUT
LOG_ID : ?? BEST18.
LOG_DH_INICIO : ?? ANYDTDTM19.
LOG_DH_FIM : ?? ANYDTDTM19.
LOG_ID_PROPOSTA : ?? BEST13.
INFORMAT
LOG_ID BEST18.
LOG_DH_INICIO DATETIME18.
LOG_DH_FIM DATETIME18.
LOG_ID_PROPOSTA BEST13.
RUN;
The dataset result of this process is shown bellow, however the variables LOG_DH_INICIO and LOG_DH_FIM are in reverse comparing with the original ones.
How can I handle with this kind of error? SAS Log doesn´t show any error over this process.