Shift table

Reply
Contributor
Posts: 64

Shift table

Hi all,

Please help out in the shift table. please check the excel attached for the sample data.

How to apply preloadfmt in proc freq .. is that possible?

Valued Guide
Posts: 3,208

Re: Shift table

use proc tabulate or similar

---->-- ja karman --<-----
Super User
Posts: 10,460

Re: Shift table

As Jaap mentions you'll need to use another proc.

Tabulate code might look something like this:

proc tabulate data=have;

     class post base /missing preloadfmt;

     format post base <the format name goes hear>;

     table base,

             post * n='' * f= f8.

             / printmiss ;

run;

Ask a Question
Discussion stats
  • 2 replies
  • 491 views
  • 0 likes
  • 3 in conversation