Hello Art,   I am looking for: a) at least one out of the fourth items to be 1 (or yes) 2) all of the fourth items to be 1 (or yes) 3) at least 2 out of the four items to be 1 (yes) 4 at least 3  out of the four items to be 1 (yes)   My codes showed the results. However, I would like to learn if there such SAS codes that can support mine. In the other words, to have the same results as my analyses.   Phan S.   ... View more

Hi ie,   data have; input ID @; do time1 to time4; input FD CL HS HL @; output; end; cards; 1 1 1 1 1 1 1 . 1 1 . . . . . 1 1 1 1 1 2 1 1 1 . 2 1 1 0 . . . . . . 2 1 1 0 1 3 1 0 0 0 3 0 0 1 1 . . . . . 3 1 0 . 1 4 1 0 0 . 4 0 0 0 . . . . . . 4 1 . 0 0 5 0 . 0 0 5 0 . 0 0 . . . . . 5 0 0 . 0 6 1 1 1 1 6 1 1 1 1 . . . . . 6 1 1 1 1 7 1 1 1 . 7 1 1 0 . . . . . . 7 1 1 0 1 8 1 0 0 0 8 0 0 1 1 . . . . . 8 1 0 . 1 9 1 0 0 . 9 0 0 0 . . . . . . 9 1 . 0 0 10 0 . 0 0 10 1 1 0 . . . . . . 10 1 1 0 1 ; run; time 3 do not have data ... View more

9653 data HAVE; 9654 input ID @; 9655 do YEAR=2002 to 2004; 9656 input FD CL HS HL @; 9657 output; 9658 end; 9659 cards; NOTE: The data set WORK.HAVE has 30 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.00 seconds 9670 run; 9671 9672 proc sql; 9673 create table WANT as 9674 select ID 9675 , case when min(NB_YES)=4 then 'Highly severe' 9676 when min(NB_YES)>1 then 'Severe' 9677 when min(NB_YES)=1 then 'Moderate' 9678 when min(NB_YES)=0 then 'None' 9679 else 'Mild' 9680 end as OUTCOME 9681 from ( 9682 select ID 9683 , YEAR 9684 , sum(FD, CL, HS, HL) as NB_YES 9685 from HAVE 9686 group by ID, YEAR 9687 ) 9688 group by ID; NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated table-expression referenced a summary function. NOTE: Table WORK.WANT created, with 10 rows and 2 columns. 9689 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.28 seconds cpu time 0.04 seconds 9690 proc freq data=outcome; ERROR: File WORK.OUTCOME.DATA does not exist. 9691 tables nb_yes; ERROR: No data set open to look up variables. 9692 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.01 seconds Hello, Reeza: Please kindly see the log and code below. data HAVE; input ID @; do YEAR=2002 to 2004; input FD CL HS HL @; output; end; cards; 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 . 1 1 0 . 1 1 0 1 3 1 0 0 0 0 0 1 1 1 0 . 1 4 1 0 0 . 0 0 0 . 1 . 0 0 5 0 . 0 0 0 . 0 0 0 0 . 0 6 1 1 1 1 1 1 1 1 1 1 1 1 7 1 1 1 . 1 1 0 . 1 1 0 1 8 1 0 0 0 0 0 1 1 1 0 . 1 9 1 0 0 . 0 0 0 . 1 . 0 0 10 0 . 0 0 0 . 0 0 0 0 . 0 run; proc sql; create table WANT as select ID , case when min(NB_YES)=4 then 'Highly severe' when min(NB_YES)>1 then 'Severe' when min(NB_YES)=1 then 'Moderate' when min(NB_YES)=0 then 'None' else 'Mild' end as OUTCOME from ( select ID , YEAR , sum(FD, CL, HS, HL) as NB_YES from HAVE group by ID, YEAR ) group by ID; quit; proc sort data=outcome; proc print data=want; var id; run; proc freq data=outcome; tables nb_yes; run; ... View more

Dear Chris, my apology to disturb you. I re-run the code, but I am not sure why "outcome" does exist in work.outcome.data.   I am looking for your advice. Thank you.   Phan S.      ... View more

Hello ChrisNZ,   Sorry for my delay. I accept your code as the solution. There is an issue, the outcomes came out only four categories. I played around but still give me only four.  You are welcome to test. BTW, I thank you for you time.   data HAVE; input ID @; do YEAR=2002 to 2004; input FD CL HS HL @; output; end; cards; 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 . 1 1 0 . 1 1 0 1 3 1 0 0 0 0 0 1 1 1 0 . 1 4 1 0 0 . 0 0 0 . 1 . 0 0 5 0 . 0 0 0 . 0 0 0 0 . 0 6 1 1 1 1 1 1 1 1 1 1 1 1 7 1 1 1 . 1 1 0 . 1 1 0 1 8 1 0 0 0 0 0 1 1 1 0 . 1 9 1 0 0 . 0 0 0 . 1 . 0 0 10 0 . 0 0 0 . 0 0 0 0 . 0 run; proc sql; create table WANT as select ID , case when min(NB_YES)=4 then 'Highly severe' when 2=min(NB_YES)<4 then 'Severe' when min(NB_YES)=1 then 'Moderate' when min(NB_YES)=0 then 'None' else 'Mild' end as OUTCOME_2 from ( select ID , YEAR , sum(FD, CL, HS, HL) as NB_YES from HAVE group by ID, YEAR ) group by ID; quit; ... View more

Dear Ballardw,   Thanks you for your time and I am going to test.   Phan S. ... View more

Hi Reeza,   Sorry, if you feel I am disrespect you. I don't mean this to you and anyone. My English is not primary. And thanks for your help/comment.   Phan S.   ... View more

No - SAS did not explode. I need you give me a full syntax of PROC SURVEYSELECT will select Random Samples.    ... View more

Appear not working.   How can I run proc freq from proc SQL?     Also, can you tell me how can I random extract a data? Example, I want to randomize extract and have a data of 50 subjects out from the original data of 2000+ subject.    ... View more

Thank you!!!! ... View more