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?
- 6 Answers
- 12837 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
infile and input statements.
ex:
data m;
infile 'c:\m.txt';
input :xxxx;
run;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sankar
use INFLE statement
data dsname;
infile 'path of file' <options>;
input var1 var2................varn;
run;
options like dsd dlm missover firstobs obs ..etc
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pramod
Using import wizard in file menu also we read an external
raw data file to a data step
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sastechies
We use SAS statements –
FILENAME – to specify the location of the file
INFILE - Identifies an external file to read with an INPUT
statement
INPUT – to specify the variables that the data is
identified with.
Read more: http://sastechies.blogspot.com/2009/11/sas-
interview-questions.html
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sankar
using proc import procedure
synatax :for text file
proc import datafile='path' out=datasetname
dbms=dlm;
delimiter='specific delimiter';
run;
| Is This Answer Correct ? | 1 Yes | 2 No |
what is the difference between informat$8. $char8.
Describe the ways in which you can create a macro variable?
what is conditional processing?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
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 it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
How could you generate test data with no input data?
what is Global Symbol table and Local symbol table?
what is the use of LRECL option.
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Do you need to rearrange the order of the data for the report?
where to use sas business intelligence? : Sas-bi
Teradata 
