Math Forum / Math Software / SAS / October 2008

I hope someone can assist with question.
I have the following code:
PROC MIXED ;
CLASS A

I have imported data from excel into SAS.  The field (hullnum) is set
to $10. but my value is 6 characters.  I am matching this field to
another table with the same field (hullnum).  I can see that the
values are the same, but they are not matching.  When I check the

I'm evaluating FA models for a crop variety trial data set and have a
question
on how to write SAS code to seperate BLUPs for main effect and BLUPS
for interaction effect

Just wondering how I can use the where clause to select for a range of
years.  For example, I want SAS to run the procedure only on observations
from 1991-2001.  I tried where 1991<= year <=2001; but that doesn't work

Hello. I am currently looking at the effects of hypertension (hyptynr;
dichotomous y/n), cardiovascular disease (cardvsc2; categorical),
alcohol consumption (AlcConsume; categorical), smoking (currsmoke2;
categorical), waist-hip ratio (continuous), and presence or absence of

all,
would like to capture the variable name in the array that made up the output
value
to illustrate:

"thomas" <t@SAM.SE> wrote in message news: =
<gefc80$caf$1@registered.motzarella.org>...

For Q1, you can change x to a numeric var then use format to show
the character, this way, the vertical line can be done easily with
vref=...
For Q2, I don't know if there is any workaround, therefore, has to

I am a newbie to SAS and have a problem which I am trying to work! if
someone can give me some help or direction,thanks in advance
i have 4 alpha numeric columns
case number part number case_dt  route

I am using proc report to get the headers and the end of the contents
underlined before the footnotes. The report has to be in RTF. I would also
like the variables date and department to appear on each page .i.e. if I
had more variables which do not fit on one page. That is in proc ...

Does this %readpipe macro work on Unix for the "set" command without
truncating text or adding annoying space gaps? The 80 character string
I am using seems to work fine on Windows but I have my doubts that it
will work on Unix. Note that it calls two submacros.

316 data _null_;
317 length command $500;
318 set definition;
319 startdate=mdy(input(substr(start,6, 2),2.), 1, input(substr(start,1,

Suppose I have 4 datasets "A","B","C","D" which have the same
variables. I want to output them into 4 tabs by SAS. How to do this?

has anyone got experience in using the VLOOKUP Function (in German
SVERWEIS) between two Excel Sheets generated from SAS Tables?
I opened a SAS File in Excel with the Office Add In, generated a few new
columns and saved this in an xls File (File A).

Can you tell me which module do i need, to use FSV / FSE features...
Thanks
P.S. isnt this something you get with the BASE SAS pack?