About sghatak

sghatak · ‎04-17-2019

one more thing forgot to add, i needed to group by Id's , so for iD = 1 subtract, ID=2, subtract until last.ID. Anyway , have to loop it for this. Thanks.

sghatak · ‎04-17-2019

I got it. I modified the code to just the difference between k and date, hence i get the numbers i was hoping for, thank you, this was a simple solution rather than doing Do loop; appreciate timely help.

sghatak · ‎04-17-2019

My Id is char, date is num, hence i am trying to subtract rows, thank you for quick response, appreciate it.

sghatak · ‎04-17-2019

Hi, I have data is following format Id Date 1 201701 1 201711 2 201809 2 201812 3 201702 3 201708 3 201812 I need to group by ID's and find the difference between the dates, so my output looks like - Id Date Difference 1 201701 0 1 201711 10 2 201809 0 2 201812 3 3 201702 0 3 201708 6 3 201812 4 data want; _n_ =0; do until(last.ID); set have; by Id; _n_+1; if _n_ = _n_ - 1 then dateflag = date; if _n_ = _n_ +1 then difference = dateflag - date; end; run;

sghatak · ‎05-01-2018

Thank you , i could figure out the issues. Corrected code:- options mprint symbolgen; %macro monthelig; %let CYm1=0; %let i=1; %do %while (&i <7); data test; set test_0; %if E_START_DATE&i<='01APR2018'd<=E_END_DATE&i and &CYm1=0 %then %do; CYm1=1; %end; %else %if E_START_DATE&i not in ('') and &CYm1=1 %then %do; CYm1=1; %END; %else %if E_START_DATE&i in ('') and &CYm1=1 %then %do; CYm1=1; %END; %else %if E_START_DATE&i in ('') and &CYm1=0 %then %do; CYm1=0; %end; run; %let i=%sysevalf(&i+1); %put i=&i; %end; %mend monthelig; %monthelig;

sghatak · ‎05-01-2018

i keep getting the following error:- ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: E_START_DATE&i not in ('') and &CYm1=0 ERROR: The macro MONTHELIG will stop executing. Absolutely not able to debug this - %macro monthelig; %let i=1; %do %while (&i <7); %let CYm1=0; data test; set test_0; %if E_START_DATE&i not in ('') and &CYm1=0 %then %do; if E_START_DATE&i<='01APR2018'd<=E_END_DATE&i then CYm1=1; else CYm1=0; %end; %else %if E_START_DATE&i not in ('') and &CYm1=1 %then %do; CYm1=1; %END; %else %if E_START_DATE&i in ('') and &CYm1=1 %then %do; CYm1=1; %END; %else %if E_START_DATE&i in ('') and &CYm1=0 %then %do; CYm1=0; %end; run; %let i=%sysevalf(&i+1); %put i=&i; %end; %mend monthelig; %monthelig; Any help or suggestion, I would appreciate it very much. Thank you.

Online Status	Offline
Date Last Visited	‎04-19-2019 01:06 AM

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Loop through duplicate Id's and subtract row2-row1

Re: SAS Error - %EVAL function or %IF

SAS Error - %EVAL function or %IF

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Re: Loop through duplicate Id's and subtract row2-row1

Loop through duplicate Id's and subtract row2-row1

Re: SAS Error - %EVAL function or %IF

SAS Error - %EVAL function or %IF