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 could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
what is the main difference between rename and label? (don't say that they both perform the same function).
what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What are the special input delimiters used in SAS?
What is the one statement to set the criteria of data that can be coded in any step?
Why is SAS considered self-documenting?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Name some categories in sas 9? : sas-grid-administration
What are the automatic variables for macro? : sas-macro
What is the function of output statement in a SAS Program?
What SAS statements would you code to read an external raw data file to a DATA step?