how to retrieve records which contatin same value

[Ram4sas]

Hi Xia Keshan,

thank you for reply. i was out of system for last 2 months. anywway thank you once again.

[stat_sas]

%let date= 25JUN2014;

proc sql;

select Account, Type, salary from have

where Rec_Gen_Dt<="&date"d

order by account,type;

quit;