07-19-2013 11:30 AM
I am using SAS Enterprise Guide and have been importing .CSV files from my PC so that I can process them using SAS. Where I have a problem is I have a .CSV file with 30k rows and 30 columns, which I will be treating as SAS variables. Within Step 2 of the Wizard I had to define a starting position as well as limit the number of records to read in. When I proceeded to Step 3 I changed the long and not SAS friendly variable names to shorter names that I can use. Now my .CSV has 45k rows but still has the same 30 columns in the same order. No matter what I try when I change the number of records to read in during Step 2, Step 3 makes me redefine all 30 columns again.
Any ideas of how I can avoid redefining all variables each time I update the number of records?
07-19-2013 11:57 AM
I'm using the Import Wizard in SAS Enterprise guide and not a PROC Import statement. A work around would be to FTP the .CSV to the server and run PROC Import but we are trying to take advantage of the Import Wizard in case in the future we have an individual running the code with little to no SAS experience.
07-19-2013 02:04 PM
I was trying to avoid that but I think that might be my only option. The fear with reading in all rows is after my data I have information containing additional information that doesn't pertain to the variables and I'm worried that might screw up my SAS formats, which to new SAS users is sometimes a foreign language. Is there a way to limit the number of rows SAS looks at to determine the informats and formats?