What statement do you code to tell SAS that it is to write
to an external file?
Answers were Sorted based on User's Feedback
Answer / jothi sankar
_NULL_ statemnet.
Eg:
DATA
_NULL_;
SET MYDATA;
FILE '<FILE-LOCATION>';
PUT var1 var2 var3 ... varn;
RUN;
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sankar
using export procedure
syntax
in txt file: proc export data=datasetname dbms=dlm
outfile='path';
delimiter='specific delimiter';
run;
in excelfile: proc export data=datasetname dbms=excel200
outfile='path'
sheet='sheetname';
run;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kranthi arabelly
Folks ...plz see bellow diff instream and External file
1. Data from an external file
DATA statement;
INFILE statement;
INPUT statement;
other SAS statements used in the DATA step
Run;
2. Data in job stream
DATA statement;
INPUT Statement;
other SAS Statements used on the DATA step
CARDS Statement;
data lines
;
| Is This Answer Correct ? | 2 Yes | 5 No |
What is the size of PDV?
What would be the value of month at the end of data step execution and how many observations would be there?
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
Difference between informat and format?
Compare sas with other data analytics tools.
Explain the use of proc gplot? : sas-grid-administration
how to read character value without using substr function in sas ?
How to write duplicate records into a separate dataset using sort?
do you prefer proc report or proc tabulate? Why? : Sas programming
sas macros
Explain append procedure?
What is factor analysis?