Minus sign in proc sql for macro variables

[DmytroYermak]

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!

[Kurt_Bremser · Accepted solution]

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.

[DmytroYermak]

Thank you!