cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sastuck
‎05-08-2018
  • 184 Posts
  • 59 Likes Given
  • 2 Solutions
  • 3 Likes Received

Re: Pie Chart

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 03:42 PM
‎04-25-2018 03:42 PM
So I'm looking at this code for reference:   PROC SORT DATA = sashelp.class OUT = class; BY age; RUN; PROC TEMPLATE; DEFINE STATGRAPH pie; BEGINGRAPH; LAYOUT REGION; PIECHART CATEGORY = age / DATALABELLOCATION = OUTSIDE CATEGORYDIRECTION = CLOCKWISE START = 180 NAME = 'pie'; DISCRETELEGEND 'pie' / TITLE = 'Age'; ENDLAYOUT; ENDGRAPH; END; RUN; PROC SGRENDER DATA = class TEMPLATE = pie; RUN; What is my BY variable? How do I prepare my data for it to work using this kind of code? Not sure where to begin.  ... View more

Pie Chart

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 02:47 PM
‎04-25-2018 02:47 PM
Hello again everybody,   For my descriptive statistics section I want to have a pie chart that shows the breakdown of CEO compensation. I have data on everything from salary and bonus, to stock and option awards.    This is what the data look like:       0030B Gregory S. Daily   1 0 0 0   29716 IPAYMENT INC Co-founder, Chairman and Chief Executive Officer CEO 708 0 0 0 0 0 16.5 724.5 708 724.5 724.5 0 0 . . . . 0 0 0 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1   724.5 724.5             277.6 -40.379 -39.182 -39.182 -39.182 -39.182 -39.182     151832 14220 2010   20010201 .   20110523 .       Co-Founder   Daily Gregory S. MALE Mr. 57 4.63E+97 OTH 126 East 56th Street New York NY 10022 212-802-7200 BUSINESS SERVICES, NEC Financial Transactions Processing, Reserve, and Cl Data Processing & Outsourced Services EX 212 522320 4510 7389 0030B Carl A. Grimstad   0 0 0 0   29717 IPAYMENT INC Co-Founder, Chairman, Chief Executive Officer and President CEO 1000 1000 0 0 0 0 83.5 2083.5 2000 2083.5 2083.5 0 0 . . . . 0 0 0 0 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1   2083.5 2083.5             41.243 182.486 194.28 . . . .     151832 28609 2011   20110523 .   . .   CEO   Co-Founder, Chairman, Chief Executive Officer and President   Grimstad Carl A. MALE Mr. 49 4.63E+97 OTH 126 East 56th Street New York NY 10022 212-802-7200 BUSINESS SERVICES, NEC Financial Transactions Processing, Reserve, and Cl Data Processing & Outsourced Services EX 212 522320 4510 7389 0030B Carl A. Grimstad   0 0 0 0   29717 IPAYMENT INC Co-Founder, Chairman, Chief Executive Officer and President CEO 1001.605 775 0 0 0 0 182.333 1958.938 1776.605 1958.938 1958.938 0 0 . . . . 0 0 0 0 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1   1958.938 1958.938             0.161 -11.17 -5.978 -5.978 -5.978 -5.978 -5.978     151832 28609 2012   20110523 .   . .   CEO   Co-Founder, Chairman, Chief Executive Officer and President   Grimstad Carl A. MALE Mr. 49 4.63E+97 OTH 126 East 56th Street New York NY 10022 212-802-7200 BUSINESS SERVICES, NEC Financial Transactions Processing, Reserve, and Cl Data Processing & Outsourced Services EX 212 522320 4510 7389 0030B Carl A. Grimstad   0 0 0 0   29717 IPAYMENT INC Co-Founder, Chairman, Chief Executive Officer and President CEO 1011.04 1200 0 0 0 0 225.527 2436.567 2211.04 2436.567 2436.567 0 0 . . . . 0 0 0 0 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1   2436.567 2436.567             0.942 24.453 24.382 24.382 24.382 24.382 24.382     151832 28609 2013   20110523 .   . .   CEO   Co-Founder, Chairman, Chief Executive Officer and President   Grimstad Carl A. MALE Mr. 49 4.63E+97 OTH 126 East 56th Street New York NY 10022 212-802-7200 BUSINESS SERVICES, NEC Financial Transactions Processing, Reserve, and Cl Data Processing & Outsourced Services EX 212 522320 4510 7389 0033A John F. Young   1 0 0 0   38315 ENERGY FUTURE HOLDINGS CORP Chief Executive Officer, President, Director, Member of Executive Committee, Member of Governance & Public Affairs Committee, Chief Executive Officer of Energy Future Intermediate Holding Company Llc CEO 1200 0 0 3405 2043.6 2.761 210.826 6862.187 1200 6862.187 5407.187 9905.313 13080.659 5062.009 . 1012.009 . 0 0 600 1950 54 3000 3405 0 3675 4200 0 0 0 0 0 0 36.074 0 0 0 27.686 0 309.402 0 1   6859.426 3454.426             20 20 166.566 166.566 110.046 166.459 34.189     10507 29712 2010   20080129 20080101   . .   CEO   Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company LLC, Chief Executive Officer of Energy Future Competitive Holdings C   Young John F. MALE Mr. 61 29299Z00 OTH 1601 Bryan Street, Energy Plaza Dallas TX 75201 214-812-4600 ELECTRIC SERVICES Electric Power Generation, Transmission and Distri Independent Power Producers & Energy Traders EX 214 2211 5510 4911 0033A John F. Young   1 0 0 0   38315 ENERGY FUTURE HOLDINGS CORP Chief Executive Officer, President, Director, Member of Executive Committee, Member of Governance & Public Affairs Committee, Chief Executive Officer of Energy Future Intermediate Holding Company Llc CEO 1200 0 5347.5 0 8468.6 3.123 105.484 15124.707 1200 15124.707 9777.207 15305.193 21650.965 1012.222 . 1012.222 . 0 0 0 0 55 6000 5347.5 0 0 0 0 0 6000 3000 0 0 39.197 0 0 6740.6 -7.57 0 7042.432 0 2   15121.584 9774.084             0 0 120.407 120.407 80.819 120.45 182.944     10507 29712 2011   20080129 20080101   . .   CEO   Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company LLC, Chief Executive Officer of Energy Future Competitive Holdings C   Young John F. MALE Mr. 61 29299Z00 OTH 1601 Bryan Street, Energy Plaza Dallas TX 75201 214-812-4600 ELECTRIC SERVICES Electric Power Generation, Transmission and Distri Independent Power Producers & Energy Traders EX 214 2211 5510 4911 0033A John F. Young   1 0 0 0   38315 ENERGY FUTURE HOLDINGS CORP Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company Llc, Chief Executive Officer of Energy Future Competitive Holdings Company CEO 1200 0 525 0 4968 4.337 72.848 6770.185 1200 6770.185 6245.185 12733.854 17289.516 1012.222 . 1012.222 . 0 0 0 0 56 0 0 525 0 0 0 0 7500 3000 0 0 0 168.173 0 2700 41.544 5990.6 3668.736 0 2   6765.848 6765.848             0 0 -55.238 -55.238 -36.125 -55.257 -30.778     10507 29712 2012   20080129 20080101   . .   CEO   Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company LLC, Chief Executive Officer of Energy Future Competitive Holdings C   Young John F. MALE Mr. 61 29299Z00 OTH 1601 Bryan Street, Energy Plaza Dallas TX 75201 214-812-4600 ELECTRIC SERVICES Electric Power Generation, Transmission and Distri Independent Power Producers & Energy Traders EX 214 2211 5510 4911 0033A John F. Young   1 0 0 0   38315 ENERGY FUTURE HOLDINGS CORP Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company LLC, Chief Executive Officer of Energy Future Competitive Holdings Company CEO 1350 0 420 0 5511.375 0 73.152 7354.527 1350 7354.527 6934.527 14177.643 17552.643 1012.222 . 1012.222 . 0 0 0 0 57 0 0 420 0 0 0 0 9000 0 0 0 0 0 0 2700 46.435 750 5665.171 0 2   7354.527 7354.527             12.5 12.5 8.631 8.631 11.038 8.701 8.701     10507 29712 2013   20080129 20080101   . .   CEO   Chief Executive Officer, President, Director, Member of Executive Committee, Chief Executive Officer of Energy Future Intermediate Holding Company LLC, Chief Executive Officer of Energy Future Competitive Holdings C   Young John F. MALE Mr. 61 29299Z00 OTH 1601 Bryan Street, Energy Plaza Dallas TX 75201 214-812-4600 ELECTRIC SERVICES Electric Power Generation, Transmission and Distri Independent Power Producers & Energy Traders EX 214 2211 5510 4911   Wow, I wish there was a better way to do that.   Anyway,  I found the following code online:   /* Set the graphics environment */ goptions reset=all cback=white border htitle=12pt htext=10pt; title1 "Types of Vehicles Produced Worldwide"; proc gchart data=sashelp.cars; pie type / other=0 midpoints="Truck" "SUV" "Sedan" "Wagon" "Sports" "Hybrid" value=none percent=arrow slice=arrow noheading plabel=(font='Albany AMT/bold' h=1.3 color=depk); run; quit; I am not really seeing from this example how they incorporate the data from for the pie chart. I can easily replace  data=sashelp.cars; for  data=paper.compustat_execucomp4 but past that I am a little lost. My experience in data visualization basically consists of scatterplots and histograms thus far, so any help is appreciated!   Thanks as always!   -SAStuck ... View more

