topic Re: To remove laeding and trailing spaces in Proc SQL ? in SAS Programming

To remove laeding and trailing spaces in Proc SQL ?

AshokD — Thu, 25 Oct 2018 10:26:21 GMT

Hi All,

In data step we have STRIP function which removes leading and trailing spaces.

Do we have any similar function in Proc SQL ?

Please share your thoughts.

Re: To remove laeding and trailing spaces in Proc SQL ?

RW9 — Thu, 25 Oct 2018 10:28:33 GMT

Yes. If your using the inbuilt SQL parser in SAS then that parser can use SAS functions. If your passing through the SQL statement to a database, then you would need to use functions that the database knows in your code rather than SAS functions.

Re: To remove laeding and trailing spaces in Proc SQL ?

PeterClemmensen — Thu, 25 Oct 2018 10:29:40 GMT

You can use the Strip Function in PROC SQL as well

data test1;
string="     Hello  ";
run;

proc sql;
   create table test2 as
   select strip(string) as newstring
   from test1;
quit;

Re: To remove laeding and trailing spaces in Proc SQL ?

AshokD — Thu, 25 Oct 2018 10:52:24 GMT

@PeterClemmensen @RW9 Thanks for your time and suggestion. It work's fine.

Re: To remove laeding and trailing spaces in Proc SQL ?

ajs_rdg — Wed, 02 Oct 2019 13:35:30 GMT