What SAS statements would you code to read an external raw
data file to a DATA step?
- 10 Answers
- 26469 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 |
what is sas? is a package or tool? give me introduction about sas?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
what is Difference between PROC SQL JOINS and MERGE?
What function CATX syntax does?
how could you generate test data with no input data? : Sas programming
Explain the main difference between the sas procedures and functions? : Sas-administrator
What is the order of evaluation of the following operators + - * / ** () ???
What are the applications primarily used by business analyst? : Sas-bi
How could you generate test data with no input data?
which date functions advances a date time or date/time value by a given interval? : Sas programming
One way of creating a new variable in Macros is by % Let....What is the other way..?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Teradata 
