How do I CREATE an external dataset with sas code?

I would like to create within a sascode a non-exsistent
textfile on the host.
So I am not forced to create the file befor filling it.

Answer Posted / kumar

/*this is only for txt file*/
data _null_;
file print;
if _n_=1 then do;
put @5'name1'@10 name2';
put @5name1 @10name2;
end;

and for excel file

file kala dde 'path.xls';
data l;
infile kala;
input name1 name2;
run;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between using drop = data set option in data statement and set statement?

878


What is the difference between input and infile statement?

872


what is the primary data source for the wrs? : Sas-bi

858


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1677


What is the length assigned to the target variable by the scan function?

891


What are the applications primarily used by business analyst? : Sas-bi

749


how many types prompting framework can be broken down to? : Sas-bi

837


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3255


Explain proc univariate?

786


What are the different operating system platforms in which we can use sas? : sas-grid-administration

793


Describe the function and utility of the most difficult SAS macro that you have written?

2251


What is the maximum and minimum length of macro variable

905


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1986


How many data types are there in SAS?

808


What do the SAS log messages "numeric values have been converted to character" mean?

1090