Thank you for linking the resource, but I think I'm still not sure how to solve my problem. Can you assist me in how this would look for my import? For a little more context in what I'm trying to do, this spreadsheet with all these variables is downloaded from a survey website. It is all the survey responses beginning with the very first response. I have little to no control over how this spreadsheet is downloaded from the website, but this data is downloaded multiple times a day due to the high usage of this survey. I then need to take this spreadsheet, import it into SAS, restructure the data so that I can take my dataset from short and wide to long and 'thin'. When we only had about 3500 variables, my current process was as follows: 1 - download the csv from the survey website 2 - import it into SAS 3 - rename variables and create a few new ones 4 - output into csv again 5 - re-import back into SAS with an infile statement forcing the formats of all these variables. The advantage to doing it this way is that if a survey respondent doesn't fill out some information in a cell, for ex: a date of birth, I can then force that cell to be a date format instead of a blank character. I need this because if I set these variables together and if their formats aren't the same, I get issues. When we only had about 3500 variables, this process worked just fine. Now that we've had to add some options (thus adding on a lot more columns) to about 4200 variables, this process is no longer working for me because my variable titles are disappearing in Step 4. This then hinders Step 5 and all the other SAS tasks that I need to do to work with this data. Cassie
... View more