Yes
create procedure CallTest
as
begin
select sellerName, 'US' as 'Country' from sellers
end
go
Create table sp_data (iid int, sp_name varchar(50));
insert into sp_data values (1, 'CallTest');
declare @sp_name varchar(50)
select @sp_name = sp_name from sp_data
exec (@sp_name);