Hello Everyone, I am using a macro I created for proc surveyfreq and it is taking a lot of CPU time (2:57:30 per variable) in order for the program to run. I was wondering if there was a more efficient way to run the program? Or perhaps there is a way I could check to see how the data is structured and fix the issue that way? When I remove the weight, the process time speeds up quite a bit. %macro tab1 (var); proc surveyfreq data = ACE.ACEDATASET; tables rucc* &var/ row col chisq; strata _STSR; weight _FINALWT2; cluster _NEWPSU run; %tab1 (ACEDEPRS2); %tab1 (ACEDIVRC); %tab1 (ACEDRINK); %tab1 (ACEDRUGS); %tab1 (ACEHURT); %tab1 (ACEHVSEX); %tab1 (ACEPRISN); %tab1 (ACEPUNCH); %tab1 (ACESWEAR); %tab1 (ACETOUCH); %tab1 (ACETTHEM); Thank you for your suggestions and solutions, Donald S. ... View more

Hello, I am trying to update a master table with 15,401 observations of rural-urban continuum codes where there are 651 observations are labelled as missing because they are redacted. Using proc update, I am trying to update those redacted values using another table with just those 651 redacted values that have been un-redacted via each observations sequence number. My code does update the table, but it makes the 14750 observations that were not redacted into missing values. PROC SQL; UPDATE major as m    SET RUCC_2013 = (select RUCC_2013 from minor where sequence_number = m.SEQNO); quit; Thank you for your solutions, Donald S. ... View more

Hello Everyone, I want to update a table based on values in another table, but I keep on getting errors in my log on the syntax when I use the "FROM statement". I am basing my code off an example I found and do not see any syntax errors. There is a comma (",") after N.ToyName in the example but that is because they are adding an additional variable. If you guys have any suggestions that would be great! Thank you! PROC SQL; UPDATE TEMP2     SET RUCC_2013 = m.RUCC_2013 FROM TEMP2 t JOIN minnesota m      ON t.SEQNO = m.sequence_number; Here is the log: 175  PROC SQL; 176  UPDATE TEMP2 177     SET RUCC_2013 = minnesota.RUCC_2013 178  FROM TEMP2 t JOIN minnesota m      ----      22      76 ERROR 22-322: Syntax error, expecting one of the following: ;, !!, *, **, +, ',', -, /, WHERE, ERROR 76-322: Syntax error, statement will be ignored. 179       ON t.SEQNO = m.sequence_number; Here is the example I based my code off of: Updating a Table Based on Values in a Different Table There may be times when you don’t want to manually write a bunch of UPDATE statements with different literal strings to update your table.  Suppose I wanted to change all the prices of my Toys with a single UPDATE statement. I can do that with the following code: UPDATE Toy    SET ToyName = N.ToyName,       Price = N.Price FROM Toy T JOIN NewToyPrice N      ON T.ID = N.ID;  In this code I updated the Toy table based on values in another table, in this case a table named NewToyPrice.  To accomplish that I joined the TOY table to my NewToyPrice table based on the ID column.  I then used the NewToyPrice column values for ToyName and Price to update my Toy table column values on rows that have matching column ID values. ... View more

Hello Everyone, I am trying to run a chi-square analysis on data pre vs. post an event. For example the event happened on the first day of April  2014 and I have data for the months Jan 14, Feb 14, Mar 14 ,April 13, and May 13 prior to the event occurring. I would like to include all the data prior to the event and all data post the event and compare them. I would like to do something like this: IF MONTH = 'April'         AND Year = 2013 THEN  EVENT  = 'PRIOR'; IF MONTH = 'May'         AND Year = 2013 THEN  EVENT = 'PRIOR'; IF MONTH = 'January'   AND Year = 2014 THEN EVENT  = 'PRIOR'; IF MONTH = 'February' AND Year = 2014 THEN EVENT  = 'PRIOR'; IF MONTH = 'March'      AND Year =2014  THEN EVENT  = 'PRIOR'; IF MONTH = 'April'   AND Year = 2014    THEN  EVENT  = 'AFTER'; IF MONTH = 'May'   AND Year = 2014     THEN  EVENT = 'AFTER'; IF MONTH = 'June'  AND Year = 2014     THEN EVENT  = 'AFTER'; I know AND statements do not exist in this sense. Is there a better way to approach this? I plan on running a proc freq for a chi-square analysis afterwards. Thank you! ... View more

So I have a question I don’t really know how to phrase. I have a variable called course_id that contains the identification for all participants who have gone through a training at a different site. There are multiple different training sites and therefore multiple course_ids that correlate to those different sites. I would like to run a chi square analysis on the number different training sites, but when I use the course_id variable it does not combine similar sites, but instead gives me the number of participants. In those sites via their course_id. I was wondering if there was a way to count the number of training instead of the total number of participants via using the course_id variable. For example if I have the following data set: course_id    location_of_site 00211              rural 00211              rural 00211              rural 33455              urban 33455              urban 33455              urban 66778              rural 66778              rural number_trainings_rural       number_trainings_urban               2                                              1 I hope I gave enough information and made this clear enough to understand my goal. Thank you for your time, Donald S. ... View more

Hello I am having some issues with my array. I am trying to turn a 5-tiered scoring system into a three tiered scoring for thirteen questions. The issues is that it only works for the first variable (Q1) and keeps the same values for the other variables. Does anyone have an idea of what might be going on? Thank you! DATA TEST2; SET TEST; array oldscore (13) Q1 Q2 Q3 Q4 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21; array newscore (13) Q1_new Q2_new Q3_new Q4_new Q13_new Q14_new Q15_new Q16_new Q17_new Q18_new Q19_new Q20_new Q21_new; do i = 1 to 13; do j = 1 to 13; if oldscore(i) GE 1 AND oldscore(i) LE 2 THEN newscore(j) = 1; if oldscore(i)= 3                        THEN newscore(j) = 2; if oldscore(i) GE 4 AND newscore(i) LE 5 THEN newscore(j) = 3; end; end; drop i j; RUN; ... View more