About SASUser0001

SASUser0001 · ‎05-27-2020

hi I have data as below I am looking to create another variable using %change column and number starting number from column. then use output of that and next % change value to create new variable and so on. the new index column is what I wanted to create using starting value from B and then % from column A. date A B new_index 30-Sep-01 0.45% 3500 62799.435 31-Dec-02 1.02% 2000 3484.320557 31-Mar-04 0.58% 4800 3449.139336 30-Jun-05 0.93% 5698 3429.249688 30-Sep-06 0.74% 5896 3397.651529 data test_; set Re_data; do i= 1 to 5; new_index=B/(1+per_change); /*ouput of new_index then will become B and use next Per_change vallue*/ end; run;

SASUser0001 · ‎05-26-2020

data want; set a; rel_diff=abs((amount1-amount2)/amount1); format rel_diff percent5.0; run; </> 　 hi The following program shows between two variables but I am looking to get percentage change between two number in a variable. my data is like this date Range 31-Mar-80 1800 30-Jun-80 1300 30-Sep-80 800 31-Dec-80 300 31-Mar-81 600 30-Jun-81 900

SASUser0001 · ‎05-25-2020

sorry I didn't add semicolons as it gives me error when write message here. if A=B then variable C should be created else c will be null. the way C should be created is before 30April2002 should come from A and after 30April2002 from B. thanks For helping

SASUser0001 · ‎05-25-2020

and after 30/04/2002 comes from B and create variable C. sorry it didn't allow me to finish whole question in one

SASUser0001 · ‎05-25-2020

it bring data for that date but I wanted to bring all the data from this date. but it gives me only for that particular day record like one record. 29 30 data test 31 set test_1 32 length C 8. 33 34 if date='31APR2002'd then do 35 if A =B then C=A 36 end run so like following if A and b have same data on 30/04/2002 then before 30/04/2002 data comes from A and after 30/ date A B 28-Feb-02 1236 5842 31-Mar-02 5662 553 30-Apr-02 3526 3526 30-Jun-02 3525 2060 30-Sep-02 3524 2041 31-Dec-02 3523 2022 31-Mar-03 3522 2003 30-Jun-03 3521 1984 30-Sep-03 3520 1965 31-Dec-03 3519 1946

SASUser0001 · ‎05-25-2020

hi I have two variables A and B . I wanted to compare those two variables based on date variable. on a particular date like 02/02/2019 if data is same then copy data before 02/0/2/2019 from A and 02/02/2/019 onwards data from B and create new variable. I am trying something like this. data test; set test_1; length new_variable 8.; if date='02FEB2019' then do; if A=B then new_variable = A; end; run;

SASUser0001 · ‎05-15-2020

hi this is my programe where should I use macro d1(name, list) proc summary data=total nway missing 　 var &list output out= data1 (drop=_type_ _freq_) sum= run mend d1

SASUser0001 · ‎05-15-2020

hi I have marco that is creating proc summary statement . I wanted to scale in output everything by a number like 2 or 3 . like in below program I want to multiply outdata with a number like 2 or 3 based on I will create a macro on top with %let statement . can anyone help please . output out= outdata (drop=_type_ _freq_) sum=; run;

SASUser0001 · ‎05-14-2020

thanks

SASUser0001 · ‎05-14-2020

can i do output data set from proc tabulate. thanks

SASUser0001 · ‎04-16-2020

Thanks you been most helpful

SASUser0001 · ‎04-16-2020

so basically I am looking to calculate interest for 6 months , each record start date and end date is different I have created array to calculate interest and now I am looking to create macro for days in each month for 6 months . so for each record (1 to 6 months ) interest will be calculated based on month. ints_1= ((balance *Interest_rate )/100)/365)*31; bal = balance + ints_1; so trying to replace days in month (31) with actual days in month by using data _null_step or macro thanks

SASUser0001 · ‎04-16-2020

hi I have data like this start_date=01apr2020 end_date=30sep2020 and I am looking to create macro which will provide me daycount(30,31,30,31,30) so I can use this later in array as below. thanks for guiding array days_mnt{6} 8 _temporary_( &daycount.);

SASUser0001 · ‎04-16-2020

hi i am looking to create macro with days in month like( 30,31,30) from two dates. which i will use later in array as macro like(array days_mnt{6} 8 _temporary_( &daycount.);) any suggestions please. thanks

SASUser0001 · ‎04-13-2020

hi I am looking to calculate interest for 6 months. where interest is compounded monthly. I have try to use do loop something like this but it doesnt calculate for 6 months. it only give me interest for first month. help please. do i = 1 to 6; balance=total_balance; interest+(((balance*rate)/100)/365)*30; bal_1=balance+Interest; end;

Online Status	Offline
Date Last Visited	‎06-02-2020 03:41 AM

loop

percenatge change

Re: compare two dataset

Re: compare two dataset

Re: compare two dataset

compare two dataset

Re: proc summary

proc summary

Re: proc tabulate

proc tabulate

Re: proc tabulate

Re: days in month between two dates

Re: days in month between two dates

Re: days in month between two dates

loop

percenatge change

Re: compare two dataset

Re: compare two dataset

Re: compare two dataset

compare two dataset

Re: proc summary

proc summary

Re: proc tabulate

proc tabulate

Re: days in month between two dates

Re: days in month between two dates

Re: days in month between two dates

days in month between two dates

interest Caculations monthly