proc sql; create table one as select * from sashelp.class; alter table one modify sex character(20); update one set sex='Testing 12345'; quit; ... View more

To change the length,we must use the LENGTH statement as the very first statement in the DATA STEP , BUT  the position will be changed at the same time. Thank you chang_y_chung.your method works well ,let's wait for somebody have a more simple method. ... View more

Thank you all. LinLin's method and Reeza and Haikuo's methods all works, LinLin's method create a new dataset but the other not, except this what is the other main difference? Thanks ... View more

Hi SAS_Bigot, The other dataset's name is  two,it need to be updated ,the dataset have site1  site2 site 3 ,It need to be updated by dataset one. I modified dataset one, the column's name  in dataset one is not "firstname" and "lastname",they are "site" and "value"(I updated my question),the site  column have three different possible values they are 1,2 or 3.(for example :2 correspond to site2 in dataset two) for instance if ID=3 then site=2,value=789621,we need to update two's third row(ID=3),site2 should be replaced from 33 to 789621.so and so forth.. the two dataset have public column "ID" Thanks! dataset one: ID  site   value 1    1       78645 2     1       5686 3     2       789621 4     3       78742 5     3       45689 6     2       1479789 7     1        4678 8      2      36708 ..... dataset two: ID   site1  site2 site 3 1      8       .        . 2      .         12      66 3      88       33     9 4      5          22     99 5                   . 6       6           1      7 7 8 9 10 ..... ... View more

Hi Ksharp, Do you know what is the max value to set MEXECSIZE and MSYMTABMAX options? Thanks! ... View more