Help using Base SAS procedures

Reading xls file having single quote using proc import

Reply
Contributor
Posts: 56

Reading xls file having single quote using proc import

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 ?

Super User
Super User
Posts: 7,942

Re: Reading xls file having single quote using proc import

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;

Contributor
Posts: 56

Re: Reading xls file having single quote using proc import

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;

Ask a Question
Discussion stats
  • 2 replies
  • 480 views
  • 0 likes
  • 2 in conversation