data accounts; input accno age amount; cards; 101 23 2000 102 32 3000 103 21 1300 104 38 2100 105 18 1890 ; run; /*Task- increase 1000 rs per year for each account and find total amount for every customer age at 55 */     /*please write other than this */ /*Chat gpt code */ data accounts; input accno age amount; cards; 101 23 2000 102 32 3000 103 21 1300 104 38 2100 105 18 1890 ; run; data accounts_updated; set accounts; years_to_55 = 55 - age; total_amount_at_55 = amount + (years_to_55 * 1000); run; proc print data=accounts_updated; var accno age amount years_to_55 total_amount_at_55; run;   ... View more

Hi , is it possible to display role variable after removing duplicates by using PROC SQL? any suggestion, Thanks in advance. data demo; input pid role$; cards; 101 Hr 102 deveolper 103 analyst 101 admin ;run; proc sql; select distinct(pid) from demo; quit;   ... View more