topic Re: Sort data into a table in SAS Programming

Sort data into a table

igsteo — Wed, 03 Feb 2021 08:45:22 GMT

I have used proc rank 'group=5'. Based on the 'varrank', how do i sort the data such that each table lists 'CY' variables under each rank per dsname grouping?

i.e. i have data from work.yr16 to yr20.

Thank you for the assistance!

Re: Sort data into a table

PeterClemmensen — Fri, 29 Jan 2021 07:02:33 GMT

Please post more of your data and what you want the result to look like.

Makes it much easier to help you.

Re: Sort data into a table

Kurt_Bremser — Fri, 29 Jan 2021 08:18:23 GMT

And we always ask people to post data in usable form. Pictures are NOT usable.

Post your data as code, in a data step with datalines.

Re: Sort data into a table

igsteo — Fri, 29 Jan 2021 08:21:49 GMT

proc rank  data=iglib.mktcap6yrs groups=5
   out=rankedME;
   by dsname;
   var CY;
   ranks varrank;
run;

apologies, here are the codes

Re: Sort data into a table

Kurt_Bremser — Fri, 29 Jan 2021 08:31:13 GMT

Please supply dataset

mktcap6yrs

in a data step with datalines.

Re: Sort data into a table

igsteo — Mon, 01 Feb 2021 02:52:37 GMT

I'm not sure how to convert the data into datalines. i have a few hundred datalines.

Re: Sort data into a table

Kurt_Bremser — Mon, 01 Feb 2021 08:29:14 GMT

My third footnote links to a macro that converts datasets to data step code.

A simple data step for your dataset will look like this:

data mktcap6yrs;
length
  reits $8
  cy 8
  dsname $41
  me_group 8
;
input
  reits
  cy
  dsname
  me_group
;
datalines;
AAREIT 834849900 WORK.YR16 1
;

Add additional datalines as needed to illustrate your task.