+ Reply to Thread
Results 1 to 4 of 4

Can I export rows of text to a .sas file WITHOUT quotation marks?

  1. #1
    Registered User
    Join Date
    06-30-2016
    Location
    Copenhagen
    MS-Off Ver
    2013
    Posts
    2

    Can I export rows of text to a .sas file WITHOUT quotation marks?

    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:
    Please Login or Register  to view this content.
    Which works fine for creating SAS file, but adds the quotation marks like so
    Please Login or Register  to view this content.
    which should just be (there are quotation marks in the SAS code)
    Please Login or Register  to view this content.
    I hope some of you can help me!
    Cheers
    Last edited by pehsh; 06-30-2016 at 10:35 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,861

    Re: Can I export rows of text to a .sas file WITHOUT quotation marks?

    Hi,
    Try
    Please Login or Register  to view this content.
    and check if output format suits your needs (you will probably get more spaces between cells)

    another way to go is to use PRINT statement.

    Just as a reference:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-30-2016
    Location
    Copenhagen
    MS-Off Ver
    2013
    Posts
    2

    Re: Can I export rows of text to a .sas file WITHOUT quotation marks?

    Hi Kaper,

    Turns out that the code below did the trick.

    Please Login or Register  to view this content.
    (I had the stored rows in coloumn J, and a sub to count the last active row in coloumn J)

    Simple is better. I appreciate your help, Kaper.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,861

    Re: Can I export rows of text to a .sas file WITHOUT quotation marks?

    You are welcome.
    And thanks for marking thread as solved and for the reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exporting to text file from Excel with quotation marks
    By MikeFranz123 in forum Excel General
    Replies: 0
    Last Post: 11-02-2014, 05:00 AM
  2. Replies: 0
    Last Post: 11-09-2011, 01:31 AM
  3. Excel adding quotation marks when saving text file
    By theaudiobookguy in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-01-2009, 08:26 PM
  4. [SOLVED] Removing quotation marks in a txt-file
    By Reedhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 03:20 PM
  5. CSV File and Maintaining Quotation Marks in TXT
    By rammstein in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 06:18 PM
  6. [SOLVED] how do I remove quotation marks from .CSV file
    By Ratty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2005, 11:05 AM
  7. Replies: 3
    Last Post: 01-26-2005, 10:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1