topic Re: Minus sign in proc sql for macro variables in SAS Programming

Minus sign in proc sql for macro variables

DmytroYermak — Wed, 15 Apr 2020 08:46:50 GMT

Hi all,

Can you please explain what is the role of minus sign in the code below:

proc sql noprint;
  select paramcd, frmt_min, frmt_mean, frmt_sd, count(paramcd)
  into :param_1- ,
       :frmt_min_1- ,
       :frmt_mean_1- ,
       :frmt_sd_1- ,
       :nparams trimmed
  from frmt_final;
quit;

Thank you!

Re: Minus sign in proc sql for macro variables

Kurt_Bremser — Wed, 15 Apr 2020 09:00:34 GMT

It means "create as many numbered macro variables as needed". If the query results in three rows, you'll have param_1, param_2, param_3, and equally three macro variables for the other columns.

Re: Minus sign in proc sql for macro variables

DmytroYermak — Wed, 15 Apr 2020 09:02:28 GMT

Thank you!