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 |
how does sas handle missing values in a merge? : Sas programming
how many types prompting framework can be broken down to? : Sas-bi
What is the difference between order and group variable in proc report?
Which is the best training institute for SAS in Delhi. Please reply
how can you import .csv file in to sas? : Sas programming
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
I have a dataset with variables empid and doj how to calculate retirement age?
What is the basic structure of a sas program?
How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.
Mention some common errors that are usually committed in sas programming.
How do you add a prefix to some or all variables in a dataset using a SAS macro?
Do you know the features of sas?