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
- 27784 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? What are the functions does it performs?
What is the difference between INPUT and INFILE ?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what is the difference between nodup and nodupkey options? : Sas programming
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
what is the difference between proc means and proc summary?
what is in stream data in SAS?
What is the registered Key word is sas????
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
Teradata 