Re: categorical variable

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 02:16 PM
‎04-25-2018 02:16 PM
It is in the dataset. I just want to use it to create the categorical variables ... View more

Scaling a variable

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 02:05 PM
‎04-25-2018 02:05 PM
I'm trying to scale my variable for volume so that my regression coefficient is more interpretable.    This code, however, just gives me a table with only the variable volume as opposed to the full data set:   data ceo_firm2; set ceo_firm2; VOL=VOL/1000; run; I was afraid I messed something up so I signed out without saving. What's going on here? What's a good way of doing this if I want to try scaling it by other amounts as well (for comparison's sake)?    Thanks! ... View more

Re: categorical variable

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 01:36 PM
‎04-25-2018 01:36 PM
i'm mentioning ticker and coname because in the end I want this data to be in my ceo_firm dataset. I'm not understanding how the code you shared would get the naics data into this new ceo_firm3 data set. Please enlighten me! ... View more

Re: categorical variable

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 11:15 AM
‎04-25-2018 11:15 AM
Thanks for the heads up @Reeza! How would I merge the census's data into my data set without any additional information on the company though, like TICKER or CONAME? ... View more

categorical variable

by Pyrite | Level 9 in SAS Studio
‎04-25-2018 09:42 AM
‎04-25-2018 09:42 AM
Hey!   I am trying to create a categorical variable for different industries using NAICS code. Naics.com identifies 20 different industries:   11 Agriculture, Forestry, Fishing and Hunting   21 Mining   22 Utilities   23 Construction   31-33 Manufacturing   42 Wholesale Trade   44-45 Retail Trade   48-49 Transportation and Warehousing   51 Information   52 Finance and Insurance   53 Real Estate Rental and Leasing   54 Professional, Scientific, and Technical Services   55 Management of Companies and Enterprises   56 Administrative and Support and Waste Management and Remediation Services   61 Educational Services   62 Health Care and Social Assistance   71 Arts, Entertainment, and Recreation   72 Accommodation and Food Services   81 Other Services (except Public Administration)   92 Public Administration   The data look just like the above codes--no extra zeros or anything.    Without looking too scrupulously at the codes themselves, is this the right idea?    *create categorical variable for industry; data paper.ceo_firm3; set paper.ceo_firm2; if NAICS=11 then industry=outdoors; if NAICS=21 then industry=mining; if NAICS=22 then industry=utilities; if NAICS=23 then industry=construction; if NAICS=31 then industry=manufacturing; if NAICS=32 then industry=manufacturing; if NAICS=33 then industry=manufacturing; if NAICS=42 then industry=wholesale; if NAICS=44 then industry=retail; if NAICS=45 then industry=retail; if NAICS=48 then industry=transportation; if NAICS=49 then industry=transportation; if NAICS=51 then industry=information; if NAICS=52 then industry=finance; if NAICS=53 then industry=real_estate; if NAICS=54 then industry=professional; if NAICS=55 then industry=management; if NAICS=56 then industry=waste; if NAICS=61 then industry=education; if NAICS=62 then industry=healthcare; if NAICS=71 then industry=arts; if NAICS=72 then industry=food; if NAICS=81 then industry=other; if NAICS=92 then industry=public_admin; run; Thanks for the feedback!   -SAStuck     ... View more

