Date:         Fri, 28 Apr 2000 11:47:45 -0700
Reply-To:     "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Subject:      SQL Into -- Rhetorical Question
Content-Type: text/plain

SQL Into -- Rhetorical Question


IF YOU CAN HAVE TRIM---for a concatenated list---
     into :mvar separated ','

AND YOU CAN HAVE NOTRIM---for a concatenated list---
     into :mvar separated ',' NOTRIM


IF YOU CAN HAVE TRIM---for an array---
     into :mvar1-:mvar1000

AND YOU CAN HAVE NOTRIM---for an array---
     into :mvar1-:mvar1000 NOTRIM


IF YOU CAN HAVE NOTRIM---for a single---
     into :mvar

WHY CAN'T WE HAVE TRIM---for a single---???????
     select desc into :mvar TRIM
or
     select trim(desc) into :mvar
[Rhetorical Question--Wish List--Suggestion Box?]

Hmmmmm......



Examples(6.12or8.00):


proc sql noprint;
   select distinct level2 into :mvar separated by ','
   from sashelp.company;
quit;  %put mvar: >&mvar<;

proc sql noprint;
   select distinct level2 into :mvar separated by ',' notrim
   from sashelp.company;
quit;  %put mvar: >&mvar<;


proc sql noprint;
      select distinct level2 into :v1-:v10000
      from sashelp.company;
quit;  %put hub1 is >&v1<;

proc sql noprint;
      select distinct level2 into :v1-:v10000 notrim
      from sashelp.company;
quit;  %put hub1 is >&v1<;


proc sql noprint;
   select level2 into :mvar
   from sashelp.company
   where level5 eq 'So Suumi';
quit;  %put mvar: >&mvar<;

    * Undesired Result ;
proc sql noprint;
   select level2 into :mvar trim
   from sashelp.company
   where level5 eq 'So Suumi';
quit;  %put mvar: >&mvar<;

    * Undesired Result ;
proc sql noprint;
   select trim(level2) into :mvar
   from sashelp.company
   where level5 eq 'So Suumi';
quit;  %put mvar: >&mvar<;


Just Pondering,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
(360) 902-0741
(360) 902-0705 fax
mailto:terjemw@dshs.wa.gov