Desktop productivity for business analysts and programmers

Using Import Wizard in SAS EG

Reply
Occasional Contributor
Posts: 7

Using Import Wizard in SAS EG

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

Regular Contributor
Posts: 220

Re: Using Import Wizard in SAS EG

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...

Occasional Contributor
Posts: 7

Re: Using Import Wizard in SAS EG

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.

Super Contributor
Posts: 333

Re: Using Import Wizard in SAS EG

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

Occasional Contributor
Posts: 7

Re: Using Import Wizard in SAS EG

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?

Frequent Contributor
Posts: 91

Re: Using Import Wizard in SAS EG

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

Nick

New User
Posts: 1

Re: Using Import Wizard in SAS EG

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

Can u share it?

 

Thanks.

 

 

Ask a Question
Discussion stats
  • 6 replies
  • 1040 views
  • 0 likes
  • 5 in conversation