topic Re: Command for one column in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121729#M33526 <HTML><HEAD></HEAD><BODY><P>Or :</P><P>You can apply that datastep option directly within proc export:</P><P></P><P>PROC EXPORT DATA= want(keep=CUSIP)</P><P></P><P>&nbsp; OUTFILE= "C:\temp\forum\want.xls"</P><P></P><P>&nbsp; DBMS=EXCEL REPLACE;</P><P></P><P>&nbsp; SHEET="list";</P><P></P><P>RUN;</P><P></P><P>Haikuo</P></BODY></HTML> Mon, 21 May 2012 12:20:20 GMT Haikuo 2012-05-21T12:20:20Z Command for one column https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121727#M33524 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have the following database (see below). If I wanted to create a new spreadsheet containing only the CUSIP values what is the command to do this on SAS?</P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">DATE</TD><TD width="64">HSICMG</TD><TD width="64">COMNAM</TD><TD width="64">CUSIP</TD><TD width="64">DCLRDT</TD></TR><TR><TD align="right" height="20">19851231</TD><TD></TD><TD></TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860131</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860228</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860331</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860430</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860530</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860630</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860731</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860829</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19860930</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19861031</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19861128</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19861231</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870130</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870227</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870331</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870430</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870529</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19870630</TD><TD align="right">39</TD><TD>OPTIMUM MANUFACTURING INC</TD><TD align="right">68391610</TD><TD></TD></TR><TR><TD align="right" height="20">19851231</TD><TD></TD><TD></TD><TD align="right">36720410</TD><TD></TD></TR><TR><TD align="right" height="20">19860131</TD><TD align="right">49</TD><TD>GREAT FALLS GAS CO</TD><TD align="right">36720410</TD><TD></TD></TR><TR><TD align="right" height="20">19860228</TD><TD align="right">49</TD><TD>GREAT FALLS GAS CO</TD><TD align="right">36720410</TD><TD></TD></TR><TR><TD align="right" height="20">19860331</TD><TD align="right">49</TD><TD>GREAT FALLS GAS CO</TD><TD align="right">36720410</TD><TD align="right">19860207</TD></TR><TR><TD align="right" height="20">19860430</TD><TD align="right">49</TD><TD>GREAT FALLS GAS CO</TD><TD align="right">36720410</TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 21 May 2012 09:58:50 GMT https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121727#M33524 spraynardz90 2012-05-21T09:58:50Z Re: Command for one column https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121728#M33525 <HTML><HEAD></HEAD><BODY><P>data want /* the dataset name you create */</P><P>set have (keep=CUSIP);</P><P>run;</P><P>PROC EXPORT DATA= want</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUTFILE= "<SPAN style="color: #ff0000;">C:\temp\forum</SPAN>\want.xls"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS=EXCEL REPLACE;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SHEET="list";</P><P>RUN;</P><P></P><P>/*change the red part */</P></BODY></HTML> Mon, 21 May 2012 10:42:13 GMT https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121728#M33525 Linlin 2012-05-21T10:42:13Z Re: Command for one column https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121729#M33526 <HTML><HEAD></HEAD><BODY><P>Or :</P><P>You can apply that datastep option directly within proc export:</P><P></P><P>PROC EXPORT DATA= want(keep=CUSIP)</P><P></P><P>&nbsp; OUTFILE= "C:\temp\forum\want.xls"</P><P></P><P>&nbsp; DBMS=EXCEL REPLACE;</P><P></P><P>&nbsp; SHEET="list";</P><P></P><P>RUN;</P><P></P><P>Haikuo</P></BODY></HTML> Mon, 21 May 2012 12:20:20 GMT https://communities.sas.com/t5/SAS-Procedures/Command-for-one-column/m-p/121729#M33526 Haikuo 2012-05-21T12:20:20Z