Hello.   The class statement doesn't work in the syntax below.  PROC SURVEYMEANS Data=health varmethod=brr mean clm; CLASS sex agegroup; REPWEIGHTS Rweight1-Rweight500; VAR Cause; WEIGHT TWeight ; ods output Statistics=MyStat1 (keep= VarLevel Mean LowerCLMean StdErr UpperCLMean sex agegroup); run; The output contents only the total estimations.  Any helps will be appreciated.    Thank you!   ... View more

Hello,  I have a variable in my dataset. The categories for this variable are alphanumeric and in character format. For example, they are: A00 to A99, B60 to B89, and so on. Now, I want to list some of them in my SAS syntax:     Data want;         set have;         If myvariable in A20 to A45 then myfavourite = 1;        else myfavourite = 0; run;  Any help would be much appreciated.  Thanks.  ... View more

I created this macro. But, there is no "Qunt" in the data set "wage".  I received SAS warning that: The variable Qunt in the DROP, or RENAME list has never been referenced.    Any tips would be much appreciated.  %macro quantile(var1=, var2=, var3=, var4=); DATA wage; SET AVG_wage; %IF compyr = '2007-08' and sex = '1' %THEN %DO; %IF nocR3 = &var1 %then %do; if realwages <&var2 then Qunt= 1; else if &var2 <realwages <&var3 then Qunt= 2; else if realwages >&var3 then Qunt= 3; else Qunt= .; %end; %else %IF md_nocR3 = &var4 %then %do; if realwages <&var2 then Qunt= 1; else if &var2 <realwages <&var3 then Qunt= 2; else if realwages >&var3 then Qunt= 3; else Qunt= .; %end; %END; keep sex compyr nocR3 Qunt; RUN; %mend quantile; options symbolgen; %quantile(var1='00', var2=47.5 , var3 =95.9); %quantile(var4='11', var2=22.2, var3 =51.5; %quantile(var4='12', var2=25.1 , var3 =42.8); %quantile(var4='13', var2=23.2 , var3 =32.0); ... View more