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?

Trusted Advisor
Posts: 3,211

Re: Shift table

Posted in reply to DR_Majeti

use proc tabulate or similar

---->-- ja karman --<-----
Super User
Posts: 11,343

Re: Shift table

Posted in reply to DR_Majeti

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
  • 586 views
  • 0 likes
  • 3 in conversation