Hello SAS Experts,
I get data via an XLSX import that contains the HEX symbol A0 or , it looks like a space, but istn.
How can I remove this "fake" space?
So far this did not work:
proc sql;
CREATE TABLE _testtest AS
SELECT
TRANWRD (CN,' ',''),
COMPRESS (CN),
CN
FROM xxx;
QUIT;
Bye
John
You're on the right track. Try the modifiers with the COMPRESS function, specifically S:
COMPRESS (CN, , 's'),
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. |
Hi Reeza,
I tried but it did not work:
proc sql;
CREATE TABLE testtest AS
SELECT
COMPRESS (CN, , 'S'),
CN
FROM xxx ;
QUIT;
I added a screen print. Tried with capital and non-cap S.
Create a new column with double the length of the original column and use the $HEXw. format to convert to hexadecimal representation, so you can see the offending character codes.
Hi Kurt,
Its A0 and tons of spaces 20.
I attached a new screen print.
proc sql;
CREATE TABLE test AS
SELECT
COMPRESS (CN, , 's'),
CN
FORMAT=$HEX26.
FROM xxxx ;
QUIT;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.