topic Re: %str() understanding in SAS Programming

%str() understanding

David_Billa — Tue, 31 Jan 2023 05:14:13 GMT

May I know the meaning of %str( ) in below %do loop and %let statement?

  /* Drop unwanted fields from the tables */
   %let l_i=1;
   PROC SQL NOPRINT;
   %do %until(%scan(&l_freqDs,&l_i, %str( )) EQ );
      %let l_dsName =%scan(&l_freqDs,&l_i, %str( ));
      %let l_varName= %scan(&l_tables,&l_i, %str( ));
      ALTER TABLE &l_dsName  DROP &l_varName;
      %let l_i=%eval(&l_i + 1);
   %end;
   QUIT;

Re: %str() understanding

Kurt_Bremser — Tue, 31 Jan 2023 05:24:13 GMT

Since the macro language strips blanks from values, you must use the %STR macro function to feed a blank to the SCAN.

Re: %str() understanding

David_Billa — Tue, 31 Jan 2023 05:28:28 GMT

@Kurt_Bremser Won't the SCAN function consider blank as default delimiter without we being explicitly adding %str()?

Re: %str() understanding

Astounding — Tue, 31 Jan 2023 08:49:07 GMT

Yes, blanks are included as default delimeters. However, periods are also included (and would appear in any list of data sets that includes permanently saved data sets). So the code ensures that blanks are delimiters but periods are not.