cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ssbbmm
‎09-11-2018
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Filename FTP to Mainframe

by Calcite | Level 5 in SAS Programming
‎09-07-2018 02:41 AM
‎09-07-2018 02:41 AM
Much appreciate KurtBremser.   I just sent another version with your suggested method by adding EBCDIC and kept  recfm=s.. It seems a success from my end but have to wait our vendor to check tomorrow morning.   Thanks again! I will keep you posted.   ... View more

Re: Filename FTP to Mainframe

by Calcite | Level 5 in SAS Programming
‎09-07-2018 02:21 AM
‎09-07-2018 02:21 AM
Thanks One clarification I wanted to make is that - the text file was created in SAS EG on Unix SAS with following code:   DATA _null_;                                                                    SET movement; FORMAT EVENT_DT    YYMMDD10.;                                          File "&OUT/MOVEMENT_3M_&FiscaL_Period._&Rundate..txt" lrecl=150; If _N_=1  then Do;                                                              H1    =    'Fiscal Period'; H2    =    'Employee ID'; h3    =    'Date'; h4    =    'Type'; h5    =    'Action';                              Put     %OUTPUT_HEADER(COUNT=4) H5; End;      Put     FiscaL_Period    +(-1) '|'         EMPLID        +(-1) '|'         EVENT_DT     +(-1) '|'         EVENT_TYPE    +(-1) '|'         ACTION ;   Run;   I was assuming the file created was ASCII. ... View more

Re: Filename FTP to Mainframe

by Calcite | Level 5 in SAS Programming
‎09-07-2018 01:25 AM
‎09-07-2018 01:25 AM
Thanks ChrisNZ for your response. My SAS server (Source) is Unix Server. Unfortunately I don't have a lot know knowledge on Mainframe. Can Mainframe accept the file in ASCII?   Thanks again! ... View more

Filename FTP to Mainframe

by Calcite | Level 5 in SAS Programming
‎09-06-2018 11:49 PM
‎09-06-2018 11:49 PM
I need to FTP a Pipeline delimited Text file from SAS server to our Mainframe Server then to outside vendor. Since on the mainframe it got set up to receive Binary file so I have the following program:   filename Mov "/apps/sas/datasets/data142/Reports/MOVEMENT_3M_&FiscaL_Period._&Rundate..txt"; filename pmggdg ftp  "'PBCSECDI.EDIPH925.HOLD(+1)'" debug binary            user="KS*****" host="********" pass="*******"         lrecl=62  RCMD='SITE lrecl=62 recfm=s'; data _null_;   infile Mov lrecl=62;   file pmggdg  lrecl=62 ;   input; put _infile_ ; run; filename Mov clear; filename pmggdg clear;   The file was successfully sent to the vendor but it lost the original format which is pipe delimited and was changed to Tab delimited.   What should I do when I FTP in Binary and not losing the original format?   Thanks so much,   SSBBmm ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-11-2018 05:04 PM
Quick links