Answer Posted / sastechies

I would use FileName FTP statement...

FILENAME FILE2 FTP 'PDSNAME' HOST='host'
CD= "'dir'"
user='user'
pass='pass'
lrecl=256
debug;

data _NULL_;
infile FILE2 lrecl=26095;
file "file.txt" lrecl=3000 pad;
input;
put _infile_;
run;


Any other method....

for what purpose would you use the retain statement? : Sas programming

687

---

List down the reasons for choosing sas over other data analytics tools.

910

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

652

---

How you can read the variables that you need?

749

---

Why double trailing @@ is used in input statement?

831

---

---

What are the statements that are executed only?

774

---

how can you put a "trace" in your program? : Sas programming

681

---

What is the difference between %put and symbolgen? : sas-macro

771

---

What is the difference between nodupkey and nodup options?

682

---

what is hash files in sas and why we are using this one in sas?

1817

---

explain the concepts and capabilities of business object? : Sas-bi

628

---

how are numeric and character missing values represented internally? : Sas programming

725

---

How can sas program be validated?

661

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1914

---

What system options would you use to help debug a macro? : sas-macro

738

---