topic Re: creating new variable with observation value in New SAS User

creating new variable with observation value

Kamal5522 — Thu, 04 Jul 2019 05:32:58 GMT

Hi i have below data set
Company Profit
OYO 45
PAYTM 65
PHONPE 50
Total 160

in the above dataset I want add new varibale Total where i want total value 160. I do not want to create variable by giving hard value as

Total=160
I want to create in such a way that if total value changes then variable value also changes accordingly
Can someone advise please

Re: creating new variable with observation value

Kurt_Bremser — Thu, 04 Jul 2019 05:38:24 GMT

You want a new observation with company = 'Total' and profit = sum of profits?

This is mostly needed for reporting, and the SAS procedures for that can handle it, so there's no need to add an observation.

But just to show you how it's done:

data want;
set have end=eof;
retain sum_profit 0;
output;
sum_profit + profit;
if eof
then do;
  company = 'Total';
  profit = sum_profit;
  output;
end;
drop sum_profit;
run;

Re: creating new variable with observation value

Kamal5522 — Thu, 04 Jul 2019 05:54:10 GMT

thanks

Re: creating new variable with observation value

Kamal5522 — Thu, 04 Jul 2019 05:56:25 GMT

Thanks kurt. this code is quite useful

Re: creating new variable with observation value

Kamal5522 — Thu, 04 Jul 2019 06:02:24 GMT

Hi kurt
I also want to know that is it possible to create a variable with the particular observation value. if we change observation value then value of variable chnages. suppose in the below example if I want to create a varibale X that show paytm 65 value
company profit X
oyo 55 65
paytm 65 65
phone 40 65
if change paytm profit to 70 then whole X varibale should show 70.
please advise

Re: creating new variable with observation value

Kurt_Bremser — Thu, 04 Jul 2019 06:09:25 GMT

Do you want the maximum value in the new column, or the value of a specific observation?

Maximum:

proc sql;
create table want as
select
  have.*,
  max(profit) as X
from have;
quit;

Specific:

proc sql;
create table want as
select
  have.*,
  (select profit from have where company = 'paytm') as X
from have;
quit;