I have the courage to FECHA_INGRESO  fecha ingreso = SUBSTR(t1.fecha_ingreso, 1, 20) which delivers as a result 2014-04-03 00:00:00   I want to have this same date removing the ' - '  and ' : '    you can tell me what function I can use for this       ... View more

IS THERE A WAY TO WORK WITH SAS WITHOUT HAVING A SERVER CONNECTION?     ... View more

I have an indexing program but every time I use it generates an error :   "GOPTIONS ACCESSIBLE; proc datasets library=DATA AML; ERROR: El libref DATA AML no se ha asignado. NOTE: Statements not processed because of errors noted above. modify TBL BI CLIENTES; INDEX CREATE NROIDENTIFICACION; ERROR: There is no data set to modify.  quit;"   I'd like to find a code that assigns me the bookcase before it's indexed.   I LEAVE MY INDEXATION CODE   proc datasets library=DATA_AML; modify TBL_BI_CLIENTES; INDEX CREATE NROIDENTIFICACION; quit; ... View more

I have this code which gives me back the date of 201601   /*Año y mes Atras*/ data _null_; call symputx('Fetch_FIN', put(intnx ('month',today(),-40),yymmn6.) ); run; %put Fetch_FIN = &Fetch_FIN.;   Could help me improve the code and other than this I need a condition with the every time it is a new year is added a year more to the result   I mean that when it is 2020 the result of Fetch_FIN is 2017 ... View more

Good afternoon I would like to have a SAS function that gives me the result and change the year now   20190101 20200101 next year     data _null_; call symputx('Fetch_FIN', put(intnx ('month',today(),0, 'b') + 1 ,yymmddn8.) ); run; %put Fetch_FIN = &Fetch_FIN.;     ... View more

      data _null_; call symputx('Fetch_FIN', put(intnx ('month',today(),0, 'b') + 1 ,yymmddn8.) ); run; %put Fetch_FIN = &Fetch_FIN.;   result = 20190501   Actually I want to have the result of the current day without needing to add the days (+1...)  Dynamic function     ... View more