Interested to Buy Any Domain ? << Click Here >> for more details...
What statement do you code to tell SAS that it is to write
to an external file?
- 5 Answers
- 15598 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 about data integrator metadata reports? : Sas-di
Are you sensitive to code walk-throughs peer review or QC review?
How do you put an elephant in the refrigerator?
what is the main difference between rename and label? (don't say that they both perform the same function).
What are the different versions of sas that you have used until now? : sas-grid-administration
how many types of prompts are there? : Sas-bi
how to handle in stream data containing semicolon in it?
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
What are the difference between sas functions and procedures?
What is proc sort?
What is the command used to find missing values?
Given an unsorted data set, how to read the last observation to a new data set?
Teradata 
