Hello,   I have this: data have; input value lower :$10. upper :$10.; infile datalines dlm=","; datalines; 0.0035,>=0.0035,<=0.034 0.034,>=0.0035,<=0.034 0.0045,>=0.0035,<=0.034 ;run; Within a Datastep(not _NULL_), I want to evaluate the condition value||lower/*value >=0.0035*/ and value||upper/*value <=0.034*/ and if the conditions are met then create another variable- flag with value "GOOD" else value should be "BAD".   Please advise. ... View more

Team,   I have this: %macro clustering_method(method=); proc cluster data=cars method=&method. ccc outtree=tree_&method. noprint; where type="Sports"; by type; var horsepower mpg_highway weight wheelbase; run; proc sort data=tree_&method. out=&method.(keep= type _ncl_ _ccc_ ); by type _ncl_ _ccc_ ; where not missing(_ccc_); run; %mend; %clustering_method(method=Average); %clustering_method(method=median); %clustering_method(method=centroid); %clustering_method(method=mcquitty); %clustering_method(method=ward); data Have; set Average Median Centroid McQuitty Ward indsname=source; input_ds=scan(source,2,'.');; run; Referring to the Have dataset. What should be my optimum number of Clusters ? and Why?   Please advise.   Thanks         ... View more

Team, I have this dataset:     data have1;     input name $23.;     datalines;     &temp.alpha     &temp.beta     ;     run; This is what I want: %let temp=var1; proc sql; create table want1 as select upcase(resolve(name)) as new_var from have1 where upcase(resolve(name))=upcase("var1alpha") ; quit; I am able to get what I want using resolve().   But with this, I have to make change in all the existing code. I am reaching out to you to find , if any, alternative solution.   I tried having the following dataset but it does NOT work. data have2; input name $23.; datalines; resolve(&temp.alpha) resolve(&temp.beta) ; run; Any alternative you would suggest?   Thanks   ... View more

I am not able to resolve the cause of the error. Can someone please help me.   Here is my code: %macro chk(where=); %if %isblank(%nrstr(&where.))=0 %then %do; %if %upcase(%substr(%str(&where.),1,5)) ne WHERE %then %do; %put %str(E)RROR: "Please put WHERE at the starting of the where macro parameter."; %return; %end; %end; %mend; options symbolgen mprint mlogic; %chk(where=where);/*It works as Expected*/ %chk();/*It does NOT work as Expected. I want the first condition to turn to false for this case.*/ /*Also tried this*/ %macro chk(where=); %if not %isblank(%nrstr(&where.)) %then %do; %if %upcase(%substr(%str(&where.),1,5)) ne WHERE %then %do; %put %str(E)RROR: "Please put WHERE at the starting of the where macro parameter."; %return; %end; %end; %mend; %chk(where=where);/*It works as Expected*/ %chk();/*It does NOT work as Expected. I want the first condition to turn to false for this case.*/ ... View more

Team,   I have the following code:   %let char_var_cnt=12; %let sixpack=6; %let quotient=%eval(&char_var_cnt./&sixpack.); %let remainder=%sysfunc(mod(&char_var_cnt.,&sixpack.)); %put quotient=&quotient.; %put remainder=&remainder.; %macro looping; %do i=1 %to &sixpack.; %do k=1 %to &char_var_cnt.; %let k&i._&k.=var&k.; %put list is k&i._&k.; %end; %end; %mend; %looping;  The above code creates macro variable   list is k1_1 list is k1_2 list is k1_3 list is k1_4 list is k1_5 list is k1_6 list is k1_7 list is k1_8 list is k1_9 list is k1_10 list is k1_11 list is k1_12 list is k2_1 list is k2_2 list is k2_3 list is k2_4 list is k2_5 list is k2_6 list is k2_7   What I actually want is: It creates the following macro variable k1_1 K1_2 k2_3 K2_4 k3_1 K3_6 k4_1 K4_8 k5_9 K5_10 k6_11 K6_12   Each of these K1_1, k1_2, k2_3 etc macro variables need to take value from another macro var&i.   The char_var_cnt macro variable is dynamic.   The sixpack  macro variable is static.   To summarize: If char_var_cnt is equal to 12 then i want the following macro parameters: k1_1 K1_2 k2_3 K2_4 k3_1 K3_6 k4_1 K4_8 k5_9 K5_10 k6_11 K6_12   If char_var_cnt is equal to 24 then i want the following macro parameters: k1_1   K1_2   k1_3   K1_4 k2_5   K2_6   k2_7   K2_8 k3_9   K3_10 k3_11 K3_12 k4_13 K4_14 k4_15 K4_16 k5_17 K5_18 k5_19 K5_20 k6_21 K6_22 k6_23 K6_24     Can you please help me with it? ... View more