Greetings,   I am working on SAS code to create several dichotomous variables using IF-THEN-ELSE statements. I need to create SAS codes for multiple sites where the questions numbers changes between each site. Snapshot of a data set with standard question number and Q #s for site1 and site2.   Standard Question # Site1 Question # Site2 Question # V1 V12 V4 V2 V2 V7 V3 V6 V3 V4 V9 V1 V5 V5 V9 V6 V4 V10 V7 V8 V6 V8 V9 V8 V9 V1 V13 V10 V2 V11   Below is a sample code that uses the standard question number. The code that I have. HAVE base code IF V1=1 THEN VAR1=1; ELSE VAR1=2; IF V2=2 THEN VAR2=2; ELSE VAR2=2; IF V3 IN (1,2,3) THEN VAR3=1; ELSE VAR3=2; IF V4 IN (1,5) THEN VAR4=1; ELSE VAR4=2; IF V5=1 THEN VAR5=1; ELSE VAR5=2; IF V6=2 THEN VAR6=2; ELSE VAR6=2; IF V7 IN (1,5) THEN VAR7=1; ELSE VAR7=2; IF V8=1 THEN VAR8=1; ELSE VAR8=2; IF V9=2 THEN VAR9=2; ELSE VAR9=2; IF V10 IN (1,2,3) THEN VAR10=1; ELSE VAR10=2;   I need to create codes for site1 and site2, below: Need code for Site1 Need code for Site2 IF V12=1 THEN VAR1=1; ELSE VAR1=2; IF V4=1 THEN VAR1=1; ELSE VAR1=2; IF V2=2 THEN VAR2=2; ELSE VAR2=2; IF V7=2 THEN VAR2=2; ELSE VAR2=2; IF V6 IN (1,2,3) THEN VAR3=1; ELSE VAR3=2; IF V3 IN (1,2,3) THEN VAR3=1; ELSE VAR3=2; IF V9 IN (1,5) THEN VAR4=1; ELSE VAR4=2; IF V1 IN (1,5) THEN VAR4=1; ELSE VAR4=2; IF V5=1 THEN VAR5=1; ELSE VAR5=2; IF V9=1 THEN VAR5=1; ELSE VAR5=2; IF V4=2 THEN VAR6=2; ELSE VAR6=2; IF V10=2 THEN VAR6=2; ELSE VAR6=2; IF V8 IN (1,5) THEN VAR7=1; ELSE VAR7=2; IF V6 IN (1,5) THEN VAR7=1; ELSE VAR7=2; IF V9=1 THEN VAR8=1; ELSE VAR8=2; IF V8=1 THEN VAR8=1; ELSE VAR8=2; IF V1=2 THEN VAR9=2; ELSE VAR9=2; IF V13 THEN VAR9=2; ELSE VAR9=2; IF V2 IN (1,2,3) THEN VAR10=1; ELSE VAR10=2; IF V11 IN (1,2,3) THEN VAR10=1; ELSE VAR10=2;   I have several sites that I need to recreate and would like to see if there is a simpler way to update the V#s instead of going through each code.   Thanks. RVAS. ... View more

I need to get predicted marginals and SEs for multiple variables by year to evaluate trend. Below is part of the code that I extracted from the macro to keep it simple. I am posting part of the code where I see the error of insufficient memory error. Unfortunately I am unable to use option MEMSIZE=MAX since I am running SAS/SUDAAN in virtual desktop. Also using vitual memory option (USEVMEM=1) in the code. CODE: OPTION MRECALL stimer fullstimer ; Proc rlogist data=One design=wr filetype=sas est_no=230000  usevmem=1 noprint; Nest Yr stratum psu/psulevel=3 missunit; Weight weight; Model X1= S R G Yr R*Yr; Class S R G Yr; Pedmarg R*Yr; Test waldf; Output predmrg seprdmrg/filename=X1 replace filetype=sas predmrg=f12.4 predmrg=f7.2; Run; ERROR:   Any guidance would be appreciated. Thanks in advance.   ... View more

Greetings,   I am trying to create a summary group variable that evaluates values in multiple columns. Snapshot of data below. ID R1 R2 R3 R4 R ABC 1 0 9 9 1 DVF 0 0 1 1 Multiple EF 1 1 9 0 Multiple RR 9 0 1 0 3 GGH 1 0 9 0 1 HJY 0 9 0 1 4             Partner: 1=Yes, 0-No   R1-R4: 1=Yes, 0=No, 9=Don't Know   Column R is what I am trying to create. If R1=1 and R2-R4 is 0,9 then R=1 If R3=1 and R1,R2,R4 is 0,9 then R=3 If R1=1, R2=1 and R3-R4 is 0,9 then R=10 (Multiple)   THanks in advance.   ... View more

Greetings, I have a data with 5 columns for each partner, test results for each partner (POS1-POS5 if positive, NEG1-5 for negative results). Te last set of columns is age group of that partner. Snap shot of my data below.   Partner1 Partner2 Partner3 Partner4 Partner5 POS1 POS2 POS3 POS4 POS5 NEG1 NEG2 NEG3 NEG4 NEG5 Age1 Age2 Age3 Age4 Age5 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 10-15 10-15 16-20 21-25 50+ 1 1 0 0 0 1 0 0 0 0 0 1 0 0 0 16-20 21-25 50+ 10-15 10-15 1 1 1 1 0 0 0 1 1 0 1 1 0 0 1 21-25 50+ 10-15 50+ 50+ 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0 10-15 10-15 16-20 21-25 50+   I am trying to create a count of how POS and Neg by age group.   e.g.If there is 1 partner with age A1 then #A1=1, A2=0, A3=0, A4=0 2 partners with A1 and A3 then #A1=2, A2=0, A3=1, A4=0 3 partners with A1, A3, A4 then #A1=3, A2=0, A3=2, A4=1 4 partners with 2 in A1, 2 in A4 then #A1=5, A2=0, A3=2, A4=3   Snapshot of my final output:   POS NEG Age1     Age2     Age3     Age4       I used SUM (of POS1-POS5) and SUM (of NEG1-Neg5) to get no. of positives and negatives. But not sure how to proceed with POS and NEGs by age group.   THanks in Advance. ... View more

Good Morning,   I am checking for invalid values for all variables in a dataset. My data has more than 250 numeric values and I know the range of values for all the variables. Some have a range of 0-6 and blank as values and some have 0-4, 99, ., and blank as valid values. I found several examples like using proc freq, proc format along with data step, data step with where and put statement. All the techniques I found seem to be little time consuming and I am on a time crunch.   I was wondering if there is much efficient way to get this done. Any recommendations would be really appreciated.   Thanks. rsvs   ... View more