Hello
I have datasets, with 20 rows and 51 columns. and I need to delete column(variable) if it has contain specific string.
The string is 'NO'
dataset (variable name: A, P1, P2, P3, ...... P50)
A P1 P2 P3 ..... P50
0 AP AP AP
1 30 25 80
2 50 30 120
3 NO 50 NO
4 NO 20 NO
.
.
.
20
I want to using array statment or macro but I don't have Idea to succesfully solve this problem.
I know this is so weired request but I have to do.
How can I do that?
... View more