Re: Viewing tables without running old code

by Pyrite | Level 9 in SAS Studio
‎04-24-2018 08:24 PM
‎04-24-2018 08:24 PM
If this is the case, then which line of code would you recommend I run so as to recreate the work table (?) ceo_firm2 ? Here's the program:    libname paper "~/425/425_Final_Paper"; *import compustat dataset; PROC IMPORT out=paper.CompuStat_Execucomp datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv" DBMS=CSV replace; getnames=yes; guessingrows=2000; run; *keep only CEOs; data paper.Compustat_ExecuComp2; set paper.Compustat_ExecuComp; if CEOANN='CEO'; run; *** extra DATA step for checking previous data step results by comparing number of records selected; data check_CEOANN; set paper.Compustat_ExecuComp; if CEOANN=: 'CEO'; run; proc sort data=paper.Compustat_ExecuComp2; by ticker year; run; *import csrp dataset; PROC IMPORT out=paper.CSRP_Monthly_Stock_char datafile="~/425/425_Final_Paper/CSRP_MonthlyStock_char.csv" DBMS=CSV replace; getnames=yes; guessingrows=max; run; proc contents data=paper.CSRP_Monthly_Stock_char; run; *remove bad data; data paper.CSRP_Monthly_Stock_char2; set paper.CSRP_Monthly_Stock_char (rename=(ret=character_ret)); drop character_ret; if cusip=' ' then delete; ret=input(character_ret, ??8.); if ret=. then delete; date=input(put(date, z8.), yymmdd8.); format date yymmdd10.; year=year(date); month=month(date); if cusip=: '?' then cusip=substr(cusip, 2); run; proc contents data=paper.CSRP_Monthly_Stock_char; run; proc contents data=paper.CSRP_Monthly_Stock_char2; run; proc contents data=paper.multiple_CEOs; run; proc sort data=paper.CSRP_Monthly_Stock_char2; by ticker year; run; proc sort data=paper.Compustat_ExecuComp2; by ticker year; run; *Remove all bad years from both data sources; data paper.Compustat_ExecuComp3; length ticker $5; merge paper.Compustat_ExecuComp2 paper.multiple_CEOs (keep=ticker year in=had_multiple_CEOs); by ticker year; if had_multiple_CEOs then delete; run; data paper.CSRP_Monthly_Stock_char3; merge paper.CSRP_Monthly_Stock_char2 paper.multiple_CEOs (keep=ticker year in=had_multiple_CEOs); by ticker year; if had_multiple_CEOs then delete; run; *find additional bad data: multiple return records for the same month/year; proc freq data=paper.CSRP_Monthly_Stock_char3; tables ticker * year * month / noprint out=paper.multiple_returns (where=(count > 1)); run; *Remove all matching year data for multiple returns; proc sort data=paper.multiple_returns out=multiple_returns (keep=ticker year) NODUPKEY; by ticker year; run; data paper.Compustat_ExecuComp4; merge paper.Compustat_ExecuComp3 (in=keepme) multiple_returns (in=had_multiple_returns); by ticker year; if keepme; if had_multiple_returns then delete; run; data paper.CSRP_Monthly_Stock_char4; length ticker $5; merge paper.CSRP_Monthly_Stock_char3 multiple_returns (in=had_multiple_returns); by ticker year; if had_multiple_returns then delete; run; proc contents data=paper.CSRP_Monthly_Stock_char3; run; proc contents data=paper.CSRP_Monthly_Stock_char4; run; *create new variable annualized growth; data paper.CSRP_annual_returns; set paper.CSRP_Monthly_Stock_char4; by ticker year; retain annual_return 1; annual_return=annual_return * (1 + RET); if month=12 or last.ticker; annual_return=(annual_return - 1) * 100; output; annual_return=1; keep ticker year annual_return; run; *use proc contents to see if there is a type mismatch; proc contents data=paper.CSRP_annual_returns; run; proc contents data=paper.Compustat_ExecuComp4; run; *MERGE statement has more than one data set with repeats of BY values; proc sort data=paper.CSRP_annual_returns out=paper.CSRP_annual_returns2 nodupkey; by ticker; run; *Merge CEO data and firm data; DATA paper.ceo_firm; length ticker $5; merge paper.CSRP_annual_returns2 (in=in1) paper.compustat_execucomp4 (in=in2); by ticker; if in1 and in2; run; proc contents data=paper.ceo_firm; run; proc contents data=paper.ceo_firm2; run; *remove missing return data; data paper.ceo_firm; set paper.ceo_firm; if annual_return=. then delete; run; proc means data=paper.CSRP_Monthly_Stock_char3 n nmiss; var ret; run; proc means data=paper.Compustat_ExecuComp4 n nmiss; var salary; run; proc means data=paper.CSRP_annual_returns n nmiss; var annual_return; run; data paper.ceo_firm; set paper.ceo_firm (rename=(BONUS=_BONUS STOCK_AWARDS=_STOCK_AWARDS)); BONUS=input(_BONUS, ?? 8.); STOCK_AWARDS=input(_STOCK_AWARDS, ?? 8.); run; data paper.ceo_firm2; set paper.ceo_firm2 (rename=(othcomp=_othcomp)); othcomp=input(_othcomp, ?? 8.); run; *create dummy variable that indicates whether the firm's market value increases in a given year; data paper.ceo_firm; set paper.ceo_firm; by ticker year; last_return=lag(annual_return); if not first.ticker then increase=(annual_return > last_return); else increase=.; run; *create dummy variable that indicates whether the CEO is male or female; data paper.ceo_firm; set paper.ceo_firm; if gender='MALE' then male=1; else male=0; run; *bring variable in from other data set; proc sql; create table paper.ceo_firm2 as select a.* , b.VOL from paper.ceo_firm as a left join (select ticker ,year ,sum(VOL) as VOL from paper.CSRP_Monthly_Stock_char4 group by ticker ,year ) as b on a.ticker = b.ticker and a.year = b.year; quit; /* CHECK FOR DUPLICATES */ data is_dup; set paper.CSRP_Monthly_Stock_char4; /* dataset origin containing var to add VOL ? */ by ticker year; if not (first.year and last.year); run; *find duplicates: ticker/year combo; proc freq data=paper.CSRP_Monthly_Stock_char4; tables ticker * year / noprint out=paper.multiple_tyCSRP (where=(count > 1)); run; proc freq data=paper.ceo_firm; tables ticker * year / noprint out=paper.multiple_tyfirm (where=(count > 1)); run; *create variable log_salary; data paper.ceo_firm; set paper.ceo_firm; if salary=0 then log_salary=0; else log_salary=log(salary); run; *create variable log_annual_return; data paper.ceo_firm; set paper.ceo_firm; if annual_return=0 then log_annual_return=0; else log_annual_return=log(annual_return); run; *create variable log_bonus; data paper.ceo_firm; set paper.ceo_firm; if bonus=0 then log_bonus=0; else log_bonus=log(bonus); run; *create variable log_TOTAL_SEC; data paper.ceo_firm; set paper.ceo_firm; if TOTAL_SEC=0 then log_TOTAL_SEC=0; else log_TOTAL_SEC=log(TOTAL_SEC); run; *create interaction term; data paper.ceo_firm2; set paper.ceo_firm2; annual_return_VOL=(annual_return*VOL); run; Thanks!   -SAStuck ... View more

