topic Re: Please help me to resolve below code in SAS Programming

Please help me to resolve below code

ankitk321 — Tue, 11 Sep 2018 11:56:23 GMT

%let DATA_PULL_TYPE=NA/Dummy

%macro datapultyp_chng;

%let DATAPULLTYPES= %sysfunc(compress("&DATA_PULL_TYPE"," "));

%If %Upcase(&DATAPULLTYPES.) = BLINDED %then %do;

%let DataPullType= 'Real(BlindBreak)';

%end;

%else %If %Upcase(&DATAPULLTYPES.) = UNBLINDED %then %do;

%let DataPullType= 'Real(Unblinded)';

%end;

%else %If %nrstr(%Upcase(&DATAPULLTYPES.)) = NADUMMY %then %do;

%let DataPullType= 'NA/Dummy';

%end;

%put &DataPullType;

%mend datapultyp_chng;

%datapultyp_chng;

*I am geeting error in resolving the above mentioned code;

Re: Please help me to resolve below code

PeterClemmensen — Tue, 11 Sep 2018 11:57:04 GMT

post your log please

Re: Please help me to resolve below code

ankitk321 — Tue, 11 Sep 2018 12:03:50 GMT

63 %let DATA_PULL_TYPE=NA/Dummy;

65 %macro datapultyp_chng;

66 %let DATAPULLTYPES= %sysfunc(compress("&DATA_PULL_TYPE"," "));

67 %If %Upcase(&DATAPULLTYPES.) = BLINDED %then %do;

68 %let DataPullType= 'Real(BlindBreak)';

69 %end;

70 %else %If %Upcase(&DATAPULLTYPES.) = UNBLINDED %then %do;

71 %let DataPullType= 'Real(Unblinded)';

72 %end;

73 %else %If %nrstr(%Upcase(&DATAPULLTYPES.)) = NADUMMY %then %do;

74 %let DataPullType= 'NA/Dummy';

75 %end;

76 %put &DataPullType;

77 %mend datapultyp_chng;

78 %datapultyp_chng;

MLOGIC(DATAPULTYP_CHNG): Beginning execution.

MLOGIC(DATAPULTYP_CHNG): %LET (variable name is DATAPULLTYPES)

SYMBOLGEN: Macro variable DATA_PULL_TYPE resolves to NA/Dummy

SYMBOLGEN: Macro variable DATAPULLTYPES resolves to NA/Dummy

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:

%Upcase(&DATAPULLTYPES.) = BLINDED

ERROR: The macro DATAPULTYP_CHNG will stop executing.

MLOGIC(DATAPULTYP_CHNG): Ending execution.

80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE;

Re: Please help me to resolve below code

PaigeMiller — Tue, 11 Sep 2018 12:15:11 GMT

Use

%if %qupcase(&datapulltypes) = BLINDED %then %do;

This is required if your macro variable (in this case &datapulltypes) contains certain special characters (in this case the slash)

Re: Please help me to resolve below code

ankitk321 — Tue, 11 Sep 2018 12:26:40 GMT

No not working 😞

Re: Please help me to resolve below code

PaigeMiller — Tue, 11 Sep 2018 12:40:12 GMT

Works for me.

Re: Please help me to resolve below code

ankitk321 — Tue, 11 Sep 2018 12:43:23 GMT

My bet, Thanks you are right its working. Thaks a ton for your help