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 |
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
how to do user inputs and command line arguments in sas?
In which format does Date stores in sas..? What is the use of DATE in SAS.?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
Baseline definition in your study
3 Answers Accenture, Quintiles,
what are the component of range? : Sas-bi
explain what is data set in sas? : Sas-administrator
how many types of MERGE?
How would you compile all macros from a folder in a study, within the autoexec program?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
How would you delete observations with duplicate keys?