What SAS statements would you code to read an external raw
data file to a DATA step?
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 |
How would you code a merge that will keep only the observations that have matches from both sets?
What does error:1 mean?
what is pdv? how it is related to input buffer in sas?
explain the use of % includes a statement in sas? : Sas-administrator
which features do you use to check the data validations and errors? : Sas-administrator
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?
How to write duplicate records into a separate dataset using sort?
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?
what is the use of catalog?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately