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: 
ChrisO147
‎02-25-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: CR & Blank Lines in CSV External File - DI Studio

by Calcite | Level 5 in SAS Data Management
‎02-25-2019 10:05 AM
‎02-25-2019 10:05 AM
Thank you Patrick   I will attach a copy of the file, once I have stripped out any sensitive information.   In the meantime, I will see assistance from my learned SAS colleagues on-site. ... View more

Re: CR & Blank Lines in CSV External File - DI Studio

by Calcite | Level 5 in SAS Data Management
‎02-25-2019 03:23 AM
‎02-25-2019 03:23 AM
Thank you   It seems that something that is so straightforward in EG, is not straightforward in DI. ... View more

Re: CR & Blank Lines in CSV External File - DI Studio

by Calcite | Level 5 in SAS Data Management
‎02-25-2019 03:23 AM
‎02-25-2019 03:23 AM
Thank you for your "imho" response Patrick   Notwithstanding the fact that I have little experience in coding, I have attended the SAS programming basics course.   However, as responses have confirmed, the format of the file is not perfect and I am asking for help in overcoming this issue. If you have any suggestions, other than to tell me to attend courses, they would be appreciated.     ... View more

Re: CR & Blank Lines in CSV External File - DI Studio

by Calcite | Level 5 in SAS Data Management
‎02-21-2019 10:56 AM
‎02-21-2019 10:56 AM
Thank you for your reply Tom As I said in my post, I don't program or understand programming... I want to use the "New, External File" function within DI Studio and, if necessary, add a bit of code. My only other alternative would be to Import it as Excel.. Very frustrating for something that can be done so easily using Enterprise Guide but fails, or is extremely complicated, when trying to do the same in DI Studio ... View more

CR & Blank Lines in CSV External File - DI Studio

by Calcite | Level 5 in SAS Data Management
‎02-21-2019 10:27 AM
‎02-21-2019 10:27 AM
I am trying to create a new external file from a csv using DI Studio 4.901. I am not a programmer, nor do I understand how to write code. The csv file contains CR in the headers and both CR and blank lines in some of the fields, which causes issues...bumping text to the right and therefore ending up with the data all skewed. I have almost managed to solve the header problem by using TERMSTR=CRLF but, for some strange reason, the headers stop suddenly in the middle of a column name... In addition, some of the columns have CR and Blanks....e.g. all the attached is supposed to be in one cell   Your help would be appreciated but please keep the tech speak to a minimum 😞   thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-25-2019 10:37 AM
Quick links