Tom, you are like angel from Heaven!   it works!   I dunno how to thank you!!!!!! ... View more

Tom, many thanks for your kind guidance. this is uber helpful and im headed on the right direction. however, the last set of code is not working...   perhaps it is eaiser for me upload another file to give you a better sense.     i have "HAVE" sheet. this sheet has ticker in the 1st column and all the numbers are volumes of specific stock in column A by dates.   i would really love this "HAVE" sheet to be transferred as the "NEED" sheet with some code magic.   in the "NEED" sheet, i have ticker in the 1st column, day on the 2nd column, and volume on the 3rd column. from 1st to 16th row, i have the 1st stocks observation. then, from 17th row to 31st, i have the 2nd stock's observation.   could you plz help? thank you so much in advance!!!   ... View more

thank you so much for your reply but it doesnt solve th issue. cud u take a look at my updated excel file? the transpose in eexcel wud only make the file to "have"sheet.   thank you! ... View more

hi PG, thank you for your reply. it may at first glance look like a easy transpose...but if you look at the excel tab "need"   it eseentially has 3 columns: date company volume  essentially, i want to make my final dataset as : company-date observations of volume for all companies in have   im not sure what u mean by not sas format.         ... View more

you are a big help naveen. thank you! ... View more

tom, sorry. this is a dumb question but there are variables that ends with S. ie, CFV011S i just wnated to drop the variables that ends with S, but it is not working. do u have any color? ... View more

wow tom. you are a magician! ... View more

just along the lines, how may i rename those variables that ends with _C to without them? ideally i would like, aaa_c->aaa many thanks in advance! ... View more

oh. sorry. it works with the colon! this is very very helpful. thank you so much. do u by any chance have an idea, how to drop the same suffixes? ie: _C. i have variables that ends with _C: for example, xxx_C. how may i drop them? thankyou! ... View more

not working...get an error: WARNING: The variable EC in the DROP, KEEP, or RENAME list has never been referenced. ... View more