Okay. A SAS DATA step MERGE with a BY statement, which supports multiple SAS variables. It's unclear to me what you're expecting from SAS software, frankly? Again, I encourage you to show us *ALL* of your sample data, including the summarized level, and also the outcome of some MERGE process, for additional feedback. Scott Barry SBBWorks, Inc. ... View more

With multiple observations for a unique BY variable set, you will need to use some SAS procedure (MEANS, SUMMARY, UNIVARIATE) to generate a reduced observation set before using a DATA step MERGE process. Suggest you start out with getting your data into SAS members using a SAS DATA step, then explore what "data summarization or analysis" procedure will work for you, and then review the DATA step process for merging using a BY statement, so you can perform your calculation. I encourage you to use the DOC and technical paper references cited previously. Scott Barry SBBWorks, Inc. ... View more

Have a look at the SAS support website http://support.sas.com/ or use the Google advanced search below to find several related DOC and technical paper references: +p-value +analysis site:sas.com Scott Barry SBBWorks, Inc. ... View more

Although I have no experience in this topic-area, I did find three hits on the SAS support website http://support.sas.com/ when using the following Google advanced search: generate individual "part worths" site:sas.com Hopefully one of these resources will be useful to your interest. Scott Barry SBBWorks, Inc. ... View more

It is not necessary to have two identical posts in the same forum. http://support.sas.com/forums/thread.jspa?threadID=3870&tstart=0 ... View more

Provide data sample(s) and the desired result, in your post, for a more effective and timely response to your question. Also, to accomplish a MERGE in SAS, there are some data input requirements, depending on the desired results. Below, you will find links to some SAS support website http://support.sas.com/ technical paper references for you to consider and review. Scott Barry SBBWorks, Inc. http://www2.sas.com/proceedings/sugi27/p052-27.pdf http://www2.sas.com/proceedings/sugi25/25/cc/25p109.pdf Reading, Combining, and Modifying SAS Data Sets - SAS DOC with subsections to review: http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a001125856.htm ... View more

SAS can provide several different approaches, for example, use a DATA step (with INFILE and INPUT statements) to read each external file, generating a SAS member, and then use PROC IMPORT to input the Excel file, generating a second SAS member, and a third DATA step with a SET statement to combine the two SAS member together. Scott Barry SBBWorks, Inc. http://support.sas.com/documentation/onlinedoc/base/index.html SUGI/SGF papers on DATA STEP processing: http://www2.sas.com/proceedings/sugi30/134-30.pdf http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf SUGI/SGF paper on PROC IMPORT: http://www2.sas.com/proceedings/sugi26/p159-26.pdf ... View more

My apology to the poster "SAS user" -- I read the reply incorrectly, not noticing the sender was different than the original. Scott ... View more

The SAS support website http://support.sas.com/ has a wealth of information and DOC for what you're asking. A search at the site using your keywords generates several hits. Also, a Google advanced search using the keywords below also provides many hits: +missover +truncover site:sas.com Also, you can add the following PUTLOG (new with SAS 9) statement to generate additional diagnostics with your DATA step to see how SAS handles the various conditions. Scott Barry SBBWorks, Inc. SAS 9.2 DOC on INFILE statement: http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000146932.htm SAS support DOC starting page (recommend bookmarking this page): http://support.sas.com/documentation/ ... View more

Again, you are not sharing your COMPLETE SAS code that is enter entered or generated from other SAS code. I do not see a %MEND statement, specifically. Scott Barry SBBWorks, Inc. ... View more

It would be most useful if you would share your SASLOG output to explain your problem, for assistance. Also, info about your data-points would be useful as well. Scott Barry SBBWorks, Inc. ... View more

Might I suggest searching the SAS.COM support website http://support.sas.com/ either directly (while visiting this referenced link) or possibly using the following Google advanced search argument: data validation clinical trials site:sas.com You will find several technical papers on the support site, from past SAS conferences. Scott Barry SBBWorks, Inc. ... View more

Search the SAS support website http://support.sas.com/ for DOC and related technical (SUGI / SGF) papers on PC data transfer/upload using SAS/Connect. Depending on the location and format of your "raw data", you will want to consider SAS PROC IMPORT, possibly, or using SAS DATA step processing to read up your data into SAS files for analysis and reporting. Scott Barry SBBWorks, Inc. SAS/Connect DOC: http://support.sas.com/documentation/onlinedoc/connect/index.html SAS PROC IMPORT (part of SAS Base): http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000332605.htm ... View more

You need to share code by pasting the SASLOG, and use a SAS DATA step PUT (or PUTLOG in SAS 9) statement for diagnosis purposes, something like: PUTLOG ">DIAG99" / _ALL_; I suspect that you will need to setup a "largest sized ARRAY" and use that with your outside DO/END with a DIM(array_name) function. And you must realize that the DO loop occurrences with your SAS variables (and the inside ARRAYs) will only work if they are declared, either with an explicit variable list or if the naming convention works, something like: DATA ; RETAIN XVAR1-XVAR99 0; ARRAY AXVAR (*) XVAR: DO I=1 TO DIM(AXVAR); * Create one obs for each var in the array. ; XVAR = AXVAR(I); OUTPUT; END; RUN; I would recommend adding the diagnostic code first, debug your program using the SASLOG info, and then if necesssary, contact the group for additional assistance. Remember to share your SASLOG output to help explain your situation. Scott Barry SBBWorks, Inc. ... View more

Use the DIM function with assignment statements, as needed, and remember to set variable values to missing/blank, such as: DATA; retain cv1-cv4 1 xv1-xv2 2; ARRAY ACV (*) CV1-CV4; ARRAY AXV (*) XV1-XV2; DO I=1 TO DIM(ACV); OUTVAR1 = ACV(I); IF I LE DIM(AXV) THEN OUTVAR2 = AXV(I); ELSE OUTVAR2 = .; OUTPUT; END; RUN; Scott Barry SBBWorks, Inc. ... View more