BookmarkSubscribeRSS Feed
spraynardz90
Calcite | Level 5

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?

DATEHSICMGCOMNAMCUSIPDCLRDT
1985123168391610
1986013139OPTIMUM MANUFACTURING INC68391610
1986022839OPTIMUM MANUFACTURING INC68391610
1986033139OPTIMUM MANUFACTURING INC68391610
1986043039OPTIMUM MANUFACTURING INC68391610
1986053039OPTIMUM MANUFACTURING INC68391610
1986063039OPTIMUM MANUFACTURING INC68391610
1986073139OPTIMUM MANUFACTURING INC68391610
1986082939OPTIMUM MANUFACTURING INC68391610
1986093039OPTIMUM MANUFACTURING INC68391610
1986103139OPTIMUM MANUFACTURING INC68391610
1986112839OPTIMUM MANUFACTURING INC68391610
1986123139OPTIMUM MANUFACTURING INC68391610
1987013039OPTIMUM MANUFACTURING INC68391610
1987022739OPTIMUM MANUFACTURING INC68391610
1987033139OPTIMUM MANUFACTURING INC68391610
1987043039OPTIMUM MANUFACTURING INC68391610
1987052939OPTIMUM MANUFACTURING INC68391610
1987063039OPTIMUM MANUFACTURING INC68391610
1985123136720410
1986013149GREAT FALLS GAS CO36720410
1986022849GREAT FALLS GAS CO36720410
1986033149GREAT FALLS GAS CO3672041019860207
1986043049GREAT FALLS GAS CO36720410
2 REPLIES 2
Linlin
Lapis Lazuli | Level 10

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
Onyx | Level 15

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 633 views
  • 0 likes
  • 3 in conversation