Interested to Buy Any Domain ? << Click Here >> for more details...
What SAS statements would you code to read an external raw
data file to a DATA step?
- 10 Answers
- 27738 Views
- NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Compare sas with other data analytics tools.
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
List out some key concept of SAS
Mention few capabilities of sas framework.
Explain what is the use of proc gplot?
Do you know the features of sas?
what other sas products have you used and consider yourself proficient in using? : Sas programming
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
What makes sas stand out to be the best over other data analytics tools?
Teradata 
