What SAS statements would you code to read an external raw data file to a DATA

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

What SAS statements would you code to read an external raw
data file to a DATA step?

Question Posted / sasguru

10 Answers
27802 Views
NIIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / jothi sankar

INFILE statement

and

INPUT statement

Is This Answer Correct ?

33 Yes

2 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / mohan reddy

INFILE AND INPUT STATEMENTS

EX;
DATA EMP;
INFILE 'E:\ABC\EMPLOYEE.TXT' MISSOVER;
INPUT VAR1 VAR 2....VARN;
RUN;

Is This Answer Correct ?

14 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / god

using infile and input statements must it is possible to
clean and get the data into in u r environment....

some body says using proc import using proc import it is not
possible to clean and get the data in u r
environment..................it will take as it is

Is This Answer Correct ?

9 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / name is no need

we can import the an external file in three ways to a sas
data set
1.libname libref<location of the sas data set library>;
filname fileref<path of the raw data file>;
data <data set name>;
infile <fileref>;
input <variable declarations>;
run;
2.proc import

3.by using the proc import option in the sas wizard of file
menu option.

Is This Answer Correct ?

8 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / venki

input & infile

Is This Answer Correct ?

7 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / g.jyotshna

whenever the data in .txt .dat format we can directly us
infile and input statements.
but incase of .xls
it is not possible to read excel data file directly through
infile input.
we have to use:
wizard
DDE(dynamic data exchange)
proc import (its best one)
(in projects we go for proc import only)
after reading into sas session we will go for cleaning.

Is This Answer Correct ?

5 Yes

4 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / srilatha

infile & input statements

Is This Answer Correct ?

1 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / ranjitha

infile statement

Is This Answer Correct ?

1 Yes

0 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / sivanjaneyulu

using proc import,infile and input

Is This Answer Correct ?

4 Yes

4 No

What SAS statements would you code to read an external raw data file to a DATA step?..

Answer / aks

Proc import

Is This Answer Correct ?

0 Yes

0 No

Post New Answer