Hello,   How can I refer a macro variable and its value in a data step?  for example, if I have a dataset that have 3 variables A1 B2 and C3. If I set marco variable "%letr colvar=A1"., how can I utilized &colvar. to get a filter that macro variable colvar was setup as 'A1" and its value is within (1,2)?:   if &colvar.=A1 and &colvar. in (1,2) then do;... how to refer a macro variable name, and how to refer a value that belong to a variable? ... View more

Hello, I have a dataset 'Have' and I would like to rename the variables that start with 'COL'  to COL1-COLx, where x is how many variables that were using name COL in data 'Have'.  In my sample data, I would like to change vars COL1 COL3 COL88 to COL1 COL2 COL3. The 'Want' outcome is the bottom one: What should I do? Thinking of getting all variable that start with COL into array and then do the loop for rename, but get lost during the process. Could anyone guide me on this? thanks. data have; input group $ COL1 COL3 COL88 value $; datalines; g1 30 45 36 Y g2 37 25 55 N g2 76 88 99 N g3 22 74 . Y g3 84 . 25 Y g4 15 88 99 N g4 21 78 65 Y g4 94 . . N g4 73 8 78 Y ; run;   ... View more

Hi all,   I am trying to get max value by group and assign it to a set of macro variables. Can anyone please help?   My codes were able to get the max value for each group.(might not be a smart way. If you know a better way, please share your thoughts. thanks.)  but how can create macro variables base on the groups we have? data have; input group $ value; datalines; g1 30 g2 37 g2 76 g3 22 g3 84 g4 15 g4 21 g4 94 g4 73 ; run; proc sort; by group descending value ; run; data want (keep= group max_v); set have; by group; retain max_v; if first.group then max_v= value; run; proc sort nodupkey; by _all_; run;   here we have 4 group, the ideal macro variables are %let grp1=30; %let grp2=76;  %let grp3=84; %let grp4=94; Is there a smart way to build those macro variables automatically? ... View more

Hello,   I would like to know whether it is possible to call marco variables with a looping code. Please see example below: when i=1, I would like to get:  _inval{1}=put( _invars{1},&_width1).  Current codes won't work. data df1; a = .; b=1; c=1; output; a = 1; b=.; c=1; output; a = 1; b=1; c=.; output; run; %let _width1=3.1; %let _width2=3.2; %let _width3=3.3; data want ; set df1; array _invars{3} a b c; array _inval{3} $16 ; do i=1 to 3.; _inval{i}=put( _invars{i},&_widthi) ; /*I want to use &_width(i) where i change with i in looping setting */ end; run ; ... View more

Hello, I would like to covert a set of numerical variables to character and replace . to "NA". I tried to use array for this task. However my missing is still show up as . in stead of "NA". What did I do wrong?   Please see the sample data and my codes below: data df1; a = .; b=1; c=1; output; a = 1; b=.; c=1; output; a = 1; b=1; c=.; output; run; data want ; set df1; array _invars{3} a b c; array _invals{3} _inval1 _inval2 _inval3; do i=1 to 3; if _invars{i} gt .z then _invals{i}=put( _invars{i},5.2) ; else _invals{i}= "NA" ; end; run ; ... View more

Hello,   I would like to know whether there is a way to replace duplicate space to single space for the value of macro variable.   For example: %let _invar=A1 A2   A3; Here you can see there are more than 1 space between A2 and A3. I would like to update _invar or build a new macro variable (_update) to 'A1 A2 A3'. Only 1 space between each word. What should I do.   In data step, I could do COMPBL ("&_invar.")  however I am not sure how to do the similar process for a macro variable. Could anyone guide me on this? Thanks. ... View more

Hello,   I would like to find a way to subtract the punctuation out of string into multiple marco variables.    For example:  invalue="X/X(X%)" I would like to use 'X' as delimiter to find any sign before or after 'X' and then store them into a serial of marco variables with prefix _s. So here I would like to build following macro variables: _s1= _s2=/ _s3=( _s4=%)   If invalue="(x-x)" then the set I want will be _s1=( _s2=- _s3=)   How can I achieve this goal? As invalue format is not the same, the punctuation position will change case by case.     Thanks.     ... View more

Hello,   I try to build a macro to sort a dataset by '&byvar.' if it is not empty set. Could anyone tell me whether it is OK to do proc sort within if statement?  I have following codes and currently getting errors when I have empty set. %macro m_sort(byvar=); proc sql; select count(*) into: obsn from df1; quit; %if &obsn. ^= 0 %then %do; proc sort data=df1; by &byvar.; run; %end; %mend; ... View more