Hi,
Prompt variable: PMTSELECTCOLS with below multiple static list values
CALC_GLOBAL_KEY_QTY
CALC_REGION_KEY_QTY
CALC_CUSTOMER_KEY_QTY
ADJ_GLOBAL_KEY_QTY
ADJ_REGION_KEY_QTY
ADJ_CUSTOMER_KEY_QTY
SELECTED_KEY_QTY
Currently below transpose is hardcoded with all columns eventhough if we are selecting few input values from above prompt.
but we need to give dynamic variables in BY and VAR stmt based on selected input prompt values
PROC TRANSPOSE DATA=temp_report_s
OUT=temp_report_transposed
PREFIX=Column
NAME=Source
LABEL=Label
;
BY CYCLE_DT CALC_GLOBAL_KEY_QTY CALC_REGION_KEY_QTY CALC_CUSTOMER_KEY_QTY T_FORECAST_PERIOD_DT;
VAR ADJ_GLOBAL_KEY_QTY ADJ_REGION_KEY_QTY ADJ_CUSTOMER_KEY_QTY SELECTED_KEY_QTY
;
RUN;
proc print label data=report_transposed noobs width=full ;
run;
when i choose only one value, i am getting macro variable PMTSELECTCOLS1 is not resolved. i tried with many ways (double quotes "&&PMTSELECTCOLS&I", single quotes '&&PMTSELECTCOLS&') to resolve thIS macro variable. Could you please help me to get the correct report layout
%macro test1;
PROC TRANSPOSE DATA=ddf_cont.temp_report_s
OUT=report_transposed
PREFIX=Column
NAME=Source
LABEL=Label
;
BY CYCLE_DT
%do i=1 %to &PMTSELECTCOLS_COUNT;
%IF %SUBSTR(&&PMTSELECTCOLS&I,1,4) EQ "CALC" %THEN
&&PMTSELECTCOLS&I;
%END; T_FORECAST_PERIOD_DT;
VAR %do i=1 %to &PMTSELECTCOLS_COUNT;
%IF %SUBSTR(&&PMTSELECTCOLS&I,1,4) NE "CALC" %THEN
&&PMTSELECTCOLS&I;
%END;
;
RUN;
proc print label data=report_transposed noobs width=full ;
run;
%mend;
%test1;
I found a problem in your code. Macro is text process language. You don't need double quote around character value.
"CALC" --------------> CALC
Ksharp
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.