This is dataset i want one 'add State name where Texas ' and i also give needed output below . I just refer sample project i will try just use transpose duplicate values occur how to show below output help me. data work1;
input STATE_NAME $ Total_Number CATEGORY_DESCRIPTION $;
cards;
Georgia 45 < 10 years
Texas 100 < 10 years
Texas 10 < 10 years
Georgia 67 > 40 years
Texas 60 > 40 years
Texas 50 > 40 years
Georgia 100 Between 10 and 20 years
Texas 20 Between 10 and 20 years
Texas 10 Between 10 and 20 years
Georgia 56 Between 20 and 40 years
Texas 40 Between 20 and 40 years
Texas 40 Between 20 and 40 years
;
run; just want like this output help me.
... View more