What statement do you code to tell SAS that it is to write
to an external file?
- 5 Answers
- 14424 Views
- I also Faced
- E-Mail Answers
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 |
Explain the purpose of retain statement.
How to create list output for cross-tabulations in proc freq?
Name and describe few sas character functions that are used for data cleaning in brief.
how do you debug and test your sas programs? : Sas programming
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
what are 5 ways to perform a table lookup in sas? : Sas-administrator
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Name some categories in sas 9? : sas-grid-administration
how do u validate the program which u have written.
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?
How does proc sql work?
Teradata 
