Need help on Macros

KannanBaskar — Fri, 13 Dec 2013 14:23:56 GMT

Hi All,

I am in need of your help to resolve below mentioned issue with respect to SAS dates.

DATA SET EMP:

EMP NO DOJ

123456 03/06/2000

345678 09/06/2008

123678 21/06/2010

346678 10/07/2013

%LET LAP_DAT_IND = &ASATDATE;

PROC SQL;

CREATE TABLE ABC AS

SELECT * FROM EMP

WHERE DOJ < &LAP_DAT_IND.

QUIT;

ASATDATE variable comes as input from application (format is 03-06-2013) and this value needs to be passed as '03JUN2013'd. Could you please let me know how to change this.

Thanks.

Re: Need help on Macros

data_null__ — Fri, 13 Dec 2013 14:39:28 GMT

You don't need a date constant using the interger value will work as well in your code.

18         %let ASATDATE=03-06-2013; 
19         %LET LAP_DAT_IND = %sysfunc(inputN(&ASATDATE,mmddyy,10));
20         %put NOTE: &=asatdate &=lap_dat_ind;
NOTE: ASATDATE=03-06-2013 LAP_DAT_IND=19423

topic Need help on Macros in ODS and Base Reporting

Need help on Macros

Re: Need help on Macros