Using Import Wizard in SAS EG

[BHarmon]

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?

Thanks,

Bryan

[sas_9]

if you want to control variables you can always use KEPP= or DROP= options and if you wants to control the rows then you can go for OBS= option...

[BHarmon]

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.

[esjackso]

Could you just read in all the rows with the import task in the flow and then limit what rows in a filter task?

EJ

[BHarmon]

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?

[nrose]

Try using the 'performance' button in step one of the wizard. It has an option to limit which rows a looked at.

Nick

[vjhs27]

Hi! I'm just having the same problem. Did u get any solution?

Can u share it?

Thanks.