I have this code: options symbolgen mprint mlogic; %let cnt_id_groups=5; %let cnt_Id_value_groups=8; %macro dummy; %do i = 1 %to &cnt_id_groups.; %do j=1 %to &cnt_Id_value_groups.; %let value_&i._&j=; %end; %end; %mend dummy; %dummy; %PUT VALUE_4_4=&VALUE_4_4; %PUT VALUE_5_8=&VALUE_5_8; Why would i not get the value for macro -- value_5_8? what should i do? Here is the log: 28 options symbolgen mprint mlogic; 29 %let cnt_id_groups=5; 30 %let cnt_Id_value_groups=8; 31 %macro dummy; 32 %do i = 1 %to &cnt_id_groups.; 33 %do j=1 %to &cnt_Id_value_groups.; 34 %let value_&i._&j=; 35 %end; 36 %end; 37 %mend dummy; 38 %dummy; MLOGIC(DUMMY): Beginning execution. SYMBOLGEN: Macro variable CNT_ID_GROUPS resolves to 5 MLOGIC(DUMMY): %DO loop beginning; index variable I; start value is 1; stop value is 5; by value is 1. SYMBOLGEN: Macro variable CNT_ID_VALUE_GROUPS resolves to 8 MLOGIC(DUMMY): %DO loop beginning; index variable J; start value is 1; stop value is 8; by value is 1. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 1 MLOGIC(DUMMY): %LET (variable name is VALUE_1_1) MLOGIC(DUMMY): %DO loop index variable J is now 2; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 2 MLOGIC(DUMMY): %LET (variable name is VALUE_1_2) MLOGIC(DUMMY): %DO loop index variable J is now 3; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 3 MLOGIC(DUMMY): %LET (variable name is VALUE_1_3) MLOGIC(DUMMY): %DO loop index variable J is now 4; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 4 MLOGIC(DUMMY): %LET (variable name is VALUE_1_4) MLOGIC(DUMMY): %DO loop index variable J is now 5; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 5 MLOGIC(DUMMY): %LET (variable name is VALUE_1_5) MLOGIC(DUMMY): %DO loop index variable J is now 6; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 6 MLOGIC(DUMMY): %LET (variable name is VALUE_1_6) MLOGIC(DUMMY): %DO loop index variable J is now 7; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 7 MLOGIC(DUMMY): %LET (variable name is VALUE_1_7) MLOGIC(DUMMY): %DO loop index variable J is now 8; loop will iterate again. 3 The SAS System 09:54 Thursday, March 21, 2024 SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable J resolves to 8 MLOGIC(DUMMY): %LET (variable name is VALUE_1_8) MLOGIC(DUMMY): %DO loop index variable J is now 9; loop will not iterate again. MLOGIC(DUMMY): %DO loop index variable I is now 2; loop will iterate again. SYMBOLGEN: Macro variable CNT_ID_VALUE_GROUPS resolves to 8 MLOGIC(DUMMY): %DO loop beginning; index variable J; start value is 1; stop value is 8; by value is 1. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 1 MLOGIC(DUMMY): %LET (variable name is VALUE_2_1) MLOGIC(DUMMY): %DO loop index variable J is now 2; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 2 MLOGIC(DUMMY): %LET (variable name is VALUE_2_2) MLOGIC(DUMMY): %DO loop index variable J is now 3; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 3 MLOGIC(DUMMY): %LET (variable name is VALUE_2_3) MLOGIC(DUMMY): %DO loop index variable J is now 4; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 4 MLOGIC(DUMMY): %LET (variable name is VALUE_2_4) MLOGIC(DUMMY): %DO loop index variable J is now 5; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 5 MLOGIC(DUMMY): %LET (variable name is VALUE_2_5) MLOGIC(DUMMY): %DO loop index variable J is now 6; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 6 MLOGIC(DUMMY): %LET (variable name is VALUE_2_6) MLOGIC(DUMMY): %DO loop index variable J is now 7; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 7 MLOGIC(DUMMY): %LET (variable name is VALUE_2_7) MLOGIC(DUMMY): %DO loop index variable J is now 8; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable J resolves to 8 MLOGIC(DUMMY): %LET (variable name is VALUE_2_8) MLOGIC(DUMMY): %DO loop index variable J is now 9; loop will not iterate again. MLOGIC(DUMMY): %DO loop index variable I is now 3; loop will iterate again. SYMBOLGEN: Macro variable CNT_ID_VALUE_GROUPS resolves to 8 MLOGIC(DUMMY): %DO loop beginning; index variable J; start value is 1; stop value is 8; by value is 1. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 1 MLOGIC(DUMMY): %LET (variable name is VALUE_3_1) MLOGIC(DUMMY): %DO loop index variable J is now 2; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 2 MLOGIC(DUMMY): %LET (variable name is VALUE_3_2) MLOGIC(DUMMY): %DO loop index variable J is now 3; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 3 MLOGIC(DUMMY): %LET (variable name is VALUE_3_3) MLOGIC(DUMMY): %DO loop index variable J is now 4; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 4 MLOGIC(DUMMY): %LET (variable name is VALUE_3_4) MLOGIC(DUMMY): %DO loop index variable J is now 5; loop will iterate again. 4 The SAS System 09:54 Thursday, March 21, 2024 SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 5 MLOGIC(DUMMY): %LET (variable name is VALUE_3_5) MLOGIC(DUMMY): %DO loop index variable J is now 6; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 6 MLOGIC(DUMMY): %LET (variable name is VALUE_3_6) MLOGIC(DUMMY): %DO loop index variable J is now 7; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 7 MLOGIC(DUMMY): %LET (variable name is VALUE_3_7) MLOGIC(DUMMY): %DO loop index variable J is now 8; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable J resolves to 8 MLOGIC(DUMMY): %LET (variable name is VALUE_3_8) MLOGIC(DUMMY): %DO loop index variable J is now 9; loop will not iterate again. MLOGIC(DUMMY): %DO loop index variable I is now 4; loop will iterate again. SYMBOLGEN: Macro variable CNT_ID_VALUE_GROUPS resolves to 8 MLOGIC(DUMMY): %DO loop beginning; index variable J; start value is 1; stop value is 8; by value is 1. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 1 MLOGIC(DUMMY): %LET (variable name is VALUE_4_1) MLOGIC(DUMMY): %DO loop index variable J is now 2; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 2 MLOGIC(DUMMY): %LET (variable name is VALUE_4_2) MLOGIC(DUMMY): %DO loop index variable J is now 3; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 3 MLOGIC(DUMMY): %LET (variable name is VALUE_4_3) MLOGIC(DUMMY): %DO loop index variable J is now 4; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 4 MLOGIC(DUMMY): %LET (variable name is VALUE_4_4) MLOGIC(DUMMY): %DO loop index variable J is now 5; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 5 MLOGIC(DUMMY): %LET (variable name is VALUE_4_5) MLOGIC(DUMMY): %DO loop index variable J is now 6; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 6 MLOGIC(DUMMY): %LET (variable name is VALUE_4_6) MLOGIC(DUMMY): %DO loop index variable J is now 7; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 7 MLOGIC(DUMMY): %LET (variable name is VALUE_4_7) MLOGIC(DUMMY): %DO loop index variable J is now 8; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable J resolves to 8 MLOGIC(DUMMY): %LET (variable name is VALUE_4_8) MLOGIC(DUMMY): %DO loop index variable J is now 9; loop will not iterate again. MLOGIC(DUMMY): %DO loop index variable I is now 5; loop will iterate again. SYMBOLGEN: Macro variable CNT_ID_VALUE_GROUPS resolves to 8 MLOGIC(DUMMY): %DO loop beginning; index variable J; start value is 1; stop value is 8; by value is 1. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 1 MLOGIC(DUMMY): %LET (variable name is VALUE_5_1) MLOGIC(DUMMY): %DO loop index variable J is now 2; loop will iterate again. 5 The SAS System 09:54 Thursday, March 21, 2024 SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 2 MLOGIC(DUMMY): %LET (variable name is VALUE_5_2) MLOGIC(DUMMY): %DO loop index variable J is now 3; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 3 MLOGIC(DUMMY): %LET (variable name is VALUE_5_3) MLOGIC(DUMMY): %DO loop index variable J is now 4; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 4 MLOGIC(DUMMY): %LET (variable name is VALUE_5_4) MLOGIC(DUMMY): %DO loop index variable J is now 5; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 5 MLOGIC(DUMMY): %LET (variable name is VALUE_5_5) MLOGIC(DUMMY): %DO loop index variable J is now 6; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 6 MLOGIC(DUMMY): %LET (variable name is VALUE_5_6) MLOGIC(DUMMY): %DO loop index variable J is now 7; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 7 MLOGIC(DUMMY): %LET (variable name is VALUE_5_7) MLOGIC(DUMMY): %DO loop index variable J is now 8; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable J resolves to 8 MLOGIC(DUMMY): %LET (variable name is VALUE_5_8) MLOGIC(DUMMY): %DO loop index variable J is now 9; loop will not iterate again. MLOGIC(DUMMY): %DO loop index variable I is now 6; loop will not iterate again. MLOGIC(DUMMY): Ending execution. 39 %PUT VALUE_4_4=&VALUE_4_4; SYMBOLGEN: Macro variable VALUE_4_4 resolves to VALUE_4_4= 40 %PUT VALUE_5_8=&VALUE_5_8; WARNING: Apparent symbolic reference VALUE_5_8 not resolved. VALUE_5_8=&VALUE_5_8 ... View more

