Hello everyone!   I need to convert a .RTF file into a .PDF file. I created the RTF with ODS RTF and proc report. I tried using ODS PDF, but the columns come out pretty weird so I thought using X command would be easier, the problem is, I can't figure out which executable  in Microsoft Office10 if the correct one for the x command. Is anyone familair with doing this? Here is the code I have so far:     x '"C:\Program Files\Office\Office14\_______.exe" c:\report\temp.rtf d:\report\tempxx.pdf /Y';     Thank you! ... View more

Hello, I would like to get a range of both the power and totlaN output from proc power while using the current ntotal = 3514.    For example, I would like this output table:   N       power 100       .10 200       .20 300       .30     proc power; twosamplefreq test=pchi sides = 2 alpha = 0.05 groupproportions = (0.0965, 0.0627) ntotal = 3514 power = .; title 'Cohort 1 / 35% RRR'; plot x =N min=200 max = 8000; ods output output = power; proc print data=Power; var NTotal Power ; run;     Is this possible? I know I can create a graph with this range, but can I get the output from the graph?   Thank you!   Donald S. ... View more

Hello everyone, I am trying to create a summary score based on eight dichotomous variables (labelled 1/2 instead of 0/1 since I am going to be doing my regression analysis in SUDAAN). Each of the variables has missing values and I would like my array to show that IF there are more than four missing values between the eight variables for a single observation THEN the observation is read as missing. Otherwise, if there are less than four missing values between the eight variables, then the score will be between 1-8. This is what my array looks like at the moment (a shoutout to PhilC for helping fix my array) and it works for giving me a sum score between 1-8. ARRAY ACE_ARRAY[8]  ACEPRISN2 ACEDIVRC2 ACEDEPRS2 ACESXAB ACESUBS ACEPUNCH2 ACESWEAR2 ACEHURT2; SUM_ACESCORE = 0; do i=1 to 8; drop i;   SUM_ACESCORE+ACE_ARRAY; end; I assume you can use some type of IF/THEN statement in the DO loop to do this, but I cannot figure out how to signify "four or more missing values". As always Thank you guys for your help! Donald S. ... View more

Hello everyone, I have an array with eight dichotomous (yes,no) variables and I want to sum the variables such that I get a range of scores 0-8 (0 being none of them have any 'yes's' and 8 being all of the variables are yes. Then for any of the scores lower than 4 I would like to make missing. I am getting the SUM of all the variables as a dichotomous and not an 8 level score. Is there a better way to code this? ARRAY ACE_ARRAY[8]  ACEPRISN2 ACEDIVRC2 ACEDEPRS2 ACESXAB ACESUBS ACEPUNCH2 ACESWEAR2 ACEHURT2; SUM_ACESCORE = sum(of ACE_ARRAY[8]); IF SUM_ACESCORE <= 4 then SUM_ACE = ' '; Thank you, Donald S. ... View more

Hello, I am trying to recode a 5 level categorical variable into a dichotomous variable and SAS  is not recognizing the last three levels: "Dont Know/ Unsure", 'Parents not married' , and 'Refused'. data probably; set temp3; IF ACEDIVRC  = 1              THEN test  = 1; IF ACEDIVRC  = 'No' OR ACEDIVRC  = 'Dont Know/ Unsure' OR ACEDIVRC  = 'Parents not married' OR ACEDIVRC  = 'Refused' THEN test  = 2; IF ACEDIVRC  = ' '  THEN test  = '.'; Run; When I run a proc freq it only shows the frequencies "No" level in the second level. I wrote another code to just look at one of the other levels and chose the "Refused" level because it doesn't have any spaces in its name. This is the Code: data probably; set temp3; IF ACEDIVRC  = 1 THEN test1    = 1; IF ACEDIVRC  = 2 THEN test2    = 2; IF ACEDIVRC  = 'Refused' THEN test3  = 3; Run; proc freq data = probably; tables ACEDIVRC  test1 test2 test3 /MISSING; run; The proc freq automatically defaults the third level to the frequency of the missing values (See below, test3). Any idea how to fix this issue?    ACEDIVRC     . 8626 8.36 8626 8.36 Yes 18292 17.72 26918 26.08 No 74957 72.63 101875 98.71 Dont Know/ Unsure 305 0.30 102180 99.01 Parents not married 519 0.50 102699 99.51 Refused 504 0.49 103203 100.00    test1     . 84911 82.28 84911 82.28 1 18292 17.72 103203 100.00    test2     . 28246 27.37 28246 27.37 2 74957 72.63 103203 100.00    test3     . 94577 91.64 94577 91.64 3 8626 8.36 103203 100.00 Thank you! I am using SAS 9.4. ... View more