Printing on a condition

[sks521]

Hi,

I wanna print some variables where 'EventDate' variable is 01Jan2016 to 31Jan2016. I am writing following syntax;

proc print data=GPvisit;
var eventdate pkid status visit month professionalcontact;
where ('01JAN2016'd =<EventDate>= '31JAN2016'd) ;
run;

It doesn't seem to work.

Can someone help with the code please?

Thanks

[tsap]

Can you provide more details about the table, GPVisit? Like logic to create a dummy table that looks like the GPVisit table. That way we can have a better idea of what we are referencing in the proc print statement you have included in your post.

Check out this link if you need help creating the dummy table: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

[FreelanceReinh · Accepted solution]

---

@sks521 wrote:

where ('01JAN2016'd =<EventDate>= '31JAN2016'd) ;

---

Hi @sks521,

First, correct the syntax error ("=<") and the logical error (">=") in your WHERE condition and then rerun the step.

where '01JAN2016'd<=EventDate<='31JAN2016'd;

[sks521]

Fabulous! thanks