BookmarkSubscribeRSS Feed
R_Win
Calcite | Level 5

I am having a table old with variable Test with length=20 now i want to increase the length how can i do it . can we do by proc datasets procedure

3 REPLIES 3
Ksharp
Super User
data class; set sashelp.class;run;
proc sql;
 alter table class
  modify name char(100);
quit;

Ksharp

art297
Opal | Level 21

No.  Proc datasets only changes metadata attributes and a change to a variables length means that spaces physically either have to be added or removed from each record.

Haikuo
Onyx | Level 15

Edit: Art is right, there is no way to do it using proc datasets.

if using data step;

data want;

length sex $100.;

set class;

run;

Regards,

Haikuo

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1312 views
  • 0 likes
  • 4 in conversation