topic Re: Redesigning SAS Dataset in SAS Programming https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239551#M44086 <P>I do no see an obvious source for Price-AVM, Price-Fraud or where a Model Value comes from for S-C or F-C.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 16 Dec 2015 15:52:41 GMT ballardw 2015-12-16T15:52:41Z Redesigning SAS Dataset https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239455#M44056 <P>How can use sas code to convert the following data&amp;colon;</P><TABLE><TBODY><TR><TD><STRONG>V-1</STRONG></TD><TD><STRONG>V-2</STRONG></TD><TD><STRONG>P-L</STRONG></TD><TD><STRONG>P-H</STRONG></TD><TD><STRONG>Model</STRONG></TD><TD><STRONG>ListOrder</STRONG></TD><TD><STRONG>CScore</STRONG></TD><TD><STRONG>V-L</STRONG></TD><TD><STRONG>V-H</STRONG></TD><TD><STRONG>Fscore</STRONG></TD><TD><STRONG>RuleNo</STRONG></TD></TR><TR><TD>AL</TD><TD>BALDWIN</TD><TD>0</TD><TD>999999999</TD><TD>P</TD><TD>1</TD><TD>0</TD><TD>100000</TD><TD>1000000</TD><TD>10</TD><TD>1</TD></TR><TR><TD>AL</TD><TD>ELMORE</TD><TD>0</TD><TD>999999999</TD><TD>V</TD><TD>1</TD><TD>93</TD><TD>100000</TD><TD>1000000</TD><TD>.</TD><TD><P>2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>to:</P><TABLE><TBODY><TR><TD><STRONG>RuleNo</STRONG></TD><TD><STRONG>Seq</STRONG></TD><TD><STRONG>V-1</STRONG></TD><TD><STRONG>V-2</STRONG></TD><TD><STRONG>P-L</STRONG></TD><TD><STRONG>P-H</STRONG></TD><TD><STRONG>Price-AVM</STRONG></TD><TD><STRONG>Price-Fraud</STRONG></TD><TD><STRONG>Variables</STRONG></TD><TD><STRONG>ServiceCount</STRONG></TD><TD>Model</TD></TR><TR><TD>1</TD><TD>1</TD><TD>AL</TD><TD>BALDWIN</TD><TD>0</TD><TD>999999999</TD><TD>0</TD><TD>0</TD><TD>&nbsp;</TD><TD>1</TD><TD>P</TD></TR><TR><TD>1</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>S-C</TD><TD>&nbsp;</TD><TD>0</TD></TR><TR><TD>1</TD><TD>3</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>F-C</TD><TD>&nbsp;</TD><TD>0</TD></TR><TR><TD>1</TD><TD>4</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Fscore</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>1</TD><TD>5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>VALUE RANGE</TD><TD>&nbsp;</TD><TD>100000-1000000</TD></TR><TR><TD>2</TD><TD>1</TD><TD>AL</TD><TD>ELMORE</TD><TD>0</TD><TD>999999999</TD><TD>0</TD><TD>0</TD><TD>&nbsp;</TD><TD>1</TD><TD>V</TD></TR><TR><TD>2</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><P>S-C</P></TD><TD>&nbsp;</TD><TD>0</TD></TR><TR><TD>2</TD><TD>3</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>F-C</TD><TD>&nbsp;</TD><TD>0</TD></TR><TR><TD>2</TD><TD>4</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>CScore</TD><TD>&nbsp;</TD><TD>93</TD></TR><TR><TD>2</TD><TD>5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>VALUE RANGE</TD><TD>&nbsp;</TD><TD>100000-1000000</TD></TR></TBODY></TABLE> Wed, 16 Dec 2015 15:20:11 GMT https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239455#M44056 izaan 2015-12-16T15:20:11Z Re: Redesigning SAS Dataset https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239484#M44070 <P>Your "want" layout is a report, not a data storage one.</P> <P>Where does "Variables" and "ServiceCount" come from?</P> <P>Once you got them into place, this looks like a proc print to me.</P> Wed, 16 Dec 2015 07:44:18 GMT https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239484#M44070 LinusH 2015-12-16T07:44:18Z Re: Redesigning SAS Dataset https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239528#M44078 <P>Service count will always be 1 for each rule. Variables is the new column of row variables introduced as required by the template.</P> Wed, 16 Dec 2015 15:17:42 GMT https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239528#M44078 izaan 2015-12-16T15:17:42Z Re: Redesigning SAS Dataset https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239551#M44086 <P>I do no see an obvious source for Price-AVM, Price-Fraud or where a Model Value comes from for S-C or F-C.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 16 Dec 2015 15:52:41 GMT https://communities.sas.com/t5/SAS-Programming/Redesigning-SAS-Dataset/m-p/239551#M44086 ballardw 2015-12-16T15:52:41Z