topic Re: How do I create a csv file output that can be pasted into a wiki document in SAS Data Management

How do I create a csv file output that can be pasted into a wiki document

beamer108 — Wed, 15 Feb 2017 17:31:53 GMT

I have a job in DM studio that contains a branch that breaks out several nodes into separate output files. From there I need to take the data from the output files and paste it or somehow get it into a wiki document as a table. Currently we have an excel macro that reformats the data by placing pipes at the beginning, double pipes between cells/columns, creates a hard carriage return followed by "|-" after each row. That data is then placed into the wiki and it recognizes the hard carriage return and |- and creates a new row. I can't figure out a way to create the output of a data job in DM studio that will do this for me automatically.

Re: How do I create a csv file output that can be pasted into a wiki document

Reeza — Wed, 15 Feb 2017 18:18:11 GMT

How are you creating the csv? A data step should be able to do this.

Re: How do I create a csv file output that can be pasted into a wiki document

beamer108 — Wed, 15 Feb 2017 18:19:54 GMT

Using a text file output node. Maybe this isn't the best way to accomplish what my goal is but it's what I have right now. If there is a different way to get this done Im interested.

Re: How do I create a csv file output that can be pasted into a wiki document

beamer108 — Wed, 15 Feb 2017 18:32:09 GMT

I should add that I used a concatenation node prior to the text file output to add a single pipe at the beginning of a row and double pipes between columns which works perfectly when I paste it into the wiki, it puts each of the cells in the correct columns but it doesn't hard break it to start a new row. Everything continues on in the same row.

Re: How do I create a csv file output that can be pasted into a wiki document

beamer108 — Tue, 21 Feb 2017 13:03:31 GMT

I was able to find a workaround, may not be the best or only option but it works temporarily. I used the concatenation node and added <TR Class = "rowon" and <td> at the beginning of my list. Then after each separate field I inserted </td><td> to end and start a new field. I ended the list with </tr>. I ran that node into a text file output. Once that runs, I copy and paste those results into my wiki page that has been pre-built with the headers etc. The information gets pasted into the "body" of the wiki. This seems to be the best solution that I have found, but interested in other options down the road to enhance this if anyone has ideas. Thank you for your help!