Dear All
I have xls file and one of column has value like this 'some text1','some text2','some text3' (with quotes) ,While reading this xls file using proc import SAS misses first " ' " from the value in dataset .and I get value in dataset as
some text1','some text2','some text3' (note 1st quote is missing)
Can anyone let me know reason or fix for this ?
Please supply the code you are using and an example file as it appears you are talking about two different things. What I mean by this is that an Excel XLS file would not be stored as you state above (unless of course the quotes are in the cells themselves), so I am assuming that you are talking about a CSV (comma separated variable) file, which Excel can open, but is not a native Excel file format.
So what is your code for importing this, do you want all the text in one variable? Maybe try:
data want;
infile "You_data.csv" dsd missover dlm='¬';
input buffer $varying256.;
run;
I use code something like this
proc import datafile = "location_of_file/test_file.xls"
out = test_file replace dbms=xls;
sheet = "sheet1";
getnames = yes;
run;
attached is test file (see original post) and you will notice that first single quote is missed once file is read with the code I supplied;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.