proc means data=practice.CompuStat_Execucomp noprint; by ; var avg_salary avg_bonus avg_optionawards; output out=practice.compensation_pie median= var= mean= /autoname; run;   Am I getting close?  ... View more

What i'm not understanding ( @PaigeMiller) is why I can get plots easily for other models in the same program. For example, this:  proc reg data=paper.ceo_firm plots(maxpoints=none); model salary=annual_return bonus stock_awards age male; run; Gives me the output i'm looking for.  ... View more

Are you referring to this?   proc format; value age_group low - 13 = 'Pre-Teen' 13 - 15 = 'Teen' 16 - high = 'Adult'; run; title 'Example of an applied format'; proc print data=sashelp.class; format age age_group.; run; data class; set sashelp.class; age_category = put(age, age_group.); label age_category = 'Age Category'; run; title 'Example of creating a new variable with the format'; proc print data=class; run; ... View more

I have never heard of write access--after a quick google search I am still confused?   Regardless, should I try different plots?   This one gave me a different error for example:   *Model A. level-level salary model controlling for industry (and other factors) // good fit; ods graphics on; proc reg data=paper.ceo_firm3 (maxpoints=none); model salary=annual_return bonus annual_return_VOL_thou stock_awards option_awards othcomp age male outdoors mining utilities construction wholesale information finance real_estate professional waste education healthcare arts food other manufacturing transportation retail VOL_thou / acov clb; run; ods graphics off; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 71 72 *Model A. level-level salary model controlling for industry (and other factors) // good fit; 73 ods graphics on; 74 proc reg data=paper.ceo_firm3 (maxpoints=none); _________ 22 ERROR 22-7: Invalid option name MAXPOINTS. 75 model salary=annual_return bonus annual_return_VOL_thou 76 stock_awards option_awards othcomp age male 77 outdoors mining utilities construction wholesale 78 information finance real_estate professional 79 waste education healthcare arts food other manufacturing transportation retail VOL_thou / acov clb; NOTE: The previous statement has been deleted. 80 run; WARNING: No variables specified for an SSCP matrix. Execution terminating. NOTE: PROCEDURE REG used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 3412.09k OS Memory 33984.00k Timestamp 04/30/2018 02:33:47 PM Step Count 70 Switch Count 0 Page Faults 0 Page Reclaims 477 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 48 81 ods graphics off; 82 83 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 95 ... View more

I having trouble envisioning what the  /folder/subfolder/subsubfolder might look like. Should this be the file path of my SAS program? ... View more

Ah good point. Something is still wrong though. Here's the code I ran:   *Model A. level-level salary model controlling for industry (and other factors) // good fit; ods graphics on; ods html; proc reg data=paper.ceo_firm3 plots=all; model salary=annual_return bonus annual_return_VOL_thou stock_awards option_awards othcomp age male outdoors mining utilities construction wholesale information finance real_estate professional waste education healthcare arts food other manufacturing transportation retail VOL_thou / acov clb; run; ods graphics off; and the log that followed:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 71 72 *Model A. level-level salary model controlling for industry (and other factors) // good fit; 73 ods graphics on; 74 ods html; NOTE: Writing HTML Body file: sashtml5.htm ERROR: Insufficient authorization to access /pbr/biconfig/940/Lev1/SASApp/sashtml5.htm. ERROR: No body file. HTML output will not be created. 75 proc reg data=paper.ceo_firm3 plots=all; 76 model salary=annual_return bonus annual_return_VOL_thou 77 stock_awards option_awards othcomp age male 78 outdoors mining utilities construction wholesale 79 information finance real_estate professional 80 waste education healthcare arts food other manufacturing transportation retail VOL_thou / acov clb; 81 run; WARNING: ODS graphics with more than 5000 points have been suppressed. Use the PLOTS(MAXPOINTS= ) option in the PROC REG statement to change or override the cutoff. 82 ods graphics off; 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 96 I also tried this without the  ods html; piece, and that made the error go away, but I still did not see any residual plots.    Any ideas @PaigeMiller ? ... View more

I added a plots statement (thanks for the tip) but am still not seeing anything.   *Model A. level-level salary model controlling for industry (and other factors) // good fit; proc reg data=paper.ceo_firm3 plots=all; model salary=annual_return bonus annual_return_VOL_thou stock_awards option_awards othcomp age male outdoors mining utilities construction wholesale information finance real_estate professional waste education healthcare arts food other manufacturing transportation retail VOL_thou / acov clb; run; ... View more

@Reeza , so in order to get this pie chart I need a variable that consists of the different average values which will make up the pie "slices," yes? I know how to compute the averages, but how do I create a variable that consists of just those values so that I can do the pie chart? Here's where i'm at:   libname practice "~/425/425_Final_Paper"; *import compustat dataset; PROC IMPORT out=practice.CompuStat_Execucomp datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv" DBMS=CSV replace; getnames=yes; guessingrows=2000; run; proc contents data=practice.CompuStat_Execucomp; run; proc means data=practice.CompuStat_Execucomp; var salary; output out=avg mean=avg_salary; run; proc means data=practice.CompuStat_Execucomp; var bonus; output out=avg mean=avg_bonus; run; proc means data=practice.CompuStat_Execucomp; var option_awards; output out=avg mean=avg_optionawards; run; Again, I want to show the composition of CEO compensation, broken down into just these three or maybe 4 or 5 (if I include other measure) categories.  ... View more