<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Script template for creating charts from CSV files in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Script-template-for-creating-charts-from-CSV-files/m-p/141124#M28383</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys&lt;/P&gt;&lt;P&gt;I am new to JMP Pro and to its scripting language, as well as to those SAS forums.&lt;/P&gt;&lt;P&gt;If you think that I post my question in the wrong place - let me know and please excuse me,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;My goal&lt;/STRONG&gt; is to create a script that will:&lt;/P&gt;&lt;P&gt;open CSV file&lt;/P&gt;&lt;P&gt;create variability chart based on table from this file&lt;/P&gt;&lt;P&gt;save the result as JRP file&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now&lt;STRONG&gt; some details&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;CSV file might be huge in row number. This file starts with line of column names. Lets assume that the complete path to this file is "&lt;STRONG&gt;PathToCSV&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;I have a script that creates variability chart that I need. Lets assume that the text of this script is "&lt;STRONG&gt;ChartScript&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;As a result I want to get a .JRP file that will contain both data from CSV file and chart, lets assume that the path to desired JRP file is "&lt;STRONG&gt;DesiredReportPath&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;I know that column names in my script that creates chart are correct and those columns are present indeed in CSV file.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;More details:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Actually I am writing some C# application that automates the process of test log parsing. It does a lot of (irrelevant for JMP) things.&lt;/P&gt;&lt;P&gt;We have some environment that creates a lot of csv files with know schemes.&lt;/P&gt;&lt;P&gt;We have some specialists that know to open those files in JMP Pro and to create the charts that they need.&lt;/P&gt;&lt;P&gt;So those people can give me precise scripts for those charts. They have different charts for different schemes of CSV.&lt;/P&gt;&lt;P&gt;I am merging those csv with same schemes in my app, and then I want to use JMP interop to run the script that I want to construct.&lt;/P&gt;&lt;P&gt;I will run the different script for each merged CSV file. So I need to create a template for the script.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Question&lt;/STRONG&gt;: What would be the script to do what I want?&lt;/P&gt;&lt;P&gt;I assume that it has the following construction:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;X1 PathToCSV X2 &lt;STRONG&gt;ChartScript X3 &lt;STRONG&gt;DesiredReportPath&lt;/STRONG&gt;&lt;/STRONG&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Where X1 opens CSV file and creates some data table,&lt;/P&gt;&lt;P&gt;X2 opens new tab(?) for chart and creates it&lt;/P&gt;&lt;P&gt;X3 saves all work to desired path&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Artem;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 08 Dec 2014 14:46:36 GMT</pubDate>
    <dc:creator>ArtemV</dc:creator>
    <dc:date>2014-12-08T14:46:36Z</dc:date>
    <item>
      <title>Script template for creating charts from CSV files</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Script-template-for-creating-charts-from-CSV-files/m-p/141124#M28383</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys&lt;/P&gt;&lt;P&gt;I am new to JMP Pro and to its scripting language, as well as to those SAS forums.&lt;/P&gt;&lt;P&gt;If you think that I post my question in the wrong place - let me know and please excuse me,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;My goal&lt;/STRONG&gt; is to create a script that will:&lt;/P&gt;&lt;P&gt;open CSV file&lt;/P&gt;&lt;P&gt;create variability chart based on table from this file&lt;/P&gt;&lt;P&gt;save the result as JRP file&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now&lt;STRONG&gt; some details&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;CSV file might be huge in row number. This file starts with line of column names. Lets assume that the complete path to this file is "&lt;STRONG&gt;PathToCSV&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;I have a script that creates variability chart that I need. Lets assume that the text of this script is "&lt;STRONG&gt;ChartScript&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;As a result I want to get a .JRP file that will contain both data from CSV file and chart, lets assume that the path to desired JRP file is "&lt;STRONG&gt;DesiredReportPath&lt;/STRONG&gt;".&lt;/P&gt;&lt;P&gt;I know that column names in my script that creates chart are correct and those columns are present indeed in CSV file.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;More details:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Actually I am writing some C# application that automates the process of test log parsing. It does a lot of (irrelevant for JMP) things.&lt;/P&gt;&lt;P&gt;We have some environment that creates a lot of csv files with know schemes.&lt;/P&gt;&lt;P&gt;We have some specialists that know to open those files in JMP Pro and to create the charts that they need.&lt;/P&gt;&lt;P&gt;So those people can give me precise scripts for those charts. They have different charts for different schemes of CSV.&lt;/P&gt;&lt;P&gt;I am merging those csv with same schemes in my app, and then I want to use JMP interop to run the script that I want to construct.&lt;/P&gt;&lt;P&gt;I will run the different script for each merged CSV file. So I need to create a template for the script.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Question&lt;/STRONG&gt;: What would be the script to do what I want?&lt;/P&gt;&lt;P&gt;I assume that it has the following construction:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;X1 PathToCSV X2 &lt;STRONG&gt;ChartScript X3 &lt;STRONG&gt;DesiredReportPath&lt;/STRONG&gt;&lt;/STRONG&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Where X1 opens CSV file and creates some data table,&lt;/P&gt;&lt;P&gt;X2 opens new tab(?) for chart and creates it&lt;/P&gt;&lt;P&gt;X3 saves all work to desired path&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Artem;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 08 Dec 2014 14:46:36 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Script-template-for-creating-charts-from-CSV-files/m-p/141124#M28383</guid>
      <dc:creator>ArtemV</dc:creator>
      <dc:date>2014-12-08T14:46:36Z</dc:date>
    </item>
    <item>
      <title>Re: Script template for creating charts from CSV files</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Script-template-for-creating-charts-from-CSV-files/m-p/141125#M28384</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi:&lt;/P&gt;&lt;P&gt;&amp;nbsp; The SAS Macro &lt;SPAN style="text-decoration: underline;"&gt;&lt;STRONG&gt;is&lt;/STRONG&gt;&lt;/SPAN&gt; the wrong place for a JMP Scripting question. The JMP Community Forum has moved to here &lt;A href="https://community.jmp.com/welcome" title="https://community.jmp.com/welcome"&gt;Welcome | JMP User&lt;/A&gt; and that would be a better place for you to post your question.&lt;/P&gt;&lt;P&gt;cynthia&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 08 Dec 2014 18:16:01 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Script-template-for-creating-charts-from-CSV-files/m-p/141125#M28384</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2014-12-08T18:16:01Z</dc:date>
    </item>
  </channel>
</rss>

