topic Help generating a plot in SAS in SAS Procedures

Help generating a plot in SAS

Allen799 — Mon, 16 Sep 2019 16:12:24 GMT

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;

Re: Help

Jagadishkatam — Mon, 16 Sep 2019 16:05:49 GMT

Please try the below code as an example

proc gplot data=sashelp.class;
plot height*weight;
run;

Re: Help

Shmuel — Mon, 16 Sep 2019 16:09:55 GMT

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;

Re: Help

Allen799 — Mon, 16 Sep 2019 16:12:43 GMT

Thank you at least it gave me a plot chart.

Can you please explain the comma14. and dollar14. being used.

thanks

Re: Help

Allen799 — Mon, 16 Sep 2019 16:14:23 GMT

thanks

Re: Help generating a plot in SAS

Reeza — Mon, 16 Sep 2019 16:15:12 GMT

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;

Re: Help generating a plot in SAS

KachiM — Mon, 16 Sep 2019 16:16:00 GMT

@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.

Re: Help generating a plot in SAS

Allen799 — Mon, 16 Sep 2019 16:19:55 GMT

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

Re: Help generating a plot in SAS

KachiM — Mon, 16 Sep 2019 16:25:30 GMT

@Allen799

Did you place the DOT (.) after the numeric like (comma14. and Dollar14.)?

Re: Help

Shmuel — Mon, 16 Sep 2019 16:49:37 GMT

@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.

Re: Help generating a plot in SAS

Reeza — Mon, 16 Sep 2019 17:17:51 GMT

@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.