replace a text "","" with "," in sas

[learn_SAS_23]

Hello all, 

am looking for a solution with a text in the column of a table 

Question 1 : 

Input : "vg_PCI_Car"", ""vg_PCI_CivilLiability"", ""vg_PCI_Fire"

output:  "vg_PCI_Car", "vg_PCI_CivilLiability", "vg_PCI_Fire"

Question 2 : 

Input : vg_PCI_Car", "vg_PCI_CivilLiability", "vg_PCI_Fire

output:  vg_PCI_Car_vg_PCI_CivilLiability_vg_PCI_Fire"

[PGStats · Accepted solution]

Use the TRANSTRN function

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n101a8jch5trh0n1bc5neq48hc89.htm...

Use single quotes to enclose target and replacement strings containing double quotes : '"",""'

[learn_SAS_23]

Thanks