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



How do I CREATE an external dataset with sas code? I would like to create within a sascode a non..

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

How do I CREATE an external dataset with sas code? I would like to create within a sascode a non..

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

Post New Answer

More SAS Interview Questions

explain the proc in sas? : Sas-administrator

0 Answers  


What does PROC print, and PROC contents do?

0 Answers  


what is the use of proc contents and proc print in sas? : Sas-administrator

0 Answers  


what is slowly changing dimension? : Sas-di

0 Answers  


What are the table names in oracle database...?

0 Answers   HSBC,


explain the difference between proc means and proc summary?

0 Answers  


What other SAS features do you use for error trapping and data validation?

2 Answers  


What is the use of the %include statement?

0 Answers  


what is enterprise guide? What is the use of it? : Sas programming

0 Answers  


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

0 Answers  


what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,


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;

2 Answers   HSBC,


Categories