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 |
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 */
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.