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 |
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the statements in proc sql?
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
What is the purpose of _character_ and _numeric_?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
List down the reasons for choosing sas over other data analytics tools.
Describe the ways in which you can create macro variables? : sas-macro
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
how do we mail reports from SAS environment to our team leader