Command for one column

[spraynardz90]

Hi

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?

DATE	HSICMG	COMNAM	CUSIP	DCLRDT
19851231			68391610
19860131	39	OPTIMUM MANUFACTURING INC	68391610
19860228	39	OPTIMUM MANUFACTURING INC	68391610
19860331	39	OPTIMUM MANUFACTURING INC	68391610
19860430	39	OPTIMUM MANUFACTURING INC	68391610
19860530	39	OPTIMUM MANUFACTURING INC	68391610
19860630	39	OPTIMUM MANUFACTURING INC	68391610
19860731	39	OPTIMUM MANUFACTURING INC	68391610
19860829	39	OPTIMUM MANUFACTURING INC	68391610
19860930	39	OPTIMUM MANUFACTURING INC	68391610
19861031	39	OPTIMUM MANUFACTURING INC	68391610
19861128	39	OPTIMUM MANUFACTURING INC	68391610
19861231	39	OPTIMUM MANUFACTURING INC	68391610
19870130	39	OPTIMUM MANUFACTURING INC	68391610
19870227	39	OPTIMUM MANUFACTURING INC	68391610
19870331	39	OPTIMUM MANUFACTURING INC	68391610
19870430	39	OPTIMUM MANUFACTURING INC	68391610
19870529	39	OPTIMUM MANUFACTURING INC	68391610
19870630	39	OPTIMUM MANUFACTURING INC	68391610
19851231			36720410
19860131	49	GREAT FALLS GAS CO	36720410
19860228	49	GREAT FALLS GAS CO	36720410
19860331	49	GREAT FALLS GAS CO	36720410	19860207
19860430	49	GREAT FALLS GAS CO	36720410

[Linlin]

data want /* the dataset name you create */

set have (keep=CUSIP);

run;

PROC EXPORT DATA= want

            OUTFILE= "C:\temp\forum\want.xls"

            DBMS=EXCEL REPLACE;

     SHEET="list";

RUN;

/*change the red part */

[Haikuo]

Or :

You can apply that datastep option directly within proc export:

PROC EXPORT DATA= want(keep=CUSIP)

  OUTFILE= "C:\temp\forum\want.xls"

  DBMS=EXCEL REPLACE;

  SHEET="list";

RUN;

Haikuo