topic Re: How to distinguish space with TAB in raw data? in SAS Programming

How to distinguish space with TAB in raw data?

sas_newbie3 — Sun, 10 Sep 2017 18:32:33 GMT

In data step, I have to check whether the delimiter is space or tab. When I open the file with notepad. It can't distinguish space and TAB.

My question is "How to distinguish space with TAB in raw data?"

I use spread sheet to open it first then identify the delimiter. Is there any way to examine it?

Re: How to distinguish space with TAB in raw data?

AlanC — Sun, 10 Sep 2017 18:01:39 GMT

I use an advanced editor such as UltraEdit to see them. You can also do the same inNotepad++ or use Word and show control characters.

HTH

Re: How to distinguish space with TAB in raw data?

novinosrin — Sun, 10 Sep 2017 18:13:39 GMT

Did you try expandtabs:-

/*example*/

data have;
infile 'C:\Users\NSRINIV2\Desktop\tabandspace.txt' expandtabs truncover firstobs=2;
input a b c;
run;

Re: How to distinguish space with TAB in raw data?

sas_newbie3 — Sun, 10 Sep 2017 18:33:41 GMT

Sorry for confusion. I edited the question. I want to know whether the delimiter is space or tab rather then set it.

Re: How to distinguish space with TAB in raw data?

novinosrin — Sun, 10 Sep 2017 18:46:55 GMT

Ok, To check whether a value is delimited with space or tab, the only way that I can think of is(in a datastep) to logically check how may bytes of space the input pointer moved from the end of one value to another. So, you could use col= option to read where the input pointer is once a value is read and the where the new value begins.

Next, you take the difference. I suppose a tab must have a constant number of bytes that is consistent globally. So if the difference matches that constant, you take that as tab demilited

Re: How to distinguish space with TAB in raw data?

Kurt_Bremser — Sun, 10 Sep 2017 18:58:57 GMT

The tab character can be noted in SAS as '09'x. You could run a preliminary data step that checks for the presence of that character, and sets it as a macro variable which can be used as the delimiter in the main input data step.

Re: How to distinguish space with TAB in raw data?

Tom — Sun, 10 Sep 2017 20:24:33 GMT

Just look for tab characters in the file.

data _null_;
  infile 'myfile.txt' obs=1;
  input ;
  if index(_infile_,'09'x) then put 'There are tabs in this file';
run;