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.
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 |
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what is the use of catalog?
What is the purpose of _character_ and _numeric_?
What is factor analysis?
What is difference between (a-z) and (a--z)
What are the different servers in sas? : sas-grid-administration
What sas features do you use to check errors and data validation?
how to assign a macro value to a variable?
How experienced are you with customized reporting and use of Data _Null_ features?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
what are the component of range? : Sas-bi
How would you define the end of a macro?