I would like to change the date format to the picture below 2021-01 eg I found in the documentation that it is YYMMw. However, when he tries to format, he gets this result. When i tried use subtr like this: ,input(substr(t1.PRP_END_DATE,1,4)||'-'||substr(t1.PRP_END_DATE,5,2),yymmdd10.) as POLICY_VINTAGE, i got error :ERROR: Function SUBSTR requires a character expression as argument 1. This my result : And this is my code: PROC SQL; create table PolisyEnd as select distinct ,datepart(t1.PRP_END_DATE) as PRP_END_DATE format yymmdd10. ,datepart(t1.PRP_END_DATE) as POLICY_VINTAGE format YYMMw.,   ... View more

I have a macro that I want to put in the where query, but I don't find the results, I think because my dates have the same format as in the picture below, how to transform the first_day macro to select the first day of the month, e.g. from the current month %let gv_date_dly=%sysevalf(%bquote('&date_dly.'d)); %let thismonth=%sysfunc(putn(%sysfunc(today()),yymmn10.)); %let first_day = %sysfunc(intnx(month,%sysfunc(today()),0,b)) proc sql; create table PolisyEnd as select datepart(t1.data_danych) as DATA_DANYCH format yymmdd10. ,t1.obj_oid ,t1.PRP_AGREEMENT ,t1.PRP_POLICYNUMBER ,t1.PRP_SOCIETY_PID ,t1.PRP_END_DATE as PRP_END_DATE from cmz.WMDTZDP_BH as t1 where datepart(t1.data_danych) = &first_day. and datepart(t1.data_danych) = &gv_date_dly. ; quit; When I leave the where gv_data condition alone, it will find the dates for me, but as it adds first_day. I have a problem and it shows me empty results. How do I change macro & let first_day to show this date format     ... View more

I have a question for you. Is there a chance to create a macro something similar to this, but in prco sql in quera where it always selects the first day and the last of the month %let thismonth=%sysfunc(putn(%sysfunc(today()),yymmn6.)); where t1.DATE = &thismonth and _dly. between t2.data_from and t2.data_to and &gv_date_dly. between t3.data_from and t3.data_to and t3.obj_code not in ('G07','N06','N07') where we have date from to be recalled from the 1st day of the month and date_to to the last day of the month when the function & thismonth was called ... View more