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: 
hinear
‎07-19-2017
  • 7 Posts
  • 6 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-18-2017 03:02 AM
‎07-18-2017 03:02 AM
    I finally contact sas support and they give a similar solution. the method is replace the carriage return and linefeed characters inside the double quotation mark by '@' and '$'   http://support.sas.com/kb/26/065.html     Thank you for all of your help. Otherwise, I don't even notice that there are <CR><LF> inside the file. ... View more

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-11-2017 06:05 AM
‎07-11-2017 06:05 AM
Sorry, I tried it, but it doesn't work   ERROR: The INFILE statement MISSOVER option and the INPUT statement double trailing @ option, are being used in an inconsistent manner. The execution of the DATA STEP is being terminated to prevent an infinite loop condition.   if I take out @@, the output is the same   ... View more

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-11-2017 02:02 AM
‎07-11-2017 02:02 AM
Unfortunately, my data has <CR><LF> in the end of each row.   "Row1" 123 24/09/2019 "A AAAAAAAAAAAAAAAAAAAAAAAAA<CR><LF> <CR><LF> BBBBBBBBBBBC<CR><LF> <CR><LF> CCCCCCCCCCCCCCCC" <CR><LF>   "Row2" 234 24/09/2019 "A AAAAAAAAAAAAAAAAAAAAAAAAA<CR><LF> <CR><LF> BBBBBBBBBBBC<CR><LF> <CR><LF> CCCCCCCCCCCCCCCC" <CR><LF>     I used your SAS code, but the output look like the following:-   var1 var2 var3 var4 Row1 123 2019-09-24 "A         BBBBBBBBBB               CCCCCCCCCC                               Row2 234 2019-09-24 "A         BBBBBBBBBB               CCCCCCCCCC       ... View more

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-10-2017 06:40 AM
‎07-10-2017 06:40 AM
Thank you very much, it is working. However, my data also contain some variables(number and date), which does not have open and close quotation mark.   For example: Content of the data (test.d) "Row1" 123 24/09/2019 "A AAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBC CCCCCCCCCCCCCCCC"   "Row2" 234 24/09/2019 "A AAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBC CCCCCCCCCCCCCCCC"   How to apply the same logic on it? ... View more

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-10-2017 04:45 AM
‎07-10-2017 04:45 AM
Unfortunately the file that I download from the Progress system is a .d file   I cannot change it to .csv or .txt  >..< ... View more

Re: How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-10-2017 03:48 AM
‎07-10-2017 03:48 AM
thz for reply, can you show me how to write a small C filter program please? ... View more

How to read a .d file with long character across multiple line?

by Fluorite | Level 6 in SAS Programming
‎07-10-2017 02:13 AM
‎07-10-2017 02:13 AM
Hi,   I got some problem when I am trying to import the .d data. The data contains a very long characters. Although it is covered by open and close quotation mark, SAS is not able to recognise it.   For example: Content of the data (test.d) "Row1" "A AAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBC CCCCCCCCCCCCCCCC"   "Row2"  "A AAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBC CCCCCCCCCCCCCCCC"         My SAS code :-   data test; %let _EFIERR_ = 0; infile "&ImportLocation.test.d" delimiter=' ' MISSOVER DSD lrecl=32767; informat  Var1 $ 4.  Var2 $ 999.; format Var1 $ 4. Var2 $ 999.; input  Var1 $ Var2 $ ; run;       Output  :- Var1            Var2 Row1           "A BBBB CCCC   Row2          "A BBBB CCCC     It is not able to read the full content inside Variables2, the open and close quotation mark is not working.   How can I adjust my SAS code to read the data in variables2?   Thz ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-19-2017 11:29 PM
Likes given to
Quick links