Hi,   I'm struggling combining datasets with unequal observations in SAS. I have dataset A with 8000 observations (containing variables X and Y), and dataset B (containing variable Z) with 9000 observations. Both datasets have a common identifier.   I want to have dataset A, and pull variable Z from dataset B to dataset A (so the dataset will have 8000 obs, with the added variable from dataset B). Does anyone know how to do so?   Thanks in advance! ... View more

Hi,   I have data arranged in the following way:   ID Food intake 1 food1 32 1 food2 12 1 food3 69 2 food1 22 2 food2 78 2 food3 56   Using the PROC TRANSPOSE procedure, I want to structure it in this way: ID food1 food2 food3 1 32 12 69 2 22 78 56   I have used the following code to restructure:   proc transpose data=have out=want; id food; var intake; by ID; run;   However, I repeatedly get the following error message, for each food: "The ID value "food1" occurs twice in the same BY group."   The output seems OK after some random checks, so I wonder why I get this error message. Does it have to do with the length of the character variables (the actual strings are longer than the length of 'food1' etc).   Hope someone can help me out! ... View more

Hi all,   I'm having very frustrating difficulties with SAS. I'm starting to analyze my data, but I won't get any analysis out of it because I continuously get 'Output window full'. Then I can select four options (file, print, save, or clear without saving), but I can't make any of the options work.   I tried to manually clear the window by using DM "output;clear", but this won't help either. I also don't really understand why the output window is full when I just start analyzing a new data-set.   Really hope someone can help me out! ... View more

Hi all,     This afternoon I decided to plot my hazard ratio's and confidence intervals in a forest plot (horizontal bars). However, when I plot my effect sizes and confidence intervals, they are not symmmetrical (e.g. the length from the effect size to the upper and lower bound are not equal....). I have no clue how this could have happened.   I obtained by data with the PHREG procedure. The piece of syntax I used looks basically like this:   PROC PHREG data=mydata; CLASS var1 var2 var3/ref=first; MODEL survival*censor(0) = var1 var2 var3 / RL; RUN;   Really hope someone can help me out!   Kind regards, Marjolein       ... View more

Hi all,     I have a question regarding evaluating the PH assumption in a Cox model. I did this by introducing an interaction term for my exposure variable. My exposure variable is a categorical variable.   proc phreg data=mydata; model time*censor(0)=exposure exposureT; exposureT=exposure*(log(time)); RUN;   However, I get output but also an error in the log-window with: An illegal argument is used in the function call in statement number 1 at line 1331 column 1.   What does this mean and does it influence my output?   Thanks!   ... View more