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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to test the debugging in sas?

825


What is the length assigned to the target variable by the scan function?

873


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1907


Hi, If anyone has base SAS certification dumps, please share.

1588


why is a stop statement needed for the point=option on a set statement? : Sas programming

801






Explain proc sort?

852


what do the pad and dim functions do? : Sas programming

754


what is the use of sas management console? : Sas-di

790


how will you locate the sas platform applications? : Sas-bi

770


What is the basic structure of the SAS base program?

885


what is intially documentation in sas?

4585


What is the use of divide function?

777


What is the order of application for output data set options, input data set options and SAS statements?

1278


Describe 5 ways to do a “table lookup” in SAS?

857


Which command is used to save logs in the external file?

779