Hi to all,
I have file with so many columns and i want to keep only columns i want.
Data
gen red yellow green white blue
1 aa gg tt cc bb
2 aa gg tt cc bb
3 aa gg tt cc bb
4 aa gg tt cc bb
5 aa gg tt cc bb
expected
gen red white
1 aa cc
2 aa cc
3 aa cc
4 aa cc
5 aa cc
for example here i want to keep only gen, red and white columns only out of columns what i have in my data. I have so many columns in my original data but here i given just small example. can any one help me how to proceed with macro or any other way because removing manually taking long time for me. Any help would be highly appreciated
Thanks in advance
Regards,
Genetist
Bookmarks