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
- 15383 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 |
In ARRAY processing, what does the DIM function do?
What do the put and input function do?
Which of the following is not created during compilation phase?
What is the difference Using & and && in the macro variables
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
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?
I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
What is the difference between using drop = data set option in data statement and set statement?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
What is SAS Information Map Studio and its purpose ?
Teradata 
