topic Re: Sort data for comparisons in SAS Programming

Sort data for comparisons

Q1983 — Fri, 28 Feb 2020 03:27:25 GMT

data have;

length status $25.;

input status Month Current Past;

return;

datalines;

Current 2 1 0

Current 3 1 0

PastDue 2 0 1

PastDue 3 0 1

;

run;

I need to be able to compare the Current and PastDue numbers by Status and Month

As an example Current in Month 2 is 1 and I want to place it in the same row as PastDue in Month 2 which is a 0. If I do a proc transpose the data will show in a diagnol due to the presence of 0 if there is no match

Re: Sort data for comparisons

ChrisNZ — Fri, 28 Feb 2020 05:34:14 GMT

like this?

data WANT;
  merge HAVE(where=(STATUS='Current'))
        HAVE(where=(STATUS='PastDue') rename=(CURRENT=CUR2 PAST=PAST2));
  by MONTH;
run;

Re: Sort data for comparisons

ed_sas_member — Fri, 28 Feb 2020 08:34:06 GMT

Hi @Q1983

Could you please show us the expected output?

Best,