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 |
: and & modifiers.
How do you test for missing values?
Code the MEANS to produce output to be used later.
how many display types available in sas bi dashboard? : Sas-bi
what is information maps?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Do you need to know if there are any missing values?
What is the order of application for output data set options, input data set options and SAS statements?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
do you need to know if there are any missing values? : Sas programming
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?