Hello all, I am writing because I am having an issue inputing data into SAS. I have a spreadsheet of 136 rows and 19 columns. SAS is only recognizing 68 records and a varying number of observations and I am really losing my mind because I have never encountered this before, and when I tested each column to see if one of them was the culprit (adding each column's data via datalines) they were all read as 136!. It is only when I try to import the whole spreadsheet either via datalines or infile 'c:\.....' that it doesn't work. Things I have tried: - infile 'c:\mydata.prn'; -datalines; -putting a blank row in between each column of my excel spreadsheet before converting it to prn for use with SAS. -making the columns in my excel sheet very wide and centering the numbers before converting to prn If anyone has any ideas about why this might be happening or solutions (perhaps uploading each variable separately and then combining, if this is a possibility) please please let me know!! Best wishes!
... View more