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

What is the difference between INPUT and INFILE ?

1022


Difference between nodup and nodupkey options?

913


What are the difference between the sas data step and sas procs?

869


What do the PUT and INPUT functions do?

1051


What are types of transport files?

7464


In proc transpose and data step with arrays which one you pick?

2840


what are sas/access and sas/connect? : Sas programming

789


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1042


explain what is data set in sas? : Sas-administrator

770


explain the difference between proc means and proc summary?

912


What are the differences between sum function and using “+” operator?

840


What areas of SAS are you most interested in?

1297


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

912


How can I remove header from output data set?

2370


What is the difference between proportion and average?

3052