03-21-2015 12:01 AM
hi I have a table that shows 8 days worth of data which includes today's date I need to exclude today's date ...
the he data looks like this
I Need to remove current date since its a partial data and keep first 7 days thanks
03-21-2015 02:43 AM
Please try and provide ready made sample data (so a data step creating the table) so we don't have to do this. It's also always good to post some code even if unfinished as this will help us to better understand where you're coming from.
have_date length=8 informat=mmddyy10. format=date9.
infile datalines dlm='.' truncover;
input have_date other_var;
/* if 1<= (today() - have_date) <=7;*/
if 1<= ('20Mar2015'd - have_date) <=7;
Need further help from the community? Please ask a new question.