@SuryaKiran, SQL looks useful in this situation, as also suggested by @Kurt_Bremser, but remember to select the specific column you want to be saved in the into macro variable (in this case memname). It is also useful to know about the escape syntax as the underscore ('_') will match any single character with the like operator: http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#n1ege2983n6h0vn1s1uj1459phr9.htm Regards, Amir.
... View more
