Hello   I own 2 tables in my program. table A key;value key1;A and B key2;A key3;B table B value;value_text A;text a B;text b   I want receive each line of the table A with the value "value_text" of the table B . There is a problem , tableA.value can contain "A and B" in the even cell ...     select tableA.key , tableA.value , tableB.value from tableA inner join SUBSTR(tableA.value,INDEX(cats(tableA.value),tableB.value)length(tableB.value))) = tableB.value An idea if the query is logical or an other solution exist ?   Thanks for you help. ... View more

Hello ,   I must merge 4 tables in SAS without using proc sql and union. I must usge DATA and SET.     data quatre_fichiers; set work.bd1_imp /*additional column*/ way='transac_way1' (rename=("N°"n=num Application=app "Nature transac"n=lbnat "Cause transac"n=lbcau "Anomalie(s)"n=anomalie "Date rejet "n=dtrej Acteur=lbact Statut=lbsta "Analyse srv1"n=anasrv1 "Analyse srv2"n=ana "Date correction"n=dtcorr initiale=trigramme)); set work.bd2_imp /*additional column*/ way='transac_way2' (rename=("N°"n=num Application=app "Nature transac"n=lbnat "Cause transac"n=lbcau "Anomalie(s)"n=anomalie "Date rejet "n=dtrej Acteur=lbact Statut=lbsta "Analyse srv1"n=anasrv1 "Analyse srv2"n=ana "Date correction"n=dtcorr initiale=trigramme)); set work.bd3_imp /*additional column*/ way='transac_way3' (rename=("N°"n=num Application=app "Nature transac"n=lbnat "Cause transac"n=lbcau "Anomalie(s)"n=anomalie "Date rejet "n=dtrej Acteur=lbact Statut=lbsta "Analyse srv1"n=anasrv1 "Analyse srv2"n=ana "Date correction"n=dtcorr initiale=trigramme)); set work.bd4_imp /*additional column*/ way='transac_way4' (rename=("N°"n=num Application=app "Nature transac"n=lbnat "Cause transac"n=lbcau "Anomalie(s)"n=anomalie "Date rejet "n=dtrej Acteur=lbact Statut=lbsta "Analyse srv1"n=anasrv1 "Analyse srv2"n=ana "Date correction"n=dtcorr initiale=trigramme)); run;   Sas refuse to insert the new column in first position in my new table (this new column is " way " ). This column must contain a special value in function of the table which is insert . If the data come from the table work.bd1,  I want see 'transac_way1' in the new column which is own the name ' way '  , if it's work.bd2 I want 'transac_way2'  .   In this case SAS refuse to read the instruction way='value' . It's the event case if I place instruction attrib or label .    Thanks for your help ... View more

Hello / Good Morning , Currently the department where I work in my company use Windows 7 under 32 bits (only one computer is in 64 bits). It's plan to migrate all computers under Windows 10 in 64 bits.   Problem : 2 laptop and 3 classicals computers use SAS Base 9.4 with Enterprise guide 7.1 .   With this migration plan under Windows 10 in 64 bits , know you the impacts in the SAS app ? (if there are conflicting , inconsistent , constraint ? ... )   If you know several informations in this subject I'm opened to talk about this   Thanks for your help ... View more

Hello ,   I want call a macro inside à proc sql like this :   %macro changecharac (value=); value=tranwrd(value,'&','and'); value=tranwrd(value,'N/A','empty'); %mend changecharac; proc sql; create table my_table as select field1 , field2 , %changecharac(value=field3) as field3sec from my_table_origin; quit; What you think about this ?   SAS doesn't read the code of macro   Thanks for you help 😉 ... View more