Let's assume I have data like this: data have;
input state $ project_lenght_days;
cards;
success 9
failed 5
canceled 6
success 15
success 17
failed 12
failed 22
canceled 23
success 25
failed 27
;
run; I would like to establish successful rate and present it as interval on chart 1-10, 10-20, 20-30 days. I've found the same analyze on kaggle, but it's in R, code from the analyze is: length.pct <- ksdata %>%
filter(state %in% c("successful", "failed"), length <= 61) %>%
group_by(length, state) %>%
summarize(count=n()) %>%
mutate(pct=count/sum(count))
ggplot(length.pct[length.pct$state=="successful",], aes(length, pct)) +
geom_point(colour="royalblue4", size=2.5) + ggtitle("Success Rate vs. Project Length") +
xlab("Project Length (Days)") + ylab("Success Rate (%)") +
scale_x_continuous(breaks=c(0,10,20,30,40,50,60)) + geom_vline(xintercept=30, colour="red") +
theme_economist() +
theme(plot.title=element_text(hjust=0.5), axis.title=element_text(size=12, face="bold")) In my data I assume that canceled and failed state are equal to failed project. Is it possible to make something like this in SAS with the sample Data i have?
... View more