How do you download a flat file from Mainframe to your
local PC using SAS?
Answer Posted / 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 */
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is intially documentation in sas?
What is the sas data set? : sas-grid-administration
name some data transformation used in sas di? : Sas-di
for report generation which one you used proc report or data_null_?
what do you mean by data staging area? : Sas-di
What are the applications primarily used by business analyst? : Sas-bi
what is function of retain statment
what are some differences between proc summary and proc means? : Sas programming
Mention common programming errors committed in sas ?
What Proc glm does?
what is the use of sas management console? : Sas-di
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What is the difference between input and infile statement?
What is the use of the %include statement?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di