Hi Team, I facing issue while importing .csv file into SAS. I tried with different method but didn't succeed. I have multiple .csv files and these files contains some columns in which double quotation was part of the values . because of this double quotation, columns got truncated ,value mismatched and getting wrong output. Please refer below sample data and code.. data _null_; file "&path.real_data.txt" lrecl=10000; put '"Turner, Alfred","2A"'; put '"Anandsinh Sindha","4C"'; put '"Arundhati , "tiwari"","1A"'; run; data test; infile "&path.real_data.txt" dsd dlm=',' missover; length v1 $200 v2 $20 ; input 'V1'n :$CHAR200. 'V2'n :$CHAR20.; run; based on above code getting below output In this output, In observation-3 and V1 column is break before delimiter , value is separated while it finds double quotation in string value. I want to ignore that Quotation and add full string in single column. My desire output is mentioned below.. Please assist me to get my desire output in SAS. Thanks in Advance.
... View more