BookmarkSubscribeRSS Feed
Woop122
Calcite | Level 5

Hi,

 

I have a table "basedata" with 2 variables, birthweight & gestage.

I have a macro "sga" that determines whether or not each baby is small based on the birthweight & gestage. It created another variable called sgavar.

 

I was wondering how to invoke the macro to create a new table w/ the new variable. 

10 REPLIES 10
Peter_C
Rhodochrosite | Level 12
Ask the provider of the macro
Reeza
Super User

Without the macro it's almost impossible to say. 

Woop122
Calcite | Level 5


%MACRO sga(bwvar,gadaysvar,sgavar);

IF &bwvar > . AND &gadaysvar > . THEN DO;
&gadaysvar = &gadaysvar -3.5;
IF 19*7 < &gadaysvar <= 20*7 THEN DO;
IF &bwvar <=275 THEN &sgavar =1;
ELSE IF &bwvar >=772 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 20*7 < &gadaysvar <=21*7 THEN DO;
IF &bwvar <=314 THEN &sgavar =1;
ELSE IF &bwvar >=790 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 21*7 < &gadaysvar <=22*7 THEN DO;
IF &bwvar <=376 THEN &sgavar =1;
ELSE IF &bwvar >=826 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 22*7 < &gadaysvar <=23*7 THEN DO;
IF &bwvar <=440 THEN &sgavar =1;
ELSE IF &bwvar >=882 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 23*7 < &gadaysvar <=24*7 THEN DO;
IF &bwvar <=498 THEN &sgavar =1;
ELSE IF &bwvar >=977 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 24*7 < &gadaysvar <=25*7 THEN DO;
IF &bwvar <=558 THEN &sgavar =1;
ELSE IF &bwvar >=1138 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 25*7 < &gadaysvar <=26*7 THEN DO;
IF &bwvar <=625 THEN &sgavar =1;
ELSE IF &bwvar >=1362 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 26*7 < &gadaysvar <=27*7 THEN DO;
IF &bwvar <=702 THEN &sgavar =1;
ELSE IF &bwvar >=1635 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 27*7 < &gadaysvar <=28*7 THEN DO;
IF &bwvar <=798 THEN &sgavar =1;
ELSE IF &bwvar >=1977 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 28*7 < &gadaysvar <=29*7 THEN DO;
IF &bwvar <=925 THEN &sgavar =1;
ELSE IF &bwvar >=2361 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 29*7 < &gadaysvar <=30*7 THEN DO;
IF &bwvar <=1085 THEN &sgavar =1;
ELSE IF &bwvar >=2710 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 30*7 < &gadaysvar <=31*7 THEN DO;
IF &bwvar <=1278 THEN &sgavar =1;
ELSE IF &bwvar >=2986 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 31*7 < &gadaysvar <=32*7 THEN DO;
IF &bwvar <=1495 THEN &sgavar =1;
ELSE IF &bwvar >=3200 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 32*7 < &gadaysvar <=33*7 THEN DO;
IF &bwvar <=1725 THEN &sgavar =1;
ELSE IF &bwvar >=3370 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 33*7 < &gadaysvar <=34*7 THEN DO;
IF &bwvar <=1950 THEN &sgavar =1;
ELSE IF &bwvar >=3502 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 34*7 < &gadaysvar <=35*7 THEN DO;
IF &bwvar <=2159 THEN &sgavar =1;
ELSE IF &bwvar >=3596 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 35*7 < &gadaysvar <=36*7 THEN DO;
IF &bwvar <=2354 THEN &sgavar =1;
ELSE IF &bwvar >=3668 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 36*7 < &gadaysvar <=37*7 THEN DO;
IF &bwvar <=2541 THEN &sgavar =1;
ELSE IF &bwvar >=3755 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 37*7 < &gadaysvar <=38*7 THEN DO;
IF &bwvar <=2714 THEN &sgavar =1;
ELSE IF &bwvar >=3867 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 38*7 < &gadaysvar <=39*7 THEN DO;
IF &bwvar <=2852 THEN &sgavar =1;
ELSE IF &bwvar >=3980 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 39*7 < &gadaysvar <=40*7 THEN DO;
IF &bwvar <=2929 THEN &sgavar =1;
ELSE IF &bwvar >=4060 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 40*7 < &gadaysvar <=41*7 THEN DO;
IF &bwvar <=2948 THEN &sgavar =1;
ELSE IF &bwvar >=4094 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 41*7 < &gadaysvar <=42*7 THEN DO;
IF &bwvar <=2935 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 42*7 < &gadaysvar <=43*7 THEN DO;
IF &bwvar <=2907 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 43*7 < &gadaysvar <=44*7 THEN DO;
IF &bwvar <=2885 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
&gadaysvar = &gadaysvar +3.5;
END;
%MEND sga;

 

ballardw
Super User

Execute the macro before something like:

 

data want;

set have;

%sga(firstvarname, secondvar, lastvar); /*firstvarname, secondvar, lastvar are the names of variables in the HAVE data set*/

run;

 

And if any of this is supposed to be processing data by week and days of year then it is time to hit someone over the head and learn proper date functions and values.

Reeza
Super User

@ballardw wrote:

Execute the macro before something like:

 

data want;

set have;

%sga(firstvarname, secondvar, lastvar); /*firstvarname, secondvar, lastvar are the names of variables in the HAVE data set*/

run;

 

