Hello, I was wondering about how to import a sas7bdat file with proc import. I've done some search for it but all I can find was using LIB with DATA. Thanks in advance! ... View more

Hello! I have a problem related to proc sgplot. I have tried doing some code, but it didn't seem to work. Could someone help with this? Thanks in advance!   Here's the instructions of the problem:    4. Use PROC SGPLOT to    a. Create a time series plot with smooth lines, where the time component (DATE) is the x-axis and the percent (StLouis) is the y-axis.      i. Add a blue line with line thickness equaled to 2.      ii.Add a legend label called ‘Economic Conditions Index for St. Louis, MO-IL (MSA)’.    b. Create a time series plot with smooth lines, where the time component (DATE) is the x-axis and the percent (RealGDP) is the y-axis.     i. Add a red line with line thickness equaled to 2      ii. Add a legend label called ‘Real Gross Domestic Product’.    Here's what I have so far: proc import out = StLouis datafile = '/folders/myfolders/sasuser.v94/all_data/extdata/StLouisData.csv' dbms = CSV replace; getnames = YES; run; proc print data=StLouis; run; proc sort data=StLouis; by Date StLouis; run; ods pdf style=analysis file="StLouis.pdf"; proc sgplot data=StLouis; loess x=Date y=StLouis / smooth nomarkers lineattrs=(color=blue thickness=2) legendlabel="Economic Conditons Index for St. Louis, MO-IL (MSA)"; run; proc sort data=StLouis; by Date RealGDP; run; proc sgplot data=StLouis; loess x=Date y=RealGDP / smooth lineattrs=(color=red thickness=2) legendlabel="Real Gross Domestric Product"; run; ods pdf close; ... View more

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! ... View more

Hello! I have some questions relating to proc tabulate.   For the RealGDP data attached, I would like to use PROC TABULATE to create a table with the state abbreviations (postal) as the rows and the years (Y2012, Y2013, Y2014, Y2015) as the columns, and a table with the state abbreviations (postal) as the rows and the years (Y2012, Y2013, Y2014, Y2015) as the columns with each years’ minimum, mean, and maximum values. Also, for each table, I need a centered blue footnote with a height of 1 called 'Source: Bureau of Economic Analysis'.    Here's what I have for now, but it doesn't print out a table, and I'm not sure where to go from this. For your information, I have already imported the original data into "gdp". title "Sum of Real GDP by Year"; proc tabulate data=gdp; by Postal; table Postal, Y2012*Y2013*Y2014*Y2015; run; title; ... View more

I need to run an ANOVA procedure by team for NBA players’ salaries with means for team and scheffe bon. I'm not quite sure about what this question is asking for. Do I need a proc means step first? The original data has two variables, one is Tm(team) and the other is salary. My current code is as followed. Thanks in advance! title "NBA Salary ANOVA by Team"; ods graphics on; PROC glm DATA=NBA2; class Tm salary; by Tm; Model salary = Tm; means Tm / Scheffe; means Tm / Bon; run; ods graphics off; title;   ... View more