After reading your conversion message, yet another test: data have;
infile cards truncover;
input LNDR_FMLY_ID :$20. QTR_ID :$20. INCM ASTS LIAB BANK_IND :$2.;
cards;
ARBRT 2015Q1 . . . Y
ARBRT 2015Q1 130967 . . .
ARBRT 2015Q1 . 2742733 . .
ARBRT 2015Q1 . . 1892937 .
JPMOR 2015Q2 100267 . . .
;
data want;
update have(obs=0) have;
by LNDR_FMLY_ID QTR_ID;
run;
proc print noobs;
run; SAS Output LNDR_FMLY_ID QTR_ID INCM ASTS LIAB BANK_IND ARBRT 2015Q1 130967 2742733 1892937 Y JPMOR 2015Q2 100267 . .
... View more
