sas, Concatenating variables with same prefix or suffix

1. Rounding and Prefixing and Suffixing Observations

2. Re How to remove variables with same suffix?

Kitty,

There is no easy answer, when you do not know enough SAS.  Here is
a basic solution which only requires SAS/BASE knowledge.

   %macro vspec ( lib=work, mem=t , spec=2002 2003, vlist=list, max=99) ;
       %* assign list of wanted variables to &vlist ;
       %* lazy way: ask user to separate libname from memname
                    and give upper bound on number of conditions
       ;
       %global &vlist ;
       %local i w _&vlist ;
       /* set up variable name requirements list */
       %do i = 1 %to &max ;
           %let w = %scan(&spec,&i) ;
           %if %length(&w) = 0 %then %goto endloop ;
           %let _&vlist = &&_&vlist or name like '%' || "&w" ;
       %end ;
       %endloop:
       %let _&vlist = %substr(&&_&vlist,4) ;

       /* extract list of variables */
       proc sql noprint ;
          select name into :&vlist separated by " "
             from dictionary.columns
             where libname = "%upcase(&lib)"
               and memname = "%upcase(&mem)"
               and ( &&_&vlist ) ;
       quit ;
   %mend  vspec ;

   /* test data */
   data w ;
      retain q1_2002 - q1_2020 q2_2002 - q2_2020 q3_2002 - q3_2020 7 ;
   run ;

   /* assign list */
   options mprint ;
   %vspec ( mem = w , spec = 2002 2003 )

   /* extract columns */
   options symbolgen ;
   data q ;
      set w ( keep = &list ) ;
   run ;
   options nosymbolgen ;

The good news is that this example includes most of the techniques needed
for manipulating lists of variables.

Ian Whitlock
=================
Date:         Mon, 24 Apr 2006 13:50:12 -0700
Reply-To:     Kitty Lee < XXXX@XXXXX.COM >
Sender:       "SAS(r) Discussion"
From:         Kitty Lee < XXXX@XXXXX.COM >
Subject:      How to remove variables with same suffix?
Content-Type: text/plain; charset=iso-8859-1
Hi All,
  Does anyone know how to remove the variables with the same suffix?  For
  example, if I have the following variables, Q1_2002, Q2_2002, Q3_2002,
  Q4_2002, Q1_2003, Q2_2003 etc...and if I want to keep only year 2003's
  and remove 2002's, what should I do?  I know with the same prefix I can
  do V:  (with a colon) but with the same suffix, I have no clues.
  Thank you!

---------------------------------
How low will we go? Check out Yahoo! Messenger low  PC-to-Phone call
rates.

3. How to remove variables with same suffix?

4. Help needed to Concatenate variables in SAS Dataset into a new variable

Hi

I have a SAS dataset with variables COL1, COL2 etc. The number of
these can vary.

I want to concatenate all of then into a new COL variable.

Can you help.

5. same operation on 100 variables with the same prefix var

6. reading variables with same prefix

Is there a difference in PROC IML when reading multiple variables with
the same prefix?  Is there an obvious solution to getting the
following to run:



proc iml;
use test_merge2;
read all var {act_wt}  into w;
read all var {fac_01-fac_68} into e;
wt=w`;
exp=wt*e;
print exp;
quit;

7. TRANSPOSE, creating variables with PREFIX= option

8. Removing prefixes in variable names