Select MAX Value from table

fabiopjr — Thu, 30 Jun 2016 19:49:38 GMT

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.

Re: Select MAX Value from table

jklaverstijn — Thu, 30 Jun 2016 21:25:10 GMT

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.

topic Re: Select MAX Value from table in SAS Data Management

Select MAX Value from table

Re: Select MAX Value from table