Hi I have 3 tables:   data table1; input String $; datalines; APPLE BANNANA ORANGE PECAN CITY ; run; data table2; input id APPLE BANNANA ORANGE WALNUT PECAN ALMOND CITY $; datalines; 111 15 2 34 22 10 12 KRA 112 3 33 45 5 33 45 WRO 113 34 78 90 6 67 34 SUW 114 12 43 56 7 89 0 WAW run; data table3; input id; datalines; 111 113 114 ; run; From table 1 need names(string), from table 3 id and result from table 3     id APPLE BANNANA ORANGE PECAN CITY 111 15 2 34 10 KRA 113 34 78 90 67 SUW 114 12 43 56 89 WAW   I will be grateful for suggestions.   ... View more

Hi I have table wsad with 1,6 mln obs and table limit with 0,4 mln obs. the code below works with several hundred records, but freezes on more What to do to make it work with more records? proc sql; update WSAD as a set pkt = (select pkt from limit b where a.id= b.id), data = (select data from limit b where a.id = b.id) where a.id in (select id from limit); quit;   ... View more

  I have text: [{crmId: 270294251239318446711736, zapłacone faktury:0}, {crmId: 109338771587264730348439, zapłacone faktury:0}, {crmId: 105563037561893625234667, zapłacone faktury:0}, {crmId: 529342335726661326310295, zapłacone faktury:0}, {crmId: 102928808219759468645267, zapłacone faktury:0}, {crmId: 446627936599178084266781, zapłacone faktury:0}, {crmId: 1206246190076409102049055, zapłacone faktury:0}, {crmId: 1208925742523269613394857, zapłacone faktury:0}]   I want crmid: 270294251239318446711736 109338771587264730348439 105563037561893625234667 529342335726661326310295 102928808219759468645267 446627936599178084266781 1206246190076409102049055 1208925742523269613394857   In this case is 7 id in new row but their number and length may vary ... View more

Hello All I would like to sum up the numbers from the text below: Kwota=237 + Kwota=30.87 + Kwota=292.74 + Kwota=292.74 + Kwota=300.87 that is: Kwota=1154,22 In the example there are 5 phrases but their number may vary. text: [Forma sprzedazy=leasing, auto: Audi A 6, Kwota=237, Cena =123],[Forma sprzedazy=leasing, auto: Volvo, Kwota=30.87, Cena =10],[Forma sprzedazy=leasing, auto: VW Golf, Kwota=292.74, Cena =134],[Forma sprzedazy=leasing, auto: VW Golf, Kwota=292.74, Cena =134],[Forma sprzedazy=leasing, auto: Porche, Kwota=300.87, Cena =152] ... View more