topic DELIMITER ='01'X What is it? in SAS Programming

DELIMITER ='01'X What is it?

hellind — Tue, 07 Jun 2022 17:22:08 GMT

May I know what is the below delimiter character? I did a Google search, apparently it is 'Control A' character?

Then my question is how do I open the delimited exported file in Excel? What delimiter should I put for Data Import Wizard?

DBMS = "DLM"
REPLACE;
DELIMITER ='01'X;

Thanks.

Re: DELIMITER ='01'X What is it?

Reeza — Tue, 07 Jun 2022 18:00:33 GMT

'01'x is the hex code delimiter.

From the lookup table it seems to be Start of Header or ^A.

'09'x is a common one and means a tab.

https://www.techonthenet.com/ascii/chart.php

@hellind wrote:

May I know what is the below delimiter character? I did a Google search, apparently it is 'Control A' character?

Then my question is how do I open the delimited exported file in Excel? What delimiter should I put for Data Import Wizard?
DBMS = "DLM"
REPLACE;
DELIMITER ='01'X;
Thanks.

Re: DELIMITER ='01'X What is it?

Tom — Tue, 07 Jun 2022 18:03:20 GMT

If you are using the Get Data wizard

it should figure it out on its own.

Re: DELIMITER ='01'X What is it?

ballardw — Tue, 07 Jun 2022 18:09:02 GMT

If you want to create something that opens in Excel on EXPORT then first choice would be a COMMA delimiter. You don't show the file name or other options so can't go much farther than that.

Your question is pretty confused mixing "open in Excel" and "Data Import wizard". The export to Excel would imply that you already have a SAS data set and writing that data set out. If you are importing the data then you use whatever actual delimiter appears in the data file if there is one.

The '01'x is also a SOH character which with radio teletype meant "start of header" which was related to message traffic. Since the codes use for teletype are part of the basis for ASCII (one of the common character sets used in programming) then such characters are available.

Hint: Show entire procedure or data steps, not just part of the code.

Re: DELIMITER ='01'X What is it?

hellind — Wed, 08 Jun 2022 04:40:27 GMT

The SAS script is a production code that exports the SAS dataset to text file using that '01'x delimiter which is then ingested by technology.

IT department had requirement to use '01'x as delimiter, therefore I can't change the type of delimiter to use. I prefer to use TAB as delimiter.

I wanted to do investigation in Excel and was trying to figure out what HEX code to center into the Excel -> Get External Data --> Text Import Wizard

Re: DELIMITER ='01'X What is it?

hellind — Wed, 08 Jun 2022 04:44:20 GMT

Excel -> Get External Data --> Text Import Wizard was not able to auto-detect the delimiter.

But Get Data -> From File was able too.

Thanks.