I am not getting an output. Receiving an error stating All values missing for plot of PayrollAW*AttendanceAW
I am brand new this so any advice you be appreciated.
Data Homework4;
input Team $ AttendanceAW PayrollAW;
Datalines;
ARI 2,134,375 $106,580,200
ATL 2,505,252 $119,705,250
BAL 2,028,424 $161,621,633
BOS 2,917,678 $200,550,750
CHC 3,199,562 $177,210,667
CHW 1,629,470 $97,842,000
CIN 1,836,917 $79,315,786
CLE 2,048,138 $114,427,167
COL 2,953,650 $106,650,000
DET 2,321,599 $118,375,600
HOU 2,403,671 $157,656,400
KCR 2,220,370 $127,555,817
LAA 3,019,585 $181,125,500
LAD 3,765,856 $201,466,263
MIA 1,583,014 $111,591,100
MIL 2,627,705 $68,439,300
MIN 2,051,279 $103,932,500
NYM 2,460,622 $176,615,252
NYY 3,154,938 $182,424,700
OAK 1,475,721 $51,560,000
PHI 1,905,354 $86,276,000
PIT 1,919,447 $102,953,333
SDP 2,138,491 $49,248,767
SEA 2,135,445 $172,438,700
SFG 3,303,652 $177,399,833
STL 3,448,337 $129,652,933
TBR 1,253,619 $79,473,033
TEX 2,507,760 $207,326,274
TOR 3,203,886 $158,890,575
;
proc plot;
Title "PayrollAW as a function of AttendanceAW";
plot PayrollAW*AttendanceAW;
run;
Please try the below code as an example
proc gplot data=sashelp.class;
plot height*weight;
run;
thanks
You miss the informats of the numeric variables.
Try change your code to:
Data Homework4;
input Team $ AttendanceAW comma14. PayrollAW dollar14.;
Datalines;
... your data ...
; run;
Thank you at least it gave me a plot chart.
Can you please explain the comma14. and dollar14. being used.
thanks
@Allen799 wrote:
Thank you at least it gave me a plot chart.
Can you please explain the comma14. and dollar14. being used.
thanks
Here is your original code with one data row:
Data Homework4;
input Team $ AttendanceAW PayrollAW;
Datalines;
ARI 2,134,375 $106,580,200
use next code to check your result dataset. Be sure data was read correctly.
proc print data=homework4(obs=20); run; /* check first 20 data rows */
you will get Team = 'ARI', AttendanceAW = . , PayrollAW = .
thus because 2,134,375 is not numeric. By using the informat comma10. sas ignores the commas.
10 defines the input variable value length, that is 10 characters. BY using comma14. sas expects at most 14 characters.
similar to above, $106,580,200 is also not numeric. By using the informat dollar12. sas ignores the $ sign and the commas.
Your data set is not being read in correctly for some reason. Are you actually reading in from data lines?
Please post the log with the actual error.
@Allen799 wrote:
I am not getting an output. Receiving an error stating All values missing for plot of PayrollAW*AttendanceAW
I am brand new this so any advice you be appreciated.
Data Homework4;
input Team $ AttendanceAW PayrollAW;
Datalines;
ARI 2,134,375 $106,580,200
ATL 2,505,252 $119,705,250
BAL 2,028,424 $161,621,633
BOS 2,917,678 $200,550,750
CHC 3,199,562 $177,210,667
CHW 1,629,470 $97,842,000
CIN 1,836,917 $79,315,786
CLE 2,048,138 $114,427,167
COL 2,953,650 $106,650,000
DET 2,321,599 $118,375,600
HOU 2,403,671 $157,656,400
KCR 2,220,370 $127,555,817
LAA 3,019,585 $181,125,500
LAD 3,765,856 $201,466,263
MIA 1,583,014 $111,591,100
MIL 2,627,705 $68,439,300
MIN 2,051,279 $103,932,500
NYM 2,460,622 $176,615,252
NYY 3,154,938 $182,424,700
OAK 1,475,721 $51,560,000
PHI 1,905,354 $86,276,000
PIT 1,919,447 $102,953,333
SDP 2,138,491 $49,248,767
SEA 2,135,445 $172,438,700
SFG 3,303,652 $177,399,833
STL 3,448,337 $129,652,933
TBR 1,253,619 $79,473,033
TEX 2,507,760 $207,326,274
TOR 3,203,886 $158,890,575
;
proc plot;
Title "PayrollAW as a function of AttendanceAW";
plot PayrollAW*AttendanceAW;
run;
Title "Payroll_AW as a function of Attendance_AW";
36 plot Payroll_AW*Attendance_AW;
37 run;
ERROR: All values missing for plot of Payroll_AW * Attendance_AW. PLOT request will be ignored.
Not sure why its not recognizing datalines. I did use the comma14. and dollar14 that another person told me to do and it worked. But I am new to this and have not been taught the comma14 or dollar14 commands
@Allen799 wrote:
Title "Payroll_AW as a function of Attendance_AW";
36 plot Payroll_AW*Attendance_AW;
37 run;ERROR: All values missing for plot of Payroll_AW * Attendance_AW. PLOT request will be ignored.
Not sure why its not recognizing datalines. I did use the comma14. and dollar14 that another person told me to do and it worked. But I am new to this and have not been taught the comma14 or dollar14 commands
Check ALL your log. I'd be surprised to see your posted data step ran correctly and didn't generate a log full of warnings or errors.
@Shmuel has given the way to read the data.
Your next procedure may require more memory to plot your requirement. Hope you have that memory. Perhaps you may ask for some summary measures.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.