TLDR:
I want to read my access database via infile statement to have complete control over format,informat,length of variables/columns
I have an access database which has around 2 million records.Currently I am importing it with PROC IMPORT.
The problem:
From what I have read that PROC IMPORT uses around 32k rows to set format,informat,length for variables I feel that data may be getting truncated.
Another problem is all my character variables have format and informat as $255.and length as 255.I dont want my all variables to be of this length,format,informat.
Some I want to be more than 255 and some to be less than that.
My current code:
PROC IMPORT OUT= Input.access_db
DATATABLE= "DATABASE"
DBMS=ACCESSCS REPLACE;
DATABASE="\\Input\Entire_Records.accdb";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=NO;
RUN;
I want to do above with an infile statement.
I have a code to import my csv via infile statement.But I am not getting how do I modify it to make it to read my access database
data Input.Real;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile 'Input\Real.csv'
delimiter = ','
MISSOVER
DSD
lrecl=32767
firstobs=2 ;
informat DATE 11.;
informat IDENTIFIER $255. ;
informat LINE_CODE $255. ;
informat ACTION $255. ;
format DATE 11.;
format IDENTIFIER $255. ;
format LINE_CODE $255. ;
format ACTION $255. ;
input
DATE
IDENTIFIER $
LINE_CODE $
ACTION $ ;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
RUN;
