Answer / 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....

Answer / poojavaibhav

A "flat file" is a plain text or mixed text and binary file which usually contains one record per line[2] or 'physical' record (example on disc or tape). Within such a record, the single fields can be separated by delimiters, e.g. commas, or have a fixed length. In the latter case, padding may be needed to achieve this length. Extra formatting may be needed to avoid delimiter collision. There are no structural relationships between the records.


You can use Import wizard or import procedure or infile statement to create sas dataset and then use file statement to write file in log.

Answer / paul

A flat file from mainframes generally have data values assigned with the variable names.
eg: cards;
name=XXX Age=XX Gender=XXXX
name=XXX Age=XX Gender=XXXX
name=XXX Age=XX Gender=XXXX
name=XXX Age=XX Gender=XXXX
;
so to read such data into SAS we simply use named input method.
data flat;
infile 'flatfile.csv';
input var1= $ var2= var3= :ddmmyy10. var4= ;
run;
/*here i specified var1 as char, var3 with date informat
rest are numeric vars */

What are the criticality that you have faced during your project in SAS?

2 Answers  

---

How would you remove a format that has been permanently associated with a variables?

3 Answers  

---

how to change the execute of macro

0 Answers   Mind Tree,

---

What does proc print, and proc contents are used for?

0 Answers  

---

Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?

4 Answers  

---

What do the put and input function do?

0 Answers  

---

how will you location sas platform applications available from web browser? : Sas-bi

0 Answers  

---

What is the difference between using drop = data set option in data statement and set statement?

0 Answers  

---

how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

---

what are the three main credit bureau names

1 Answers   Synchrony Financial,

---

What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,

---

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

---