Hi folks, Need a little SAS coding help- At first, I thought I just needed to split a column but then I realized I need to split the entire dataset into several according to the length of the column text length of a name. Looking to split a single column(Dataset) of data into various columns(datasets) according to the length of the textual name size. My categories are: name, score, weight Example dataset "ALL_NAMES" has a category "NAME", which has four-letter names and three-letter names. I want to split the data into two datasets according to the length of the person's name. NAME| tom, jeff, bob, sam, fran, biff, tran, ned, jill What I want would be two different tables: name3 & name4 NAME Score Weight tom 5 100 bob 7 90 sam 6 80 ned 2 120 dataset: Name3 Name Score Weight jeff 25 80 fran 50 125 biff 100 100 tran 70 80 jill 65 90 dataset: Name4 Any help would be appreciated.
... View more