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 what is SAS informats?
Explain what Proc glm does?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What do you code to create a macro? : sas-macro
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How do you use the do loop if you don’t know how many times you should execute the do loop?
How are numeric and character missing values represented internally?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is metadata? : Sas-bi
what are the considerations when picking a SAS/STAT procedure?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is by-group processing?
In ARRAY processing, what does the DIM function do?