Hi everyone,
I'm a beginner of SAS program.
I want to compare the value of string and date with yyq4. format
I subtract the string value YYQn from ID_loan.
* YYQn = origination year and quarter
I also get Loan origination date named DT_orig from the following formula.
* Loan_age = ((Monthly Reporting Period) - Loan Origination Date(MM/YY)) - 1 month
I hope I can extract the value which DT_orig and YYQn is
For example, the data which has DT_orig = 20140101 should have YYQn=14Q1
if the DT_orig and YYQn does not match, I have to extract those rows.
Here is the same of data and my code which doesn't work.
sample_2014_2017
DATA sample_2014_2017;
set sample_svcg_2014to2017;
Period_YM = input(put(Period, best6.),yymmn6.);
DT_orig_YM = intnx('month', Period_YM, -loan_age-1);
DT_orig = input(put(DT_orig_YM, yymmn6.),best6.);
format Period_YM yymmn6. DT_orig_YM yymmn6.;
keep ID_loan Period Period_YM DT_orig DT_orig_YM;
RUN;
DATA temp01;
set sample_2014_2017;
YYQn = input(substr(ID_loan,3,4), yyq4.);
Dt_orig_qt = Dt_orig_YM;
format Dt_orig_qt YYQ4. YYQn YYQ4.;
keep ID_loan YYQn Dt_orig_qt;
RUN;
DATA temp02;
set temp01;
if input(Dt_orig_qt, best4.) != input(YYQn, best4.);
RUN;
Thank you in advance.
... View more