I am trying to read in a csv (test.csv) file that looks roughly like this (but >10k rows and 6 columns) ----------- |"id" ,var1, var2 | |"0000",12,14| |"1234",45, 10| |"5678", 12,10| ---------- When I import the data with the below code the quote stay and I have a character variable of length 6. proc import datafile = "test.csv" out = test dbms = csv run; proc contents test = want varnum; run; My end goal is to merge this dataset with another dataset using a left join. But in that data set the id don't have quotes and the length of the character variable is 4. But the left join is failing because I'm joining on things of different length. The dataset is too long for me to manually delete the quotes in the csv. I've tried this and it didn't really work https://communities.sas.com/t5/SAS-Programming/Removing-quoted-text-from-value/m-p/778749#M247927
... View more