topic Re: need to extract data from a dataset deployment start dates that are more than 5 days in SAS Programming

need to extract data from a dataset deployment start dates that are more than 5 days

radha009 — Mon, 25 Jun 2018 19:55:31 GMT

I have a dataset with variables ID, summary, start date and POC. I want to create another dataset with more than 5 days. - Please help

proc sql;
create table Task.test as
select * from task.deploy_file as A where Scheduled_Start_Date <= (Scheduled_Start_Date +5);
quit;

PeterClemmensen — Mon, 25 Jun 2018 20:35:15 GMT

Please be more specific than "I want to create another dataset with more than 5 days"?

Show us an example of what your data looks like, so we can rewrite your SQL code.

As os now, your WHERE Statement makes little sense. It is always true.