Hi,
I'm wrestling with making a tool to correct often used phrases in SAS code, and then creating a new SAS file with the corrections (or, ideally, overwriting the original). I can read the SAS file, paste it as a cell per row going down, and correct the phrases.
My problem is exporting the rows to a .sas file without adding quotations. This seems to be happening as I'm saving to a new file (so a search and replace beforehand, won't solve the problem).
I've used https://www.extendoffice.com/documen...a-to-text.html as a guide.
My export sub is:
Which works fine for creating SAS file, but adds the quotation marks like so
which should just be (there are quotation marks in the SAS code)
I hope some of you can help me!
Cheers
Bookmarks