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


Please Help Members By Posting Answers For Below Questions

explain about data integrator metadata reports? : Sas-di

658


what r the job openings SAS for fresher graduates !

2102


what is the effect of the options statement errors=1? : Sas programming

687


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

809


is data integration and etl programming is same? : Sas-di

678






What makes sas stand out to be the best over other data analytics tools?

678


what is data integration? : Sas-di

728


Tell e how how dealt with..

1869


Explain the use of proc print and proc contents?

635


How would you determine the number of missing or nonmissing values in computations?

738


Have you ever used the SAS Debugger?

1322


How to specify variables to be processed by the freq procedure?

716


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

725


What is program data vector (pdv)?

735


What is the difference between class statement and by statement in proc means?

762