I have the following set of data, and I am trying to do a regression analysis to show a table of predicted values and residuals for the dataset and then plot the residuals versus x on a scatter plot. I have the following code so far and will greatly appreciate any help!  DATA A; INPUT x y; cards; 10 8.04 8 6.95 13 7.58 9 8.81 11 8.83 14 9.96 6 7.24 4 4.26 12 10.84 7 4.82 5 5.68 ; proc reg data = A ; ods graphics on;  MODEL y = x; PLOT RESIDUAL. * x; run; quit; ... View more

I am trying to overlay two sets of data (one for males and one for females) on one scatterplot, but I don't know how to do this. I will greatly appreciate any input you can provide me on this matter. This is the code I have so far, but it plots the two sets of data on separate plots, and I want to fix this. Thank you!    CODE:  DATA female; INPUT mass rate; cards; 36.1 995 54.6 1425 48.5 1396 42.0 1418 40.3 1189 33.1 913 42.4 1124 34.5 1052 51.1 1347 41.2 1204 ; DATA male; INPUT m_mass m_rate; cards; 62.0 1792 62.9 1666 47.4 1362 48.7 1614 51.9 1460 51.9 1867 46.9 1439 ; proc sgplot data=female; scatter x=mass y=rate; proc sgplot data=male; scatter x= m_mass y= m_rate; run; ... View more

I have the following code, and when I run it, it gives me the following output graph, but I want to adjust my histogram so that the x-axis shows the values of sum_dices from {2, 3, 4, …, 12} and the y-axis is the corresponding percent for each sum_dice (i.e {2.78, 5.56, 8.33, …, 2.78} ). I tried to do this by setting the binwidth to 1 but it did not really change anything to my understanding. I am new to SAS so I will appreciate any help you can provide me. Thank you!  CODE:  data auto; do dice1= 1 to 6; do dice2= 1 to 6; sum_dices = sum(dice1, dice2); output; end; end; proc freq data = auto; proc sgplot data = auto; histogram sum_dices/ nbins = 10 binwidth = 1 showbins scale= count datalabel=percent; run;   OUTPUT:  ... View more

I need to adjust my code so that I can plot the percentage column of sum_dices in my histogram, but when I run it I get the following output. So instead of plotting the count of each sum, I want to plot the percentage such as 2.78 for 2, 5.56 for 3, and so forth. I have tried adjusting the VBAR line but could not get it to display the values I want. I am fairly new to SAS so I appreciate any help you can provide me, thanks!     DATA auto; INPUT dice1 dice2; sum_dices = sum(dice1, dice2); CARDS; 1 1 1 2 1 3 1 4 1 5 1 6 2 1 2 2 2 3 2 4 2 5 2 6 3 1 3 2 3 3 3 4 3 5 3 6 4 1 4 2 4 3 4 4 4 5 4 6 5 1 5 2 5 3 5 4 5 5 5 6 6 1 6 2 6 3 6 4 6 5 6 6 ; proc sgplot data=auto; VBAR sum_dices; proc freq data=auto; run; ... View more

I am trying to sum each line of data that I have below and create a histogram from the information, but I don't know how to approach this. For example, in line 1, I have the values 1 and 1 so I want to add 1+1 = 2, and then 1 + 2 = 3, and so on and so forth and then plot a histogram of the frequencies of each sum. I will appreciate any help with this. Thank you.  EDIT: I updated the variables for both to be numeric, but I want the frequencies to be the frequency of each sum expressed as a percentage of the total. For example, the sum 2 only shows up once when you toss two dice, so the percentage is 1/36 or 2.78%. I tried to do sum_dices = sum(dice1, dice2)/36; but it just changed the x-axis labels without changing the data.  DATA auto; INPUT dice1 dice2; sum_dices = sum(dice1, dice2); CARDS; 1 1 1 2 1 3 1 4 1 5 1 6 2 1 2 2 2 3 2 4 2 5 2 6 3 1 3 2 3 3 3 4 3 5 3 6 4 1 4 2 4 3 4 4 4 5 4 6 5 1 5 2 5 3 5 4 5 5 5 6 6 1 6 2 6 3 6 4 6 5 6 6 ; proc sgplot data=auto; VBAR sum_dices; run; ... View more

I imported an Excel file into my SAS program, but now I am having problems trying to graph the data. This is the code I have so far:   /* Generated Code (IMPORT) */ /* Source File: EG01-46IQ.xls */ /* Source Path: /folders/myfolders */ /* Code generated on: 1/31/19, 9:08 PM */ %web_drop_table(WORK.IMPORT); FILENAME REFFILE '/folders/myfolders/EG01-46IQ.xls'; PROC IMPORT DATAFILE=REFFILE DBMS=XLS OUT=WORK.IMPORT; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.IMPORT; RUN; %web_open_table(WORK.IMPORT); data WORK.INPUT;   The data is an Excel file of one column of numerical data. I do not know if I am supposed to use the datalines command or how to tell SAS what to do with the imported data. Any advice is much appreciated! 🙂 ... View more

Hi,   I am attempting to create a histogram in SAS using the following data:    data auto; input IQscore @@; datalines; 145 139 126 122 125 130 96 110 118 118 101 142 134 124 112 109 134 113 81 113 123 94 100 136 109 131 117 110 127 124 106 124 115 133 116 102 127 117 109 137 117 90 103 114 139 101 122 105 97 89 102 108 110 128 114 112 114 102 82 101 ; proc univariate data=auto noprint; histogram IQscore/midpoints=(80 to 150 by 10); run;   My issue is that when I run the program, it shows relative frequency of the data instead of the individual counts for the data (e.g. there are 16 counts of data in the interval between 105 and 115, but it showing 16/60(the total number of data)*100 = 26% instead when you examine the y-axis label). I also need help changing the axis labels. Any tips are appreciated, thanks! ... View more

Hi,   I am trying to create a stem-and-leaf plot of some data that I have but when I run the code, I get doubles for each stem value because the leaf value splits at 5. How can I stop this from occurring? Also, how can I sort the data in ascending order because currently the chart is printing in ascending order?    Here is the code I have so far:   DATA auto;   INPUT scf;   CARDS;   31   35   42   43   43   43   44   44   45   47   48   49   50   50   53   53   54   59   61   62   70   73   76   ; *PROC UNIVARIATE DATA=auto PLOTS; ods listing; ods graphics off; proc univariate data=auto plots;   VAR scf; run; quit;   I commented PROC UNIVARIATE DATA = auto PLOTS; out because I wasn't sure what the code does and it doesn't seem to change the output when I run it. I also need help printing the plot in ascending order because it is currently printing in descending order. I will appreciate any insight or input anyone can provide me. Thanks! ... View more

Hi,   I am trying to plot a bar graph using SAS, and so far I have the following code:    DATA auto ;   INPUT resource $  percent ; CARDS; Google 73.6 Library 13.6 Wikipedia 9.4 Other 3.4 ; TITLE 'Simple Vertical Bar Chart '; PROC SGPLOT DATA=auto; vbar resource; run; quit;   I am using the student version of SAS provided free through my university hence the usage of SGPLOT. When I run the code, however, instead of showing the percentages of each resource, it plots the frequencies so all the bars show as 1 unit length. I am trying to plot resources, the independent variable, vs the percentage, the dependent variable. I tried using vbar resource/ DISCRETE, but received an error message stating that I can only use DISCRETE to offset the bins. I would appreciate any tips and additional resources to consult as I am new to SAS. Thank you! ... View more