Hi All, I have a data step as below to read a csv file, but the memo field for some records jump to the next row in the output dataset. I open the csv file in notepad and see the memo field seems to have double space before the quotation mark (not sure if that is the reason). See below data. I also tried TERMSTR=CRLF or TERMSTR=LF but I am still seeing the memo filed jumps to the next row. Given there is not an option to fix the data quality from the upstream, is there a way to resolve this in the data step? Johnson and Johnson,REF35847,Monthly,159,"Sandigo, Luke [INVENTORY MANAGER]","Meet - Standard - Year1/Quarter1 - 35153194 stock 301463 INV#12011088 ",5 data inventory;
infile "/warehouse/users/Jack/inventory/inventory_20201130.csv" dlm= ',' missover DSD lrecl=32767 firstobs=2 ;
input
CompanyName : $300.
Ref_ID : $50.
Freq : $10.
Value : 4.
Salesperson : $100.
Memo :$200.
ID :3.
;
run;
... View more