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.
- 2 Answers
- 4331 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / temporarypostedname
I thought about sth like this:
Data _null_;
filename fileref <device-type>
dsnname='path'
run;
something like this buy it do not work.
and i would like to add BLK, DISP; UNIT SIZE
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is the difference between order and group variable in proc report?
describe about physical data integration? : Sas-di
Name statements that function at both compile and execution time?
Describe crosslist option in tables statement?
How would you determine how far down on a page you have printed in order to print out footnotes?
how do you debug and test your sas programs? : Sas programming
how to debug and test the sas program? : Sas-administrator
Why double trailing @@ is used in input statement?
what is the effect of the options statement errors=1? : Sas programming
Give e an example of..
What are the statements in proc sql?
what is snowflake schema? : Sas-di
Teradata 