Viewing tables without running old code

by Pyrite | Level 9 in SAS Studio
‎04-24-2018 06:56 PM
‎04-24-2018 06:56 PM
Hello!   The title speaks for itself here. I would like to see output tables for investigative purposes but without having to go back and re-run the code that created the table to begin with. Is there a simple way to view the tables in my program?   Thanks!   -SAStuck     ... View more

Re: Quick way to look at extremes in dataset

by Pyrite | Level 9 in SAS Studio
‎04-18-2018 09:45 AM
‎04-18-2018 09:45 AM
Wow, this works great! Thanks! ... View more

Re: Quick way to look at extremes in dataset

by Pyrite | Level 9 in SAS Studio
‎04-18-2018 09:28 AM
‎04-18-2018 09:28 AM
Thanks! This is the code that worked: *find max; proc sql; select * from paper.ceo_firm2 having vol = max(vol); quit; ... View more

Re: Quick way to look at extremes in dataset

by Pyrite | Level 9 in SAS Studio
‎04-18-2018 09:21 AM
‎04-18-2018 09:21 AM
What if I don't want to create a new table but just want to look at the table I already have? I only included that  paper.ceo_firm2  because I assumed I needed to give SAS a place to look for the data I wanted to look at. Because I don't see the need to create a new table for this purpose.  ... View more

