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 |
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
What is the difference between informat and format statement?
how to read raw data in sas. Do it manually and throw the programming.
What is the function of Stop statement in a SAS Program?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What is the function of output statement in a SAS Program?
How do you use the do loop if you don’t know how many times you should execute the do loop?