Date:         Thu, 8 Feb 2007 17:41:12 +0000
Reply-To:     iw1junk@COMCAST.NET
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ian Whitlock <iw1junk@COMCAST.NET>
Subject:      Re: Change variable length
Comments: cc: Ran S <raan67@YAHOO.COM>

Summary: Make me a list.
#iw-value=1

Ran,

If you had a list you could write

   PROC SQL;
    ALTER TABLE ATTACH MODIFY &list ;
   quit ;

Now SQL is a great list maker so the full code might be

   PROC SQL noprint ;
    select name || "char(4)" into :list separated by ", "
      from dictionary.columns
      where libname = "WORK"
        and memname = "ATTACH"
        and type = "char"
        and length = 2
        and name like 'QUESTION%'
    ;
    ALTER TABLE ATTACH MODIFY &list ;
   quit ;

Ian Whitlock
===============

Date:         Thu, 8 Feb 2007 11:19:29 -0500
Reply-To:     Ran S <raan67@YAHOO.COM>
Sender:       "SAS(r) Discussion"
From:         Ran S <raan67@YAHOO.COM>
Subject:      Change variable length

Hi,

I am using the following code to change the length of the variables. How
can I write global code to change the length of the variables with say 2
char to 4 char length. Because in some other dataset I might have many
variables like that.

I would appreciate your response. Thank you

PROC SQL;
 ALTER TABLE ATTACH
 MODIFY  QUESTION1 CHAR (4), QUESTION2 CHAR(4), QUESTION1 CHAR(4),
QUESTION2 CHAR(4), QUESTION3_A CHAR(4),QUESTION3_B CHAR(4),QUESTION3_C CHAR
(4),QUESTION5_A CHAR(4), QUESTION5_B CHAR(4), QUESTION5_C CHAR
(4),QUESTION5_D CHAR(4),QUESTION5_E CHAR(4),QUESTION6 CHAR(4),QUESTION7_A
CHAR(4),QUESTION7_B CHAR(4), QUESTION7_C CHAR(4),QUESTION7_D CHAR
(4),QUESTION7_E CHAR(4),QUESTION8 CHAR(4),QUESTION9_A CHAR(4), QUESTION9_B
CHAR(4), QUESTION9_C  CHAR(4),QUESTION12 CHAR(4);
QUIT;