Help using Base SAS procedures

Choose infile or proc import

Reply
N/A
Posts: 0

Choose infile or proc import

I have 10 GB of data in a text file (formally external file). I have to load the text file into SAS Dataset. Which method of the below is best and why?
1. Using infile statement
2. Proc import method
Trusted Advisor
Posts: 2,116

Re: Choose infile or proc import

Posted in reply to deleted_user
You'd have to test to be sure.

If you use PROC IMPORT and need further data transformations, then you have to pass the data 4 times. You could do it with two passes by combining the data transformations in the same data step as the INFILE.

Beyond that, IMPORT is usually easier to set up and INFILE provides more control. If I were reading 10 GB, I'd go for control.
Super Contributor
Super Contributor
Posts: 3,174

Re: Choose infile or proc import

Posted in reply to deleted_user
What is your SAS experience level and how complex is the input data? Is the list of input fields and their content consistent throughout (or at least the first "nn" rows) to use with PROC IMPORT? If you are to code and support the INFILE processing method, you will have the ultimate flexibility with defining, validating and shaping your resulting SAS file. These are but a few of the considerations to make a reasonable decision.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 0 likes
  • 3 in conversation