Hi, Try this... PROC SQL ; SELECT count(name) INTO :count FROM HAVE WHERE NAME IN (SELECT NAME FROM WANT); SELECT NAME INTO :test1- :test%left(&count) FROM HAVE WHERE NAME IN (SELECT NAME FROM WANT); QUIT; %PUT &test1 &test2 &test3 &count; Thanks, Shiva
... View more