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
- 13227 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 |
Mention few ways with which a “table lookup’ is done in sas programming.
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
explain the proc in sas? : Sas-administrator
Under what circumstances would you code a SELECT construct instead of IF statements?
what is the formula to measure Baseline
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
Describe the ways in which you can create macro variables? : sas-macro
what is the difference between proc report and proc format?
what is the main difference between rename and label? (don't say that they both perform the same function).
sas implimented companies in hyderabad
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.
Teradata 
