Hi, there! I am still becoming familiar with programming in SAS Studio 3.1, and am currently in the process of getting SAS to read CSV files that were created from Excel data spreadsheets. The file I'm using ("MyData_AMV.csv") is being imported and read as a table (work.MyData), which is great! But the values in the columns containing character string variables are being truncated to 8 characters, and I want to specify certain columns as having more characters in a string. For example, I want the "LastName" column to have a length of up to 20 characters. data work.MyData;
infile 'C:\\Users\Public\Documents\MyData_AMV.csv'
dlm=',' firstobs=2;
input StudentID LastName $ FirstName $ Age Gender $ Race $ InstitutionType $ InstitutionName $ HighSchoolGPA Term $ CourseSection $ LetterGrade $ CurrentStatus $;
run; Any suggestions on how to fix this problem would be much appreciated! Thank you! ~AMV
... View more