Hi there, I need to create a one line per customer file that creates 8 'monthly premium quote' variables based on a persons gender and age (we create quotes for smokers and non-smokers as well but we don't have this in our dataset). So I have the data file that looks like: cust_num age_yrs gender 1 33 F I also have a quote table that looks like this: Coverage age_grp female_ns female_s male_ns male_s 100000 30-34 20.3 25.7 30.5 35.6 200000 35-39 24.6 28.4 34.6 39.1 I was wondering if there is a way to pull in my 'lookup table' and create the quotes I need. I was thinking of transposing my look up table but then I still need to use it with my data to set up the new variables. I was also thinking I might be able to do this with formats somehow? Any advice would be greatly appreciated! Thanks, Christy ... View more

Hi there, I'm just running some simple ods html body= code but when I run it, I get this in the log: ERROR: Physical file does not exist, H:\Documents\RB attrition Analysis\G:\Research and Analysis Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_JUN09. What's really strange is that I'm not pointing to the h drive at all. My code is this: ods html body="G:\Research and Analysis Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_June.xls"; in the log before the error is this message: NOTE: Writing HTML Body file: G:\Research and Analysis Group Folder\35. Customer Analysis\Group Strategy\Output\Scorecard_JUN09 so it looks like it's writing to the right file then in the error it looks like it's trying to write it to the H:\documents file. Any suggestions? Thanks, Christy ... View more

Hi there, I have a dataset that has a bunch of flag variables that I want to count up so I can calculate percentages, etc. I can do tons of data manipulation to get what I want (including proc freq, transpose, etc.) but I thought I might be able to do this in Proc Report. Here's my code: proc report data=test nowd; where rb=1; column rb deposits home_lending credit_card; define rb / sum "Total Retail Bank Customers"; define deposits / sum "Total Deposit Products"; define home_lending / sum "Total Home Lending Products"; define credit_card / sum "Total Credit Card Deposits"; run; This gets me the results that I want/need for my calculations but it lists the variables across the top of the report. I would really like to have the product lists go down with all the stats headings across the top. Does that make sense? Thanks for your help. Christy ... View more

Hi there, I'm trying to plot 3 variables: PLOT Observation * Date =assistance The assistance data values are longer than 32 characters and I want them all in my legend. However, I'm getting the following message in the log: NOTE: Value of IDVAR(Assistance) truncated to 32 characters Is there any way to get around this? Thanks, Christy ... View more

Hi there, I'm currently creating a new style using proc template (and Enterprise Guide). I want to have each row of data alternate colours (grey/white) and I've found this piece of code: ods tagsets.tableeditor body="temp.htm" options(banner_color_even="lightblue" banner_color_odd="pink"); This doesn't seem to work in EG as I get this message: WARNING: Tagset TAGSETS.TABLEEDITOR not found; I'm new to all this styles/tagset stuff so maybe I'm missing something basic. Any help would be appreciated. Thanks, Christy ... View more

Hi there, I currently have the following code: TITLE5 italic j=left underlin=1 colour=black height=9pt "Definition: &def" j=center "Most Recent Observation: &recent" j=right "Date/Time: &sysdate / &systime"; What I would like to do is have the word "Definition" either underlined or bolded and then the actual definition (&def) not underlined or bolded. Is there a way to do this? Thanks, Christy ... View more