Re: Quick way to look at extremes in dataset

by Pyrite | Level 9 in SAS Studio
‎04-18-2018 09:15 AM
‎04-18-2018 09:15 AM
Hey,   Thanks for the help! What am I missing here? *find max; proc sql data=paper.ceo_firm2; select * from ticker having vol = max(vol); quit; here's the log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 proc sql data=paper.ceo_firm2; ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, CHECK, CODEGEN, CONSTDATETIME, DICTDIAG, DOUBLE, DQUOTE, ERRORSTOP, EXEC, EXITCODE, FEEDBACK, FLOW, INOBS, IPASSTHRU, LOOPS, NOCHECK, NOCODEGEN, NOCONSTDATETIME, NODICTDIAG, NODOUBLE, NOERRORSTOP, NOEXEC, NOFEEDBACK, NOFLOW, NOIPASSTHRU, NONUMBER, NOPRINT, NOPROMPT, NOREMERGE, NOSORTMSG, NOSTIMER, NOSTOPONTRUNC, NOTHREADS, NOWARNRECURS, NUMBER, OUTOBS, PRINT, PROMPT, REDUCEPUT, REDUCEPUTOBS, REDUCEPUTVALUES, REMERGE, SORTMSG, SORTSEQ, STIMER, STOPONTRUNC, THREADS, UBUFSIZE, UNDO_POLICY, WARNRECURS. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 72 select * from ticker 73 having vol = max(vol); ERROR: File WORK.TICKER.DATA does not exist. 74 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 57.43k OS Memory 26276.00k Timestamp 04/18/2018 01:14:05 PM Step Count 29 Switch Count 0 Page Faults 0 Page Reclaims 70 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 75 76 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 Thanks! ... View more

