What SAS statements would you code to read an external raw
data file to a DATA step?
- 6 Answers
- 11231 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 the SAS v8 and SAS v9?
One way of creating a new variable in Macros is by % Let....What is the other way..?
In sas, what are the areas that you are most interested in? : sas-grid-administration
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
diff between nodup rec and ondup key???
How do you use the do loop if you don’t know how many times you should execute the do loop?
what are the differences between proc report and proc tabulate?
how to debug and test the sas program? : Sas-administrator
What is the length assigned to the target variable by the scan function?
Name and describe few sas character functions that are used for data cleaning in brief.
What is the Program Data Vector (PDV)? What are its functions?
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
Teradata 
