Use Select statement , if you dont want to pass arguments.
Like :
create procedure status_change
(
)
as
begin
Declare @diff int
set @diff=(select datediff(day,last_login,getdate()) from samp_data);
if(@diff>=90)
begin
update samp_data set status='deactive'
end
Select @diff
end