Help using Base SAS procedures

Percentage-difference between two variable( proc transpose and report)

Reply
Contributor
Posts: 47

Percentage-difference between two variable( proc transpose and report)

This is example table i created

data a;

input campus $ id $ year $ gender $  ;

datalines;

Ocala    22    2013    F

Ocala    22    2014    F

  West    35    2013    F

  West    35    2014    F

  West    35    2015    F

  West    38    2014    M

  East    48    2014    -

  East    55    2013    F

  East    55    2014    F

;

  run;

I need to create a table as below, or in the attachment. Can i use proc report and proc transpose together?

east west
2014percent20142015percent2015difference2014-2015percent difference2014-20152014percent20142015percent2015difference2014-2015percent difference2014-2015
total
gender
female
male
none
Ask a Question
Discussion stats
  • 0 replies
  • 237 views
  • 0 likes
  • 1 in conversation