About jskarda

jskarda · ‎06-06-2019

So if I wish to use this command, will this work? I tried and received an error. I wish to use SL_FSCL_PERIOD to generate a new column named SL_FSCL_PERIOD_DT. PROC SQL; CREATE TABLE RXFFDM.ORCL_SL_JE_DTL_DT AS SELECT *, put(intnx ('month',SL_FSCL_PERIOD,0,'E')) format=yymmdd10. as SL_FSCL_PERIOD_DT FROM RXFFDM.ORCL_SL_JE_DTL; Quit;

jskarda · ‎06-05-2019

Thank you. Could you please return in the form of a statement? proc sql; update WORK.FILE set COLUMNB=intnx('month',input(cats('01-',date),anydtdte.),0,'end'); run; DATA in its original format is in a column named COLUMNA. It could contain any month or year, but we would like the last day in any given month Stored Value in COLUMNA='APR-19' New value produced in COLUMNB should be April, 30, 2019 in a sortable format.

jskarda · ‎06-05-2019

We have a database with a date field in MMM-YY format. Is there a method to convert to a sortable date into a new date column with the last day in the month specified. JAN-19 to be 01/31/2019. FEB-19 to be 02/28/2019.

jskarda · ‎06-05-2019

We have a Table with a date in format MMM-19. Example MAY-19. Is there a way to generate a new sortable date column from this format? Preferably 2019-05-31 in this example. Any help would be much appreciated. The last date in the month would be preferred.

Online Status	Offline
Date Last Visited	‎06-06-2019 09:31 PM

Re: Create date with year month and day

Re: Date Conversion from MMM-YY to sortable Date

Date Conversion from MMM-YY to sortable Date

Re: Create date with year month and day

Re: Create date with year month and day

Re: Date Conversion from MMM-YY to sortable Date

Date Conversion from MMM-YY to sortable Date

Re: Create date with year month and day