Select MAX Value from table

[fabiopjr]

I need to find the highest record in a table ("DATA_ARQUIVO" field).
I'm trying to use the Create Table without success.

Any ideas to help me?

Thanks.

[jklaverstijn · Accepted solution]

Hi, I would use an Extract transform. Map the DATA_ARQUIVO column with an expression MAX(DATA_ARQUIVO).

The essence of the code would be:

%put %str(NOTE: Mapping columns ...);
proc sql;
   create table work.W36LRL as
      select
         (max(DATA_ARQUIVO)) as DATA_ARQUIVO length = 8
   from &SYSLAST
   ;
quit;

Hope this helps,

- Jan.