Question

Difference between INPUT and INFILE

Answer 1

The INFILE statement is used to identify an external file while the INPUT statment is used to describe your variables.

FILENAME TEST 'C:\DEEP\File1.xls';

DATA READIN;

INFILE TEST;

LENGTH NAME $25;

INPUT ID NAME$ SEX;

RUN;

Note : The variable name, followed by $ (dollar sign), idenfities the variable type as character.

In the example shown above, ID and SEX are numeric variables and Name a character variable.