i have one sas data set . i have to check the value of some certain column in this data set.wheather ther are having missing value or not.
mcolumn : have list of column like col1,col2,col3
if upcase(trim(symget('mcolumn'))) = "NA"
putlog "THEN MODULE";
putlog "not null";
s = countc(trim(symget('mcolumn')),',')+1;
IF missing(resolve(P)) THEN DO;
in the above program in do while loop i create one macro variable colvalue .it is containg name of column to be checked. in the next step i have to check column's value .....
but there is a rules that if create macro in data step then you can't use that macro in same data step......
i am completly in base sas 9.1 ...i don't know mush about that...and most of the time i get confusion abt macro concept....i am not able to understand how sas program works....please suggets me any book so that i can clear my basic concept.....