topic Shift table in SAS Programming

Shift table

DR_Majeti — Thu, 22 May 2014 16:39:57 GMT

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?

jakarman — Thu, 22 May 2014 17:39:17 GMT

use proc tabulate or similar

ballardw — Thu, 22 May 2014 18:16:38 GMT

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;