View previous topic :: View next topic
|
Author |
Message |
Rodger Zhang
New User
Joined: 04 Jul 2016 Posts: 3 Location: Canada
|
|
|
|
Hi there,
Retrieve and output a file in Mainframe using SAS. Various special characters appear in front of some character strings which shift the position of the columns. Looked at mainframe output file, it's empty (space) in EDIT mode but dots can be seen in BROWSER mode. Detail can be seen from attachment.
Any help is appreciated.
Thanks. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Welcome!!
How did you download it with what options? Next time, please paste here the code and wrap under the code tags which will preserve space than uploading.
This is not a DFSORT question, is it? May need to be moved to 'All Other Mainframe Topics' |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Did you look at the data in hex mode (EDIT or BROWSE)? Are they different characters or the same character? Do you know if they are in the original source or just appear after the SAS program runs? |
|
Back to top |
|
|
Rodger Zhang
New User
Joined: 04 Jul 2016 Posts: 3 Location: Canada
|
|
|
|
Thanks everyone.
Viewed with HEX ON, the same - it's a empty (space) in EDIT mode and dot (.) in BROWSER mode. It probably has something to do with the format, but can't figure it out by googling.
Thanks.
Rodger |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
I think you may be need to see for SAS character Encoding options or colition Capabilities used during the download. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
Viewed with HEX ON, the same - it's a empty (space) in EDIT mode and dot (.) in BROWSER mode. |
If this is true, there is something SERIOUSLY wrong. Here is a couple of lines in EDIT mode:
Code: |
Command ===> Scroll ===> CSR .
000210 //* ëëç.....(Ñ>ÀèÁÊ_¬.....(Ñ>ÀÂÊÑÅÇÈ.ëëç.. .
000300 // .
****** **************************** Bottom of Data **************************** . |
and the same two lines with HEX ON:
Code: |
Command ===> Scroll ===> CSR
000210 //* ëëç.....(Ñ>ÀèÁÊ_¬.....(Ñ>ÀÂÊÑÅÇÈ.ëëç..
665455444444466656765444444666676667455444444444444444444444444444444444
11C0338BBBBBD9E4452DFBBBBBD9E4229784B338BB000000000000000000000000000000
------------------------------------------------------------------------------
000300 //
664444444444444444444444444444444444444444444444444444444444444444444444
110000000000000000000000000000000000000000000000000000000000000000000000
------------------------------------------------------------------------------
****** **************************** Bottom of Data **************************** |
If you turned HEX ON, you should be seeing the hexadecimal representations of the data -- in BROWSE or EDIT mode. If you are not, as I said there is something SERIOUSLY wrong and you need to contact your site support group IMMEDIATELY for assistance. |
|
Back to top |
|
|
Rodger Zhang
New User
Joined: 04 Jul 2016 Posts: 3 Location: Canada
|
|
|
|
Thanks.
As some of the dots in front of the fields turn to be strange characters after downloading, I tried and tested moving the position from source file. It seemed that I got the right values after moving 2 positions further right than the layout specified. So I think we are good now.
Thanks again for everyone's advice and contribution. Much appreciated.
Rodger |
|
Back to top |
|
|
|