Hello,   I have the below code.    As you see when I invoke the macro it invokes properly with the correct syntax. However When I invoke the macro in the SQL query it throws me error.   %let records_flow_id_value=5; %let flow_value1=column1; %let flow_value2=column2; %let flow_value3=column3; %let flow_value4=column4; %let flow_value5=column5; %macro Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=); %do i = 1 %to &nos_iteration.; %if &i. = 1 %then %do; %put when; %end; %put sum(case when lengthN(&&flow_value&i.)>0 then 1 else 0 end)+; %if &i. = &nos_iteration. %then %do; %put 0=0 then "-99" when; %end; %end; %do j = 1 %to &nos_iteration.; %put sum(case when lengthN(&&flow_value&j.)>0 then 1 else 0 end)+; %if &j. = &nos_iteration. %then %do; %put 0>=1 and lengthN(&ColumnName.)=0 then "-999" else &ColumnName.; %end; %end; %mend Assign_99_999; %Assign_99_999(ColumnName=Column1); data class; set sashelp.class; if age = 12 then column1 ="YES"; else column1="NO"; if age = 13 then column2 ="YES"; else column2="NO"; if age = 14 then column3 ="YES"; else column3="NO"; if age = 15 then column4 ="YES"; else column4="NO"; if age = 16 then column5 ="YES"; else column5="NO"; run; proc sql; create table _temp_ as select name ,age ,case %Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=Column1) end as Column1 from class ;quit;     Here is the log: 1 The SAS System 13:11 Monday, March 18, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M7P080620 SYMBOLGEN: Macro variable CURMAJ resolves to 9 SYMBOLGEN: Macro variable FMAJOR resolves to 9 SYMBOLGEN: Macro variable FMINOR resolves to 4 SYMBOLGEN: Macro variable FMAINT resolves to 4 SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M7P080620 SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M7P080620 SYMBOLGEN: Macro variable MAJOR resolves to 9 SYMBOLGEN: Macro variable CURMAJ resolves to 9 SYMBOLGEN: Macro variable MINOR resolves to 4 SYMBOLGEN: Macro variable CURMIN resolves to 04 SYMBOLGEN: Macro variable MAINT resolves to 4 SYMBOLGEN: Macro variable CURMNT resolves to 7 SYMBOLGEN: Macro variable MAINT resolves to 4 MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH 21 ENCODING='utf-8' 22 STYLE=HtmlBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/gpfs/FS1/saswork/SAS_work42220001BBA8_nzxpap1149.nndc.kp.org/SAS_workB78D0001BBA8_nzxpap1149.nndc.kp.org/" 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 %let records_flow_id_value=5; 29 %let flow_value1=column1; 30 %let flow_value2=column2; 31 %let flow_value3=column3; 32 %let flow_value4=column4; 33 %let flow_value5=column5; 34 35 %macro Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=); 36 37 %do i = 1 %to &nos_iteration.; 38 %if &i. = 1 %then %do; 39 %put when; 40 %end; 2 The SAS System 13:11 Monday, March 18, 2024 41 %put sum(case when lengthN(&&flow_value&i.)>0 then 1 else 0 end)+; 42 %if &i. = &nos_iteration. %then %do; 43 %put 0=0 then "-99" when; 44 %end; 45 %end; 46 47 %do j = 1 %to &nos_iteration.; 48 %put sum(case when lengthN(&&flow_value&j.)>0 then 1 else 0 end)+; 49 %if &j. = &nos_iteration. %then %do; 50 %put 0>=1 and lengthN(&ColumnName.)=0 then "-999" else &ColumnName.; 51 %end; 52 %end; 53 54 %mend Assign_99_999; 55 %Assign_99_999(ColumnName=Column1); SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable I resolves to 1 when SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable FLOW_VALUE1 resolves to column1 sum(case when lengthN(column1)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable FLOW_VALUE2 resolves to column2 sum(case when lengthN(column2)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable FLOW_VALUE3 resolves to column3 sum(case when lengthN(column3)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable FLOW_VALUE4 resolves to column4 sum(case when lengthN(column4)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable FLOW_VALUE5 resolves to column5 sum(case when lengthN(column5)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 3 The SAS System 13:11 Monday, March 18, 2024 0=0 then "-99" when SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 1 SYMBOLGEN: Macro variable FLOW_VALUE1 resolves to column1 sum(case when lengthN(column1)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 1 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 2 SYMBOLGEN: Macro variable FLOW_VALUE2 resolves to column2 sum(case when lengthN(column2)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 2 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 3 SYMBOLGEN: Macro variable FLOW_VALUE3 resolves to column3 sum(case when lengthN(column3)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 3 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 4 SYMBOLGEN: Macro variable FLOW_VALUE4 resolves to column4 sum(case when lengthN(column4)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 4 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 5 SYMBOLGEN: Macro variable FLOW_VALUE5 resolves to column5 sum(case when lengthN(column5)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 5 SYMBOLGEN: Macro variable NOS_ITERATION resolves to &records_flow_id_value. SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable COLUMNNAME resolves to Column1 SYMBOLGEN: Macro variable COLUMNNAME resolves to Column1 0>=1 and lengthN(Column1)=0 then "-999" else Column1 56 57 data class; 58 set sashelp.class; 59 if age = 12 then column1 ="YES"; else column1="NO"; 60 if age = 13 then column2 ="YES"; else column2="NO"; 61 if age = 14 then column3 ="YES"; else column3="NO"; 62 if age = 15 then column4 ="YES"; else column4="NO"; 63 if age = 16 then column5 ="YES"; else column5="NO"; 64 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.CLASS has 19 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds user cpu time 0.00 seconds 4 The SAS System 13:11 Monday, March 18, 2024 system cpu time 0.00 seconds memory 729.00k OS Memory 20124.00k Timestamp 03/18/2024 02:23:51 PM Step Count 21 Switch Count 2 Page Faults 0 Page Reclaims 52 Page Swaps 0 Voluntary Context Switches 49 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 65 options mprint symbolgen; 66 proc sql; 67 create table _temp_ as 68 select 69 name 70 ,age 71 ,case %Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=Column1) end as Column1 SYMBOLGEN: Macro variable RECORDS_FLOW_ID_VALUE resolves to 5 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable I resolves to 1 when SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable FLOW_VALUE1 resolves to column1 sum(case when lengthN(column1)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable FLOW_VALUE2 resolves to column2 sum(case when lengthN(column2)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 2 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable FLOW_VALUE3 resolves to column3 sum(case when lengthN(column3)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable FLOW_VALUE4 resolves to column4 sum(case when lengthN(column4)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 4 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 5 SYMBOLGEN: Macro variable FLOW_VALUE5 resolves to column5 sum(case when lengthN(column5)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable I resolves to 5 5 The SAS System 13:11 Monday, March 18, 2024 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 0=0 then "-99" when SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 1 SYMBOLGEN: Macro variable FLOW_VALUE1 resolves to column1 sum(case when lengthN(column1)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 1 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 2 SYMBOLGEN: Macro variable FLOW_VALUE2 resolves to column2 sum(case when lengthN(column2)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 2 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 3 SYMBOLGEN: Macro variable FLOW_VALUE3 resolves to column3 sum(case when lengthN(column3)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 3 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 4 SYMBOLGEN: Macro variable FLOW_VALUE4 resolves to column4 sum(case when lengthN(column4)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 4 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable J resolves to 5 SYMBOLGEN: Macro variable FLOW_VALUE5 resolves to column5 sum(case when lengthN(column5)>0 then 1 else 0 end)+ SYMBOLGEN: Macro variable J resolves to 5 SYMBOLGEN: Macro variable NOS_ITERATION resolves to 5 SYMBOLGEN: Macro variable COLUMNNAME resolves to Column1 SYMBOLGEN: Macro variable COLUMNNAME resolves to Column1 0>=1 and lengthN(Column1)=0 then "-999" else Column1 71 ,case %Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=Column1) end as Column1 __ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, WHEN, ^, ^=, |, ||, ~, ~=. 71 ,case %Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=Column1) end as Column1 __ 76 ERROR 76-322: Syntax error, statement will be ignored. 72 from class 73 ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 73 ! quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.18 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 244.65k 6 The SAS System 13:11 Monday, March 18, 2024 OS Memory 20124.00k Timestamp 03/18/2024 02:23:51 PM Step Count 22 Switch Count 0 Page Faults 0 Page Reclaims 11 Page Swaps 0 Voluntary Context Switches 101 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 74 75 %LET _CLIENTTASKLABEL=; 76 %LET _CLIENTPROCESSFLOWNAME=; 77 %LET _CLIENTPROJECTPATH=; 78 %LET _CLIENTPROJECTPATHHOST=; 79 %LET _CLIENTPROJECTNAME=; 80 %LET _SASPROGRAMFILE=; 81 %LET _SASPROGRAMFILEHOST=; 82 83 ;*';*";*/;quit;run; 84 ODS _ALL_ CLOSE; 85 86 87 QUIT; RUN; 88 ... View more

