BookmarkSubscribeRSS Feed
hdg
Obsidian | Level 7 hdg
Obsidian | Level 7

Hi here is my code snippet not sure why its bugging out. Seems not to like the in command

%macro mylist(dataset,code);


data &dataset;
set &dataset;

%if &code= "ted" and date>="03May1993"d %then D=1;
%if &code in ("ann", "joe", "fred") and date>="01Jan1988"d %then D=1;
run;
%mend;

Thanks for your help

2 REPLIES 2
ballardw
Super User

SAS Version? Current MINOPERATOR value?

You probably don't actually want a macro IF from context. It appears that your date variable is from &dataset which means the MACRO IF doesn't know where to get values of date and is going to be treating it as text.

Try: if  "&code" in ... then D=1;  This assumes that code will have a value of ann or joe or similar when you call the macro.

Similarly you probably want: if "&code" = "ted" and ... then D=1;

Jay_TxOAG
Quartz | Level 8

Your macro %If , should be a data step IF...so then your &code macro var needs to be wrapped in quotes....

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 660 views
  • 0 likes
  • 3 in conversation