When I put break or rbreak after + some variable, sometimes proc report prints out sums, sometimes means or neither. If you find the attached for the output of the code below, the first highlighted value 25.2 seems to be the mean, but not other values. What are these numbers that proc report is showing as a summary?    SAS documentation just says that the "summarize" option shows a summary line...... What kind of summary line is that showing though? There can be many, including means, medians, and quartiles.......      proc report nowd data=cars; where upcase(country) in ('GERMANY','JAPAN','USA') and upcase(type) in ('SUV','SEDAN','HATCHBACK'); columns type country citympg hwympg ('Std Dev' citympg=citistd hwympg=hwystd); define country / group 'Country of Origin'; define type / group 'Type of Car'; define citympg / analysis mean 'City MPG' format=5.1; define hwympg / analysis mean 'Highway MPG' format=5.1; define citistd / analysis std 'City MPG Std' format=5.1; define hwystd / analysis std 'Highway MPG std' format=5.1; break after type / summarize suppress DOL ul style=[BACKGROUNDCOLOR=ltgray]; /* break after cylinders/ summarize suppress ol ul; */ rbreak after / summarize ol ul; run;   ... View more

I have 4 variables of interest: weight, weight unit, height, height unit. Weight unit variable has two possible values, pounds or kg. Height unit variable has two possible values, inch or cm.   I want to write a code in a data step that does this - how do we write such code in order to eliminate/print out abnormal values?     when weight unit is in pound & weight is/is not within a to b    when weight unit is in kg & weight is/is not within c to d    when height unit is in inch & height is/is not within a2 to b2    when height unit is in cm & height is/is not within c2 to d2   I tried a bunch of if/where statements similar to this:  data a;    set dem;    if not (dema6b = "K" & 30 <=dema6a<=250) or       (dema6b = "P" & 66<=dema6a<=550) or       (dema6d = "C" & 121<=dema6c<=229) or       (dema6d = "I" & 4<=dema6c<=7.5); run;   but they didn't do the job.  ... View more

  I have a data set with many race variables, and the variables look like the attached picture. I want to check if one of them is 'Y', other race variables are 'N', and print out any observations with two or more 'Y' in different race variables.   How do I write such code?   Thank you for the help!  ... View more

First, I'm creating a new dataset with new names for some variables. Dropping unwanted variables data q2; set METSdata.LABA_669; rename LABA11 = SODIUM  LABA15 = CALCIUM  LABA16 = PROTEIN  LABA5 = HDL LABA6 = LDL; keep BID VISIT LABA11 LABA15 LABA16 LABA5 LABA6; run; proc print data=q2 (obs=20); run;   The dataset contains a lot of . values. I want to categorize numeric&. values into within a range and outside of the range, by labeling them Missing, Low, Normal (within range), and High. I'm using different categories for different variables (such as sodium (SOD), calcium(CAL), etc) proc format; value SOD . = 'Missing' Low-129 = 'Low' 130<-<150 = 'Normal' 151-High = 'High'; run;   proc format; value CAL . = 'Missing' Low-7= 'Low' 8<-<10.5 = 'Normal' 11-High = 'High'; run;   proc format; value PRO . = 'Missing' Low-5 = 'Low' 6<-<9 = 'Normal' 10-High = 'High'; run;   proc format; value HDL . = 'Missing' Low-24 = 'Low' 25-High = 'Normal'; run;   proc format; value LDL . = 'Missing' Low-200 = 'Normal' 201-High = 'High'; run;   Then onto macro function - I'm creating a function such that if I type Sodium, Calcium, etc, the function will create a categorical variable, which is a categorized version of the numeric&. values accordingly to the input name, then print BID VISIT &name. and valcat variables of that input name.  %macro analyte(name=); data &name.; set q2; valcat = &name.; %if upcase(&name.) = SODIUM %then %put %sysfunc(putn(&valcat, SOD.)); %if upcase(&name.) = CALCIUM %then %put %sysfunc(putn(&valcat, CAL.)); %if upcase(&name.) = PROTEIN %then %put %sysfunc(putn(&valcat, PRO.)); %if upcase(&name.) = HDL %then %put %sysfunc(putn(&valcat, HDL.)); %else upcase(&name.) = LDL %put %sysfunc(putn(&valcat, LDL.)); keep BID VISIT &name. valcat; run; proc print data = &name.; run; %macro analyte; %analyte(sodium);   I don't get any output from this macro function though. Any help please?    Thank you in advance!  ... View more