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

Explain the purpose of substr functions in sas programming.

814


what is SAS OPTIMIZATION?

2047


What does P-value signify about the statistical data?

1110


How do you debug and test your SAS programs?

1290


what is business intelligence? : Sas-bi

816


Describe what are the different levels of administrative users in sas? : sas-grid-administration

806


What is a put statement?

944


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2180


explain what is factor analysis? : Sas-administrator

856


What is the general format of function in sas? : sas-grid-administration

783


What are the functions used for character handling?

901


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

788


What are symget and symput? : sas-macro

1001


How to include or exclude specific variables in a data set?

887


What are the ways to do a “table lookup” in sas?

798