Hi,   I am currently working on a report which I want to refresh each month with the latest data - I have a date parameters representing the current month, but my question is if there anyway I can increment it using the calculated items to create multiple date parameters as I want to specify the periods for which my data is from and I can't see any other feasible way of doing this?   Thanks ... View more

Hi, I'm trying to create a table like this:   From this output:   I only want to keep the values where both variable have a value of 1. The above output was created using the following code: Proc surveyfreq data=work.ocd; table dsm_OCD*(Contamination_OC Harming_OC Ordering_OC Hoarding_OC Sex_rel_mor_OC Any_OC One_OC Two_OC Three_OC Four_OC Five_OC)/nowt; weight finalp2wt; run; ... View more

    refer to an old post below. i searched , but can't find any sample program. can anyone post a specific link for sample program? thanks.   Solved: Nonmem Program - SAS Support Communities ... View more

Hi,   I have 2 data sets like below.    Data one A 1 A 2 B 1 B 2   Data two  A Apple A Peach B Banana   I need to join them (Cartesian join), but only join by ID (A and B).    This is what I want to get:    A 1 Apple A 1 Peach A 2 Apple A 2 Peach B 1 Banana B 2 Banana   If I use the below code,  proc sql; create table three as select one.* ,two.* from one ,two; quit;   What I have got was  A 1 Apple A 1 Peach A 1 Banana A 2 Apple A 2 Peach A 2 Banana B 1 Apple B 1 Peach B 1 Banana B 2 Apple B 2 Peach B 2 Banana   Is there any way to only join by the ID (A, B)?    Thank you very much! ... View more