Hello Everyone, I have a csv file with 4 columns in which data within the first column is stored as json text whose length exceeds 32767. Can you please help me with the code to import this column into sas. Please find below the code I have used. This splits the column with json text abruptly only where the rows have length more than 32767, the other rows are imported correctly. data Test; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "\test.csv" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1; length var1-var4 $10000.; input var1-var4 $; run;
... View more