I need to match the exact month, day, and year for the seizure date (similar dates) to the drug and then the county where it was seized. For example, Seizure date Drug Quantity Unit County 12/31/2000 Marijuana 2.1 kg Something 12/31/2000 Marijuana 0.4 kg Something 12/31/2000 Marijuana 1.75 kg Something What I would like to have: 12/31/2000 Marijuana 4.25 kg Something ... View more

What I'm trying to determine is how to create a final summary table for the Baseline, Q1_2019, Q2_2019, Q3_2019, Q4_2019, Q1_2020, Q2_2020. I've received some errors which is located below in my log.  NOTE: There were 38424 observations read from the data set WORK.BASELINE_DM2. NOTE: The data set WORK.BASELINE_DM2 has 38424 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.11 seconds cpu time 0.09 seconds NOTE: There were 38424 observations read from the data set WORK.BASELINE_DM2. NOTE: The data set WORK.BASELINE_DM3 has 7403 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.03 seconds 1004 %final(Q1_2019); NOTE: There were 102559 observations read from the data set WORK.Q1_2019_F. NOTE: The data set WORK.Q1_2019_DM has 11026 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.06 seconds NOTE: There were 11026 observations read from the data set WORK.Q1_2019_DM. NOTE: The data set WORK.Q1_2019_DM2 has 10934 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.00 seconds NOTE: There were 10934 observations read from the data set WORK.Q1_2019_DM2. NOTE: The data set WORK.Q1_2019_DM2 has 10934 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds NOTE: There were 10934 observations read from the data set WORK.Q1_2019_DM2. NOTE: The data set WORK.Q1_2019_DM3 has 5162 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 1005 %final(Q2_2019); NOTE: There were 104559 observations read from the data set WORK.Q2_2019_F. NOTE: The data set WORK.Q2_2019_DM has 11136 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.07 seconds NOTE: There were 11136 observations read from the data set WORK.Q2_2019_DM. NOTE: The data set WORK.Q2_2019_DM2 has 10977 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: There were 10977 observations read from the data set WORK.Q2_2019_DM2. NOTE: The data set WORK.Q2_2019_DM2 has 10977 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: There were 10977 observations read from the data set WORK.Q2_2019_DM2. NOTE: The data set WORK.Q2_2019_DM3 has 5262 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 1006 %final(Q3_2019); NOTE: There were 101742 observations read from the data set WORK.Q3_2019_F. NOTE: The data set WORK.Q3_2019_DM has 10721 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.06 seconds NOTE: There were 10721 observations read from the data set WORK.Q3_2019_DM. NOTE: The data set WORK.Q3_2019_DM2 has 10577 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: There were 10577 observations read from the data set WORK.Q3_2019_DM2. NOTE: The data set WORK.Q3_2019_DM2 has 10577 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: There were 10577 observations read from the data set WORK.Q3_2019_DM2. NOTE: The data set WORK.Q3_2019_DM3 has 5213 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 1007 %final(Q4_2019); NOTE: There were 97979 observations read from the data set WORK.Q4_2019_F. NOTE: The data set WORK.Q4_2019_DM has 10062 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.06 seconds NOTE: There were 10062 observations read from the data set WORK.Q4_2019_DM. NOTE: The data set WORK.Q4_2019_DM2 has 9945 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 9945 observations read from the data set WORK.Q4_2019_DM2. NOTE: The data set WORK.Q4_2019_DM2 has 9945 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 9945 observations read from the data set WORK.Q4_2019_DM2. NOTE: The data set WORK.Q4_2019_DM3 has 5159 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 1008 %final(Q1_2020); NOTE: There were 93023 observations read from the data set WORK.Q1_2020_F. NOTE: The data set WORK.Q1_2020_DM has 9773 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.07 seconds NOTE: There were 9773 observations read from the data set WORK.Q1_2020_DM. NOTE: The data set WORK.Q1_2020_DM2 has 9637 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: There were 9637 observations read from the data set WORK.Q1_2020_DM2. NOTE: The data set WORK.Q1_2020_DM2 has 9637 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 9637 observations read from the data set WORK.Q1_2020_DM2. NOTE: The data set WORK.Q1_2020_DM3 has 5047 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 1009 %final(Q2_2020); NOTE: There were 77667 observations read from the data set WORK.Q2_2020_F. NOTE: The data set WORK.Q2_2020_DM has 9101 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.06 seconds NOTE: There were 9101 observations read from the data set WORK.Q2_2020_DM. NOTE: The data set WORK.Q2_2020_DM2 has 8985 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 8985 observations read from the data set WORK.Q2_2020_DM2. NOTE: The data set WORK.Q2_2020_DM2 has 8985 observations and 78 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 8985 observations read from the data set WORK.Q2_2020_DM2. NOTE: The data set WORK.Q2_2020_DM3 has 4389 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 1010 1011 /*CONTROL BY TIMEFRAME*/ 1012 %MACRO fin(file); 1013 1014 DATA work.&file._dm4; 1015 SET work.&file._dm3; 1016 IF (a1c_result<= 8) THEN DM_control = 1; 1017 IF (8< a1c_result <= 9) THEN DM_control = 2; 1018 IF (a1c_result > 9) OR (a1c_result = .) THEN DM_control = 0; 1019 run; 1020 data work.&file._dm5; 1021 set work.&file._dm4; 1022 if dm_control=1 then well_cntrl=1; else well_cntrl=0; 1023 if dm_control=2 then cntrl=1; else cntrl=0; 1024 if dm_control=0 then uncntrl=1; else uncntrl=0; 1025 RUN; 1026 1027 Data work.&file._dm6; 1028 set work.&file._dm5; 1029 if well_cntrl=1 then DM_cat= "well controlled"; 1030 if cntrl=1 then DM_cat= "controlled"; 1031 if uncntrl=1 then DM_cat= "uncontrolled"; 1032 run; 1033 1034 PROC SUMMARY data=work.&file._dm6; 1035 class well_cntrl cntrl uncntrl; 1036 output out=work.&file._summary sum=sum_wellcntrl sum_cntrl sum_unctrl; 1037 final_freq= (uncntrl/(well_cntrl+cntrl)*100 1038 run; 1039 1040 data=final.&file._sum_final; 1041 set work.&file._summary; 1042 controlled_DM= (sum_wellcntrl + sum_cntrl); 1043 keep sum_uncntrl controlled_DM final_freq; 1044 run; 1045 1046 1047 /*data work.&file._dm7; 1048 set work.&file._dm6; 1049 sum(uncntrl/ (well_cntrl + cntrl))*100; 1050 run;*/ 1051 1052 /*talk to vicki about SQL code 1053 PROC SQL;_ 1054 CREATE TABLE final.&file. AS 1055 SELECT uncntrl, Total, (uncntrl/ Total * 100) AS NQF0018 1056 FROM ( 1057 SELECT SUM(uncntrl) AS uncontrolled, COUNT(patient_ID) AS Total 1058 FROM work.&file._dm5 1059 ) 1060 ; 1061 QUIT; 1062 RUN;*/ 1063 1064 %MEND fin; 1065 1066 %fin(Baseline); NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 4384:58 4384:107 4384:153 4384:173 NOTE: Invalid numeric data, a1c_result='HEALTH_MAINTENANCE_COMPLETED' , at line 4384 column 58.   ... View more

Okay, to make sure I'm understanding correctly (I'm pretty much self-taught in PCA) because I specified METHOD=PRIN, and I did not use the COV option, that the input variables are standardized. We are using the correlation matrix (which I see in my output) and that is using standardized variables. Is that correct? So I would not need to change my code to make the input variables standardized? ... View more

Thank you for your quick response. This is the code I used:    Proc Factor data= data-set-name out= data-set-name nfact=37 simple method=prin priors=one mineigen= 0.99 scree rotate=varimax round flag=.40; var variables-to-be-analyzed run;   So even using METHOD=PRIN that will not standardize our variables to make sure I'm understanding you correctly?  ... View more