I have an .XLSX document with two sheets - sheet1 and sheet2. I saved both sheets as .CSV files. I'm using SAS9.4.
I'm having an issue importing a sheet1.csv file into SAS. The import itself works, but it's cutting off responses for one variable. For example, a response for CONDITION in the .csv file is "to treat allergies" will be imput as "to treat aller". I've attached the code that SAS import wizard produced when importing this file.
I don't have this issue when I import sheet2.csv file - the response for CONDITION do not get cutoff. For example, "cough and to control asthma" is imput as "cough and to control asthma".
Both .csv files come from the same document, I don't know why the responses are getting cut off for CONDITION in sheet1.
Any help would be much appreciated!
PROC IMPORT out=work.sheet1
datafile = "path\sheet1.csv"
DSMS=CSV REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;
PROC IMPORT out=work.sheet2
datafile = "path\sheet2.csv"
DSMS=CSV REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;