topic Re: data transoding in SAS Programming

data transoding

ajulio4 — Fri, 25 Oct 2024 16:19:20 GMT

Hello ,

I have an issue can someone help me.

I have a colonne value like this :

var ="USERNUM1,	Counter{F}Compteur				,
USERTEXT1,	Trigram{F}Trigramme				,ALL~All{F}Tous	GBR~GBR{F}GBR	ITA~ITA{F}ITA"

Notice that after the commaas, i have tabulate.

how can i have as result :

var = "USERNUM1,Counter{F}Compteur,USERTEXT1,Trigram{F}Trigramme,ALL~All{F}Tous GBR~GBR{F}GBR ITA~ITA{F}ITA"

Re: data transoding

ballardw — Fri, 25 Oct 2024 17:24:41 GMT

See if this works to remove tab characters for you:

data test;
   set yourdatsetname;
   newvar = compress(var,,'h');
run;

The two commas in the parameters for the Compress function means you are not supply a character to remove by typing it. The 'h' adds the horizontal tab character to the list of characters to remove, so the above should only remove horizontal tab characters.

Re: data transoding

Ksharp — Sat, 26 Oct 2024 07:22:35 GMT

Also try to remove the newline characters.

data test;
   set yourdatsetname;
   newvar = compress(var,'0D0A'x,'s');
run;

Re: data transoding

Patrick — Sat, 26 Oct 2024 12:42:43 GMT

It looks to me that the compress() function s modifier should remove the characters you don't want.

newar=compress(var,,'s');

COMPRESS Function

s or S adds space characters (blank, horizontal tab, vertical tab, carriage return, line feed, form feed, and NBSP ('A0'x, or 160 decimal ASCII) to the list of characters.

Re: data transoding

ajulio4 — Sun, 27 Oct 2024 09:02:55 GMT

Thks so much