BookmarkSubscribeRSS Feed
srdr1217
Calcite | Level 5

What is Infile and file statements in SAS and what is the difference between them?

2 REPLIES 2
Kurt_Bremser
Super User

INFILE is used to denote an external file from whcih data is read into the SAS system.

FILE denotes an external file that data is written to.

 

Basic DATA step architecture:

 

DATA test;

INFILE "external_file.txt";

INPUT

  x1

  x2

;

RUN;

 

DATA _NULL_;

SET test;

FILE "another_external_file.txt";

PUT

  x1

  x2

;

RUN;

MikeZdeb
Rhodochrosite | Level 12

Hi ... you can try this ...

 

* create a data file (no data set created);

data _null_;

* specify the name of the data file;

file 'c:\new.txt';

* create some numeric variables and give them all a value of 99;

retain x1 x2 x3 99;

* write the values of the variables to the file specified in the FILE statement;

put x1-x3;

run;

 

* read the data file you just created and create a data set;

data new;

* specify the location of the data file;

infile 'c:\new.txt';

* read the data;

input x1-x3;

run;

 

* look at your data set;

proc print data=new;

run;

 

Another way to remember the difference between FILE and INFILE is to think of the statements PUT and INPUT.  PUT statements are associated with FILE (write to a file) and INPUT statements are associated with INFILE (read data from an already existing file).

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 6387 views
  • 0 likes
  • 3 in conversation