Date:         Thu, 3 May 2007 04:59:27 -0700
Reply-To:     Rajesh <Rajesh.vishwanath@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Rajesh <Rajesh.vishwanath@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Renaming variables??? but in different way
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi All,

   I have the below dataset for example,

DATA X;
INPUT A1 A2 A3 A4 B1 B2 B3  B4 C1 C2 C3 C4;
CARDS;
 1 . 3 4 5 6 7 8 9 10 11 12
13 14 15 16 17 18 19 20 21 22 23 2 4
RUN;

IF THERE IS MISSING THEN I HAVE TO DROP THE VARAIBLES,

WHERE IN MY CASE A2 IS MISSING,THEN I HAVE TO DROP A2,ALONG WITH THAT
B2 AND C2 SHOULD ALSO BE DROPPED.*****************************


(((SUPPOSE C4,B1 WAS MISSING THEN I SHOULD HAVE DROPPED C4,A4
B4,B1,A1,C1)))


***************************THEN I HAVE LEFT WITH ONLY 12 VARAIBLES AS

A1 A3 A4 B1 B3 B4 C1 C3 C4

I WANT TO RENAME THEM IN SEQUENCE AS BELOW,

A1 A2 A3 B1 B2 B3 C1 C2 C3 WITH THE VALUES AS IN THE INTIAL
(EX:IN THE ABOVE CASE A1 REMAINS AS IT IS A3 SHOULD BE RENAMED TO A2,
A4 TO A3,B1 REMAINS SAME,B3 TO B2,B4 TO B3 ETC...)

CAN ANYONE LET ME KNOW HOW TO DO THIS????

NOTE: I HAVE AROUND 800 VARIABLES,IT IS VERY DIFFICULT TO DO  MANUALLY
EACH AND EVERY TIME WHEN I PERFORM THE JOB,SO I LOOKING FOR A CODE
WHICH WOULD AUTOMATICALLY BY PASSING THE VALUES OR PARAMETERS .


THANK YOU,
RAJESH