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
explain about data integrator metadata reports? : Sas-di
what r the job openings SAS for fresher graduates !
what is the effect of the options statement errors=1? : Sas programming
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
is data integration and etl programming is same? : Sas-di
What makes sas stand out to be the best over other data analytics tools?
what is data integration? : Sas-di
Tell e how how dealt with..
Explain the use of proc print and proc contents?
How would you determine the number of missing or nonmissing values in computations?
Have you ever used the SAS Debugger?
How to specify variables to be processed by the freq procedure?
how are numeric and character missing values represented internally? : Sas programming
What is program data vector (pdv)?
What is the difference between class statement and by statement in proc means?