I did not know what was wrong with my error. Below I included the log part. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 Proc FREQ data=Newborn.have noprint; 74 TABLES SPEC_TYPE*HOSPITAL/out=Newborn.percent; 75 run; NOTE: There were 3723 observations read from the data set NEWBORN.HAVE. NOTE: The data set NEWBORN.PERCENT has 33 observations and 4 variables. NOTE: PROCEDURE FREQ used (Total process time): real time 0.02 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 2504.87k OS Memory 34620.00k Timestamp 05/03/2021 11:46:12 AM Step Count 233 Switch Count 10 Page Faults 0 Page Reclaims 565 Page Swaps 0 Voluntary Context Switches 85 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 1328 76 proc rank data=Newborn.percent out=Newborn.final; 77 where SPEC_TYPE = 0; 78 var pct_row; ERROR: Variable PCT_ROW not found. 79 ranks rank_pct_row; 80 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set NEWBORN.FINAL may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set NEWBORN.FINAL was not replaced because this step was stopped. NOTE: PROCEDURE RANK used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 729.96k OS Memory 33452.00k Timestamp 05/03/2021 11:46:12 AM Step Count 234 Switch Count 0 Page Faults 0 Page Reclaims 85 Page Swaps 0 Voluntary Context Switches 42 Involuntary Context Switches 0 Block Input Operations 288 Block Output Operations 16 81 82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 94
... View more
This is the sample dataset HOSPITAL SPEC_TYPE Hospital A 0 Hospital B 2 Hospital B 3 Hospital C 1 Hospital A 4 Hospital A 4 Hospital E 2 Hospital D 4
... View more
Yes, count the number of unsatisfactory specimens for each hospital, convert it into a percentage, and then give ranking according to the percentage.
... View more
The given solution did not work but I can provide you with an example of the dataset. COLLECTION_TIME RECV_TIME 1509 613 2033 625 30 615 2130 603 2114 720 1009 639 1457 553 2131 634 627 550 1702 632
... View more
I have a dataset with 9 hospitals and specimen types ranging 0-4 where 4=unsatisfactory. I need to calculate specimen types for each hospital and give rankings to the hospital according to the unsatisfactory specimen(4) percentages. How can we do this?
... View more
I have an excel sheet where the data set has columns with military time but no separators. How to convert the military time to hh: mm. For example, the columns have military time like 1509,7,30,637.
... View more