Hello,   I have issue in this code, not sure why it is not working: All that I am trying to do is: From a bunch of directories in a folder, I am just selecting 1 of them. That 1 value needs to be used in the libname statement. If I make that as %global then it would work. But don't think that is a good practice. Can you please help?   %macro returnfoldername(key_985632=); filename ps_list pipe "ls -l /sasdata/path/to/folder"; data _null_; infile ps_list; length process $ 200; input process $ char200.; if index(process,"&key_985632.")>0; call symput('returnfoldername_985632',substr(process,index(process,"&key_985632."),length(process)-index(process,"&key_985632.")+1 ) ); run; &returnfoldername_985632.; %mend returnfoldername; options symbolgen mprint mlogic; %let camp_key=123456; libname follow1 "/sasdata/path/to/folder/%returnfoldername(key_985632=&camp_key.)"; ... View more

Hello,   I have this: I want to subtract the new score for each player from the previous score of that player. In case if the player has only one record then leave the calculated field blank.   Please advise. Thank You     data have; infile datalines dlm="|"; input id score; datalines; 1|1 2|3 2|1 2|3 2|3 3|11 4|11 5|1 5|1 6|1 7|11 8|1 9|11 10|11 10|11 ;run;     ... View more

Missed asking this question here   Very similar question, but put quotes for Horsepower > 250 and NOT put quotes for Horsepower if it does not meet the condition.   data _null_; file "/path/output/unix/cars.csv" dsd dlm = ','; set sashelp.cars; if _n_ = 1 then put @1 "Make,Model,Type,Origin,DriveTrain,MSRP,Invoice,EngineSize,Cylinders,Horsepower,MPG_City,MPG_Highway,Weight,Wheelbase,Length"; put Make Model Type Origin DriveTrain MSRP Invoice EngineSize Cylinders Horsepower ~ MPG_City MPG_Highway Weight Wheelbase Length; run; ... View more