topic Re: Merge 2 tables with 2 columns similar but a little different in New SAS User

Merge 2 tables with 2 columns similar but a little different

Nathalie1 — Fri, 25 Nov 2022 15:58:02 GMT

Hello,

I try to merge to tables with a column (genes) wich have not exactly the same names at the end of the value. So, I obtain a table with too much lines. I have 24404 genes.

This is the result of merge by the column genes.

For example, in the first table, the names are DSE, in the second table the names are longer DSE ENSG.

I want to drop ENSG of the second table but I can't arrive.

If you can help me (I am a beginner).

Thank you very much,

Nathalie

Re: Merge 2 tables with 2 columns similar but a little different

Kurt_Bremser — Fri, 25 Nov 2022 18:03:46 GMT

Use the SCAN Function to extract the first "word" before doing the MERGE.

Re: Merge 2 tables with 2 columns similar but a little different

Nathalie1 — Fri, 25 Nov 2022 18:47:41 GMT

Thank you very much for your help.

Sincerely yours,

Nathalie