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
what is enterprise guide? What is the use of it? : Sas programming
what are the component of range? : Sas-bi
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
How do dates work in sas?
How are numeric and character missing values represented internally?
what are sas bi dashboard components? : Sas-bi
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What are the data types does SAS contain?
What are the difference between ceil and floor functions in sas?
What is a put statement?
What does proc print, and proc contents are used for?
Name and describe few sas character functions that are used for data cleaning in brief.
What is maximum storage capability of SAS?
Approximately what date is represented by the SAS date value of 730?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?