I'm trying to strip some operators from a string, leaving behind variable names. I'm using the following code which doesn't work. Is there some quoting needed?   %let expression = vara / (varb + varc); %macro stripsym(string); %sysfunc(translate(&string,,+-*/())); %mend stripsym; %put Output: %stripsym(&expression); %put Desired: vara varb varc; ... View more

Anyone have suggestions for simple ways to present this sort of data: multiple series with groups. The following codes doesn't work, the legend only has information for the groups in the first series. If I can't get both the series and groups in the legend, I'd like to have the series in the legend with a consistent formatting for the groups (eg group B always dotted lines).   data temp; input x grp $ s1 s2 s3; cards; 1 A 1 1 1 2 A 2 3 4 3 A 1 2 3 1 B 1.2 1.2 1.2 2 B 2.2 3.2 4.2 3 B 1.2 2.2 3.2 ; run; proc sgplot data=temp; series x=x y=s1 /markers group=grp ; series x=x y=s2 /markers group=grp ; series x=x y=s3 /markers group=grp ; run; ... View more

I have a dataset with observations for each year for each person. Some years are missing. I want to expand the file to have all years for each person (with missing values for the missing years). Can this be done with an SQL statement. The code below doesn't work.   data one; input id year var; cards; 1 2001 3 1 2002 5 1 2003 7 2 2002 4 2 2003 6 ; run; data years; input year; cards; 2001 2002 2003 ; run; data desired; input id year var; cards; 1 2001 3 1 2002 5 1 2003 7 2 2001 . 2 2002 4 2 2003 6 ; /* this doesn't add in the missing row */; proc sql; create table comb as select years.year, one.id, one.var from years left join one on one.year = years.year order by id,year ; quit; run; ... View more