topic Printing on a condition in SAS Programming

Printing on a condition

sks521 — Tue, 25 Jun 2019 14:28:57 GMT

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 — Tue, 25 Jun 2019 14:33:13 GMT

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-data-AKA-generate/ta-p/258712

FreelanceReinh — Tue, 25 Jun 2019 14:42:04 GMT

@sks521 wrote:

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

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 — Wed, 26 Jun 2019 08:08:05 GMT

Fabulous! thanks