topic I have an excel sheet that is structured as below. After importing, I need to get the 'Codex' values to start at Code1 for every observation. (ie. need to shift some of these to the left.) Suggestions in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101382#M9707 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#ffffff&quot;,&quot;backgroundColor&quot;:&quot;#6690bc&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;}" style="width: 100%; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Code1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code2</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code3</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code4</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code5</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code6</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code7</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code8</STRONG></STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">64721</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">36860</TD><TD style="padding: 2px;">35465</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">45565</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12545</TD><TD style="padding: 2px;">45665</TD><TD style="padding: 2px;">25785</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12546</TD><TD style="padding: 2px;">12562</TD><TD style="padding: 2px;">15485</TD><TD style="padding: 2px;">84556</TD><TD style="padding: 2px;">24566</TD><TD style="padding: 2px;">58585</TD><TD style="padding: 2px;">32656</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">54545</TD><TD style="padding: 2px;">14652</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 02 Oct 2013 15:16:13 GMT uabcms 2013-10-02T15:16:13Z I have an excel sheet that is structured as below. After importing, I need to get the 'Codex' values to start at Code1 for every observation. (ie. need to shift some of these to the left.) Suggestions https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101382#M9707 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#ffffff&quot;,&quot;backgroundColor&quot;:&quot;#6690bc&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;}" style="width: 100%; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Code1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code2</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code3</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code4</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code5</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code6</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code7</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG><STRONG>Code8</STRONG></STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">64721</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">36860</TD><TD style="padding: 2px;">35465</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">45565</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12545</TD><TD style="padding: 2px;">45665</TD><TD style="padding: 2px;">25785</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12546</TD><TD style="padding: 2px;">12562</TD><TD style="padding: 2px;">15485</TD><TD style="padding: 2px;">84556</TD><TD style="padding: 2px;">24566</TD><TD style="padding: 2px;">58585</TD><TD style="padding: 2px;">32656</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">54545</TD><TD style="padding: 2px;">14652</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 02 Oct 2013 15:16:13 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101382#M9707 uabcms 2013-10-02T15:16:13Z Re: I have an excel sheet that is structured as below. After importing, I need to get the 'Codex' values to start at Code1 for every observation. (ie. need to shift some of these to the left.) Suggestions https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101383#M9708 <HTML><HEAD></HEAD><BODY><P>Save the sheet as csv;</P><P></P><P>data want;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; infile "where you saved the csv" delimiter=',' missover;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; input id code1-code8 ;</P><P>run;</P><P></P><P><BR /> </P></BODY></HTML> Wed, 02 Oct 2013 15:55:12 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101383#M9708 ballardw 2013-10-02T15:55:12Z Re: I have an excel sheet that is structured as below. After importing, I need to get the 'Codex' values to start at Code1 for every observation. (ie. need to shift some of these to the left.) Suggestions https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101384#M9709 <HTML><HEAD></HEAD><BODY><P>That was easy.&nbsp;&nbsp; Thanks very much.</P></BODY></HTML> Thu, 03 Oct 2013 14:24:13 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/I-have-an-excel-sheet-that-is-structured-as-below-After/m-p/101384#M9709 uabcms 2013-10-03T14:24:13Z