Date:         Tue, 17 Feb 2009 17:07:24 -0500
Reply-To:     Marianne Weires <m.weires@DKFZ.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Marianne Weires <m.weires@DKFZ.DE>
Subject:      Re: proc sql and %TRIM
Comments: To: Chang Chung <chang_y_chung@HOTMAIL.COM>

Hi,

@Chang: Thanks for your example.
In my example I was not using any quoted leading blanks:
...
PROC SQL NOPRINT;
    SELECT COUNT(proj_name) INTO :anz_vname FROM projekt;

   SELECT proj_name INTO :vname1-:vname%TRIM(&anz_vname) NOTRIM
FROM projekt;


Not specifying  NOTRIM will automatically strip the variables for a macro
var array (-> no need for the strip() function).
But I still do not understand why %TRIM is trimming the leading blanks from
anz_vname.

Regards,
Marianne