About AirtonNunes

AirtonNunes · ‎08-16-2016

Try it: 1 - Create your prompt as a date type and variable name DateRef. 2 - Change your variable from string to sas date format using a %let command. %let DateRef = %sysevalf("&DateRef"d); 3 - Use your var &DateRef!

AirtonNunes · ‎02-04-2015

Try: data temp ; set temp_ ; informat x MMDDYYD10.; pos = find(text, '[2015') ; if pos > 0 then do ; dt = substr(substr(text, pos, 11),2) ; yr=substr(dt,1,4) ; mon=substr(dt,6,2) ; day=substr(dt,9,2) ; x=catx('-',mon,day,yr) ; output ; end ; DROP POS DT YR MON DAY; run ;

Online Status	Offline
Date Last Visited	‎05-22-2018 05:19 PM

Re: creating a prompt using a string

Re: formating date from a string to a number with a date format

Re: formating date from a string to a number with a date format

Re: creating a prompt using a string

Re: formating date from a string to a number with a date format