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 do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is function of retain statment
What is the use of stop statement?
What is difference between Global n Local Macro Variables..?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
How does proc sql work?
How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.
What is the purpose of _character_ and _numeric_?
explain the key concept of sas? : Sas-administrator
what is syntax of proc merge ?