Hi I have this code for GPLOT but I want to change it into SGPLOT as I think there's more options to make it look nicer. Here's the code I have and I need help transforming it into sgplot:   proc sort data = dataname; by Month Hour; run; proc summary data = dataname; by Month Hour; var Load; output out = means (drop = _:) mean = mean n = n stderr = stderr; run; symbol1 i = j value = W font = marker c = vivb h = 1 line = 1 width = 1; symbol2 i = j value = W font = marker c = bigb h = 1 line = 1 width = 1; symbol3 i = j value = W font = marker c = liolbr h = 1 line = 1 width = 1; symbol4 i = j value = W font = marker c = lilg h = 1 line = 1 width = 1; symbol5 i = j value = W font = marker c = vilg h = 1 line = 1 width = 1; symbol6 i = j value = W font = marker c = salmon h = 1 line = 1 width = 1; symbol7 i = j value = W font = marker c = vipk h = 1 line = 1 width = 1; symbol8 i = j value = W font = marker c = lippk h = 1 line = 1 width = 1; symbol9 i = j value = W font = marker c = strbr h = 1 line = 1 width = 1; symbol10 i = j value = W font = marker c = morbr h = 1 line = 1 width = 1; symbol11 i = j value = W font = marker c = debr h = 1 line = 1 width = 1; symbol12 i = j value = W font = marker c = bib h = 1 line = 1 width = 1; proc gplot data = means; axis1 order=(0 to 23 by 1); plot mean * Hour = Month / haxis=axis1; title 'Average Hourly Load for Every Month'; format Month run; Here's how it look with gplot:   ... View more

I am trying to do a scatterplot with two groups (5 PM and 4 AM) but it also shows overall over the groups making it messy. I have this: data dataname2; set dataname; if Hour in (17) then grouphour='5 P.M.'; if Hour in (4) then grouphour='4 P.M.'; run; proc sgplot data=dataname2; where Month in (6,7,8); where also Weekday in (1,2,3,4,5); scatter x=Xvar y=Yvar / group=grouphour; reg x=Xvar y=Yvar; title '5 P.M. vs 4 A.M. (summer)'; run; Also, is there an easier way to do this without making new dataset?   like group1 = Hour(17) group2 = Hour(4) or something like that? ... View more

Hi, I'm trying to import this and get bunch of errors, NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option.   data TempSens; input Hours TempOverall TempWeekday TempWeekend TempOnlyOverall TempOnlyWeekday TempOnlyWeekend; datalines; 0 1181.58 1202 1053.35 1270.79 1274.09 1254.24 1 1084.39 1104.84 928.33 1147.74 1146.98 1142.94 2 958.31 977.69 771.02 1048.51 1047.97 1043.56 3 883.7 875.97 736.7 974.75 977.42 964.86 4 840.9 816.9 662.26 926.5 932.06 910.03 5 727.75 702.67 474.03 906.06 918.84 880.75 6 658.79 615.33 451.39 896.33 914.61 867.25 7 597.46 564.57 486.98 975.3 993.87 928.69 8 726.09 714.17 646.15 1149.74 1166.15 1093.48 9 879.53 915.79 774.62 1317.47 1335.77 1268.14 10 1012.96 1062.58 936.94 1483.5 1491.71 1438.31 11 1034.43 1191.75 1089.25 1608.4 1617.72 1581.41 12 1016.05 1268.26 1189.04 1705.87 1716.57 1693.73 13 1216.37 1386.14 1300.35 1788.65 1789.41 1775.98 14 1268.96 1422.26 1410.39 1831.8 1828.56 1842.75 15 1401.76 1515.02 1440.35 1865.54 1868.93 1857.16 16 1461.36 1537.55 1448.48 1905.01 1911.01 1880.4 17 1482.57 1523.15 1506.55 1918.04 1920.86 1897.27 18 1476.11 1488.32 1515.91 1887.83 1895.68 1864.21 19 1433.55 1425.26 1375.38 1824.3 1838.29 1787.83 20 1248.45 1233.52 1169.79 1713.1 1731.22 1686.07 21 1357.83 1346.15 1280.56 1672.22 1691.01 1647.44 22 1398.25 1355.75 1330.37 1550.74 1557.28 1549.46 23 1336.89 1293.48 1276.3 1415.82 1425.18 1407.35 ; proc print data=TempSens; run; ... View more

If I run this code: proc sort data=dataname; where Month in (1,2,3); where also Day in (1,2,3); by Hour; run; proc reg data=dataname; where Month in (1,2,3); where also Day in (1,2,3); model Y=X; by Hour; run; And I get Regression results for every hour. Is there a way I can output slope of X for every hour into a new table or whatever? Anything just so I don't have to manually copy the slope (Parameter Estimates) into notepad? ... View more

Would you be able to tell me how to fix my double WHERE statement so it works?   proc reg data=datananame (where=(Month in (1,2,3)) and (Day in (1,2,3,4,5))); model Y=X; run; ... View more

Hi, I run this PROC REG to get results for every hour and I get this error and I miss a result for hour 23. ERROR: Data set WORK.MATT is not sorted in ascending sequence. The current BY group has Hour = 23 and the next BY group has Hour = 0. This is my code: proc sort data=matt (where=(Month in(6,7,8))); by Month Hour; run; proc reg data=matt (where=(Month in(6,7,8))); model Load=Temperature; by Hour; label Load="Load (MW)" Temperature="Temperature (degrees F)"; title 'Load vs Temperature (Summer)'; run; Also, I should be getting results for about 900 observation for every hour and only get about 250. What is wrong with my code?   ... View more