<?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 How to group by in a JSL fit model script? in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/How-to-group-by-in-a-JSL-fit-model-script/m-p/147460#M297461</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;linfit=Fit Model(&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Y( :PT ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Effects( :Pts 2 ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Personality( Standard Least Squares ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Run model&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;linfit&amp;lt;&amp;lt;prediction formula;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have a simple script using a fit model that saves the prediction formula to my current data table. It looks at a basketball player's points scored on a given night vs. what the opponent's defense typically allows. In the table, there are multiple players and duplicate values for each player. Instead of fitting a linear regression for all players and using one prediction formula, I'd like to fit a linear regression for each individual player, so that there are multiple prediction formulas within one column. When I let JMP create the script for me, the script just runs over and over with a "where player = X" clause for each player. The players change on a regular basis so this can't be used. I thought I could just add a "Group by(:players)," line after Effects(:Pts 2) but that isn't grouping anything for me. How do I go about using group by in a fit model script?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 16 Sep 2014 21:24:14 GMT</pubDate>
    <dc:creator>mattdh88</dc:creator>
    <dc:date>2014-09-16T21:24:14Z</dc:date>
    <item>
      <title>How to group by in a JSL fit model script?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/How-to-group-by-in-a-JSL-fit-model-script/m-p/147460#M297461</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;linfit=Fit Model(&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Y( :PT ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Effects( :Pts 2 ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Personality( Standard Least Squares ),&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Run model&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;linfit&amp;lt;&amp;lt;prediction formula;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have a simple script using a fit model that saves the prediction formula to my current data table. It looks at a basketball player's points scored on a given night vs. what the opponent's defense typically allows. In the table, there are multiple players and duplicate values for each player. Instead of fitting a linear regression for all players and using one prediction formula, I'd like to fit a linear regression for each individual player, so that there are multiple prediction formulas within one column. When I let JMP create the script for me, the script just runs over and over with a "where player = X" clause for each player. The players change on a regular basis so this can't be used. I thought I could just add a "Group by(:players)," line after Effects(:Pts 2) but that isn't grouping anything for me. How do I go about using group by in a fit model script?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 16 Sep 2014 21:24:14 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/How-to-group-by-in-a-JSL-fit-model-script/m-p/147460#M297461</guid>
      <dc:creator>mattdh88</dc:creator>
      <dc:date>2014-09-16T21:24:14Z</dc:date>
    </item>
    <item>
      <title>Re: How to group by in a JSL fit model script?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/How-to-group-by-in-a-JSL-fit-model-script/m-p/147461#M297462</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Please post your question to the JMP community forum&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.jmp.com/welcome" title="https://community.jmp.com/welcome"&gt;https://community.jmp.com/welcome&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;PG&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 16 Sep 2014 21:39:26 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/How-to-group-by-in-a-JSL-fit-model-script/m-p/147461#M297462</guid>
      <dc:creator>PGStats</dc:creator>
      <dc:date>2014-09-16T21:39:26Z</dc:date>
    </item>
  </channel>
</rss>

