Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
** Exercise 1 **;
proc transpose data=school out=t_school;
run;


** Exercise 2 **;
proc sort data=school;
by year;
run;

proc transpose data=school out=t_school;
by year;
id school_name;
run;


** Exercise 3 **;
proc sort data=car_list1; by make model; run;
proc sort data=car_list2; by make model; run;

data cars;
set car_list1 car_list2;
by make model;
run;


** Exercise 4 **;

proc univariate data=sashelp.baseball;
var salary;
run;


proc format;
value salary low-<250 = "Low"
             250-750 = "Medium"
             750<-high = "High"
             other = "Unknown";
run;

data baseball;
set sashelp.baseball;
format salary salary.;
run;

proc freq data=baseball;
table team*salary / nocol norow nopercent nocum;
run;

** New York has the most players in the "high" salary categories. **;
Next
Already a member? Go to member's area.