Can you please help me  if we want to write in reverse? as I have the main frame values but I want to convert that into SAS date. ... View more

data table1; input ID Var1 Var2; cards; 1 1 1 1 2 2 1 3 3 2 1 1 2 2 2 3 1 1 3 2 2 3 3 3 3 4 4 ; run; data table2; input ID VarA $; cards; 1 x 2 u 3 h ; run; data table3; merge table1 table2; by ID; run; proc print;run; gets this output: Obs ID Var1 Var2 VarA 1  1  1   1  x  2  1  2   2  x  3  1  3   3  x  4  2  1   1  u  5  2  2   2  u  6  3  1   1  h  7  3  2   2  h  8  3  3   3  h  9  3  4   4  h  ... View more

For adjusting intervals you can use SAS(R) 9.3 Functions and CALL Routines: Reference intnx Sample for analysing SMF, that is what ASG TMON CICS is delivering, can be found with eg MCG (mxg.com) . That is part of IT service vision. ... View more

You don't need a case statement to recode the values you can use a format: proc format; picture daterecode low - '31DEC2005'd = 'Up to 2005' (datatype=date) '01JAN2006'd - '31DEC2007'd = %Y (datatype=date) high = '2008+' (datatype=date) ; run; data temp;      x= '15AUG2004'd;      y = '12JUN2006'd;      z = '10Feb2009'd; run; proc print data=temp;      format x y z daterecode.; run; You can use your date value and assign the format for use in the report generator. ... View more