Quick way to look at extremes in dataset

by Pyrite | Level 9 in SAS Studio
‎04-18-2018 08:50 AM
‎04-18-2018 08:50 AM
Hello SAS community,   I am working on my descriptive statistics section of a term paper (undergrad) and I am looking for different creative ways to look at my data and learn more about it using proc sgplot, and proc univariate, and whatever other tools SAS offers. (So far I have summary statistics, a few histograms, and a scatterplot. Nothing too special.) One thing specifically I would like to do is be able to see an outlier in, say, a scatter plot, and then go to the dataset and find that observation. The only thing is, I don't want to manipulate the data itself for fear of accidentally altering it in some way. Is there a way to find these max or min values and view the data itself? All in all, I just want to get to know my data better and have a more thorough descriptive statistics section. Any help is appreciated. In case this is helpful, one of my data sets is firm performance (annual return, volume, etc.) and the other is CEO performance (salary, bonus, stock options, etc.) I am estimating the effect of changes in firm performance on CEO salary.    Thanks for your time!   -SAStuck ... View more

Re: Need select variable from other data set in a particular dataset

by Pyrite | Level 9 in SAS Studio
‎04-15-2018 09:27 AM
‎04-15-2018 09:27 AM
@SASKiwi helped me out, by the way. In case you're curious, here's the code he came up with:   proc sql; create table ceo_firm as select a.* , b.VOL from paper.ceo_firm as a left join (select ticker ,year ,sum(VOL) as VOL from paper.CSRP_Monthly_Stock_char4 group by ticker ,year ) as b on a.ticker = b.ticker and a.year = b.year; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-08-2018 09:53 PM
Likes given to
Likes from
View All
Quick links