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
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.
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.