Hello, The lines in your code beginning with %let are macro commands. As such they are executed sequentially and independently of your different tests. You either have to use macro tests %if ... %then (and the data step is then useless but you have to encapsulate your code in a macro) or defining "state" as a dataset column and export it in a macrovariable with a call symput. ... View more

Hello,   Why do you want to create a separate (single-row) dataset for each month ? There is probably a better way to achieve your goal. ... View more

Hello,   %let list_have=word1 word2 word3; %let want="%sysfunc(tranwrd(&list_have.,%str( ),%str(%" %")))"; %put &want.; ... View more

Hello,   data _NULL_; dt=input("&date.",yymmdd10.); call symput("date",put(dt,date9.)); run; ... View more

Hello,   I think this should work : data name_value; set name_value; array abc (3) 4. a b c; do i=1 to dim(abc); if var_name1=vname(abc(i)) then abc(i)=var_value1; if var_name2=vname(abc(i)) then abc(i)=var_value2; end; run; proc sql noprint; CREATE TABLE want AS SELECT a.name_ID, var_name1, var_value1, var_name2, var_value2, b.* FROM name_value a LEFT JOIN original b ON (a.a=b.a OR a.a=.) AND (a.b=b.b OR a.b=.) AND (a.c=b.c OR a.c=.); quit; ... View more

Hello, When you're on the baseline row, you set the BL variable three times so that, on the following rows you're only left with the last computed BL value, BL=ITEM(3). You have to store baseline values in an array. ... View more

Also, the macrovariables created by call symput are not readily available. They can only be used after the data step has finished executong. ... View more

Hello,   It will be easier to answer if you show us the log.   I see the following line in your program :   call execute('%segment_volumes_obc(sub_segment_temp=&sub_seg., volume=&vol.)');   Since the argument string is enclosed in single quotes, the macrovariables in the string will not be resolved. You have to use single quotes with call execute in order to avoid a premature execution of the macro. If you need to resolve some macrovariables, build the argument string by a concatenation of substrings. ... View more

Maybe having a void third argument means that no delimiter will be used so we'll always obtain the entire string with 1 as second argument and an empty string for higher values.   The behavior is different with the scan function :   197 data _NULL_; 198 str="a b c"; 199 first=scan(str,1,''); 200 put first=; 201 run; first=a NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Edit : The result above is due to the fact that empty strings in SAS contain one space. I tried the same program, omitting the third argument. I thought it would result in an error but it produces the same result as its macro counterpart :   202 data _NULL_; 203 str="a b c"; 204 first=scan(str,1,); 205 put first=; 206 run; first=a b c NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   From the documentation http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm Syntax SCAN(string, count<,charlist <,modifiers>>) Using Null Arguments The SCAN function allows character arguments to be null. Null arguments are treated as character strings with a length of zero. Numeric arguments cannot be null. ... View more

Since the compiler ignores spaces, quotes or %str( ) are needed to tell the compiler that the space is significant.   114 %let x=a. b. c.; 115 116 %macro test_scan; 117 %do i=1 %to %sysfunc(countw(&x.)); 118 %put ---; 119 %let a=%scan(&x.,&i.); 120 %put &=a.; 121 122 %let b=%scan(&x.,&i., ); 123 %put &=b.; 124 125 %let c=%scan(&x.,&i.,' '); 126 %put &=c.; 127 %end; 128 %mend; 129 130 %test_scan; --- A=a B=a. b. c. C=a. --- A=b B= C=b. --- A=c B= C=c. ... View more

Hello,   keeping the space as delimiter and using %scan(&f.,&I.,' ') or %scan(&f.,&I.,%str( )) also works. ... View more

Hello,   Here is a solution that avoids using a list of names in a macrovariable   data persons; input name $ male; cards; John 1 Mary 0 Peter 1 Robert 1 Jane 0 Lucy 0 William 1 Richard 1 Anna 0 ; run; data results; input John Mary Michael Peter Sylvia Robert Jane Lucy William Charlotte Richard Annna; cards; 3 4 2 3 5 4 2 5 3 4 1 4 ; run; proc sql noprint; SELECT count(*) INTO :nmales FROM persons WHERE male=1; quit; data want; set results; array a_names(&nmales.) $ _TEMPORARY_; if _N_=1 then do i=1 by 1 until (eof); set persons (where=(male=1)) end=eof; a_names(i)=name; end; do i=1 to dim(a_names); total+vvaluex(a_names(i)); end; drop i name male; run; ... View more