And if any of this is supposed to be processing data by week and days of year then it is time to hit someone over the head and learn proper date functions and values.


And Formats.  

SASKiwi
PROC Star

Your macro would have to be run inside a DATA step where the variables bwvar, gadaysvar, sgavar exist:

 

data want;
  set have;
  %sga(bwvar,gadaysvar,sgavar);
run;
Woop122
Calcite | Level 5

I'm getting all null values for sgavar, which I know shoudn't be the case. Not sure what's going on...

 

Reeza
Super User

Post your code and log.

 

Make sure the variable names are exactly as they should be. 

Woop122
Calcite | Level 5


proc sql;
create table test as select
bwgt as bwvar
,gadays as gadaysvar
from basedata
;
quit;

 

%MACRO sga(bwvar,gadaysvar,sgavar);
IF &bwvar > . AND &gadaysvar > . THEN DO;
&gadaysvar = &gadaysvar -3.5;
IF 19*7 < &gadaysvar <= 20*7 THEN DO;
IF &bwvar <=275 THEN &sgavar =1;
ELSE IF &bwvar >=772 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 20*7 < &gadaysvar <=21*7 THEN DO;
IF &bwvar <=314 THEN &sgavar =1;
ELSE IF &bwvar >=790 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 21*7 < &gadaysvar <=22*7 THEN DO;
IF &bwvar <=376 THEN &sgavar =1;
ELSE IF &bwvar >=826 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 22*7 < &gadaysvar <=23*7 THEN DO;
IF &bwvar <=440 THEN &sgavar =1;
ELSE IF &bwvar >=882 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 23*7 < &gadaysvar <=24*7 THEN DO;
IF &bwvar <=498 THEN &sgavar =1;
ELSE IF &bwvar >=977 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 24*7 < &gadaysvar <=25*7 THEN DO;
IF &bwvar <=558 THEN &sgavar =1;
ELSE IF &bwvar >=1138 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 25*7 < &gadaysvar <=26*7 THEN DO;
IF &bwvar <=625 THEN &sgavar =1;
ELSE IF &bwvar >=1362 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 26*7 < &gadaysvar <=27*7 THEN DO;
IF &bwvar <=702 THEN &sgavar =1;
ELSE IF &bwvar >=1635 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 27*7 < &gadaysvar <=28*7 THEN DO;
IF &bwvar <=798 THEN &sgavar =1;
ELSE IF &bwvar >=1977 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 28*7 < &gadaysvar <=29*7 THEN DO;
IF &bwvar <=925 THEN &sgavar =1;
ELSE IF &bwvar >=2361 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 29*7 < &gadaysvar <=30*7 THEN DO;
IF &bwvar <=1085 THEN &sgavar =1;
ELSE IF &bwvar >=2710 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 30*7 < &gadaysvar <=31*7 THEN DO;
IF &bwvar <=1278 THEN &sgavar =1;
ELSE IF &bwvar >=2986 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 31*7 < &gadaysvar <=32*7 THEN DO;
IF &bwvar <=1495 THEN &sgavar =1;
ELSE IF &bwvar >=3200 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 32*7 < &gadaysvar <=33*7 THEN DO;
IF &bwvar <=1725 THEN &sgavar =1;
ELSE IF &bwvar >=3370 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 33*7 < &gadaysvar <=34*7 THEN DO;
IF &bwvar <=1950 THEN &sgavar =1;
ELSE IF &bwvar >=3502 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 34*7 < &gadaysvar <=35*7 THEN DO;
IF &bwvar <=2159 THEN &sgavar =1;
ELSE IF &bwvar >=3596 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 35*7 < &gadaysvar <=36*7 THEN DO;
IF &bwvar <=2354 THEN &sgavar =1;
ELSE IF &bwvar >=3668 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 36*7 < &gadaysvar <=37*7 THEN DO;
IF &bwvar <=2541 THEN &sgavar =1;
ELSE IF &bwvar >=3755 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 37*7 < &gadaysvar <=38*7 THEN DO;
IF &bwvar <=2714 THEN &sgavar =1;
ELSE IF &bwvar >=3867 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 38*7 < &gadaysvar <=39*7 THEN DO;
IF &bwvar <=2852 THEN &sgavar =1;
ELSE IF &bwvar >=3980 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 39*7 < &gadaysvar <=40*7 THEN DO;
IF &bwvar <=2929 THEN &sgavar =1;
ELSE IF &bwvar >=4060 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 40*7 < &gadaysvar <=41*7 THEN DO;
IF &bwvar <=2948 THEN &sgavar =1;
ELSE IF &bwvar >=4094 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 41*7 < &gadaysvar <=42*7 THEN DO;
IF &bwvar <=2935 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 42*7 < &gadaysvar <=43*7 THEN DO;
IF &bwvar <=2907 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
ELSE IF 43*7 < &gadaysvar <=44*7 THEN DO;
IF &bwvar <=2885 THEN &sgavar =1;
ELSE IF &bwvar >=4098 THEN &sgavar =3;
ELSE &sgavar =2;
END;
&gadaysvar = &gadaysvar +3.5;
END;
%MEND sga;

 

data want;
set test;
%sga(bwvar,gadaysvar,sgavar);
run;

Woop122
Calcite | Level 5

thanks for everyone's help!

 

was using the wrong variable -__-

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 10 replies
  • 1536 views
  • 4 likes
  • 5 in conversation