07-20-2012 07:09 AM
The attached file contains one column and 25 rows. The length of the string in the column is 16, but the format is given as $30.
When I try to export the dataset into .csv or any other format, the strings get broken into two parts and make 50 rows.
Can some please help me exporting the string intact ?
My Contact number is +91 - 9711913925
Skype id is rajat.musigma
email - email@example.com
07-20-2012 08:18 AM
You appear to have an embedded linefeed ( ''0A'x ) in each string. That is why it is displaying as two line on the export ('0A'x is the end-of-line character in Unix and many PC programs also interpret it that way.
If the hex output for your first line of data (note the '0A').
07-20-2012 09:17 AM
Thanks a lot for the insight. I was expecting something like an "Enter key" embedded within the string. It very much explains the issue.
Could you please suggest me a way to remove this ( ''0A'x ) from the string, as I need to extract data in the intact form ?
Also, could you please help me how to get the hexadecimal of the string/number in SAS.
Thanks a lot,
07-20-2012 10:43 AM
To display the hex representation of a character string, I simply applied the $hex format to it. You can read about that in the documentaiton.
To remove the control characters from a string, use the COMPRESS function. See
or the documentation for exact syntax.