topic Re: Problem Regarding proc sgpanel in SAS Programming

Problem Regarding proc sgpanel

emmad511 — Fri, 09 Apr 2021 00:52:54 GMT

Hello! I have a problem in which I need to use PROC SGPANEL to create a vertical bar graph of UFO physical encounters (physical) by location with the panels being separated by the years 1987 and 1988 (in that order).

Here's what I have so far:

/* Read the data into SAS */
proc import 
    out = ufo
    datafile = '/folders/myfolders/sasuser.v94/all_data/extdata/UFO.csv'
    dbms = CSV replace;
    getnames = YES;
run;
proc print data=ufo;
run; 

proc sgpanel data=ufo;
  title 'UFO physical encounters by Location for 1987 and 1988';
  panelby 1987 1988;
  vbar Physical Location;
run;

I'm not very familiar with the proc sgpanel syntax. Could someone please help? Thanks in advance!

Re: Problem Regarding proc sgpanel

japelin — Fri, 09 Apr 2021 04:33:37 GMT

Is it like this?

proc sgpanel data=ufo(where=(Physical=1 and year in (1987,1988)));
  title 'UFO physical encounters by Location for 1987 and 1988';
  panelby year;
  vbar location;
run;

Re: Problem Regarding proc sgpanel

ballardw — Fri, 09 Apr 2021 14:39:15 GMT

The errors you see in your log (you did look at the log didn't you?) are because the Panelby statement expects to have one or more variable names, not values, just like any other BY statement.

To subset data to a specific range of values you would use a WHERE statement.

proc sgpanel data=ufo; title 'UFO physical encounters by Location for 1987 and 1988'; where year in ( 1987 1988); panelby year; vbar Physical Location; run;