About cpulala

cpulala · ‎10-16-2018

Thanks for the suggestions. It does not matter if R can handle it or not; it is just requirements. So did you mean that I was not choosing a correct solution? But I did not see any error when transferring it back to DATE format, and so I chose it.

cpulala · ‎10-15-2018

Somebody who uses R for the next step requires the datetime. format for date.

cpulala · ‎10-15-2018

Thank you very much!

cpulala · ‎10-15-2018

Thank you so much! One typo after SCAN function - should be "," instead of "."

cpulala · ‎10-15-2018

Hi, I am seeking for help on formatting a date variable. Please see the example as below. I would like to format the date1 variable from char $12. to num (length 8, final format DATETIME. and informat ANYDTDTM40). The solution I have thought about is firstly to remove the comma and make the date1 into 01Aug2018 format (then I know how to process further), but how can I achieve this first step (the underlined)? Or, any other solutions/ suggestions? Thank you very much. I really appreciate it. /*1-raw data*/ data have; input id date1 $12.; datalines; 1 Aug 01, 2018 2 Aug 16, 2018 3 Jul 17, 2018 4 Sep 30, 2018 ; run; /*2-solution?*/

cpulala · ‎09-12-2017

Thanks. Please see the previous response on the hypothesis. I understood the proc freq for categorical variables, but not sure which test to use when ordinal variables were involved. I can deem the ordinal variable as categorical, but only when there is no specific way for the oridinal variable by categorical variable (over 2 levels).

cpulala · ‎09-12-2017

Thanks for the note. I wanted to test (1) whether cat_var is statistically significant between each comparison group. (2) whether the value (proportion) for each level of cat_var is different from each other. For question(1), usually chi-square by using proc freq for 'categorical var by categorical var' is used, however, I am not sure which test to use for ordinal variable by categorical variable. Thanks.

cpulala · ‎09-12-2017

Hi I wanted to report p-value for this table The column variables are ordinal variables (4 levels) The row variables are categorical variables (4 levels) Table cells are reported as proportions for each categorical variable by column. The total number of observations for each column is different. group1 group2 group3 group4 p-value cat_var P level 1 % % % % P1 level 2 % % % % P2 level 3 % % % % P3 level 4 % % % % P4 My questions are (1) which test to use for the P-value (row variable by column variable) in orange color (2) which test for the p-value in green color, to have the p-value for each level by column variable (cell value reported as proportion) Thanks!

cpulala · ‎08-13-2017

Thanks! All responses work. It is hard to decide which one is the best solution; I choose the answer with the earliest response.

cpulala · ‎08-13-2017

Thanks! It works. But when the dataset has multiple IDs, a 'by ID;' statement need to be used.

cpulala · ‎08-13-2017

Thanks! It works.

cpulala · ‎08-12-2017

Hi, I have a dataset looks like below: ID Visit CurrentTotal 1 0 0 1 0 1 1 1 0 1 0 3 1 1 2 1 1 1 1 1 0 For the same ID, there are three parts of data - the observations in black, red and blue. For each part, I need to count the total number of visits. Right now, the CurrentTotal variable is displayed in the dataset, which is not correct for the counts of each part (black, red and blue). What I would like to ask is that "How to add a variable "TargetTotal" as shown below to have the correct number of visit count for each part? How can the SAS codes be able to rank three orders within the same ID?" The order should start with 0, and end till the next 0, so there are three parts (the black, red and blue t) for the same ID. ID Visit CurrentTotal TargetTotal 1 0 0 0 1 0 1 0 1 1 0 1 1 0 3 0 1 1 2 1 1 1 1 2 1 1 0 3 Thank you very much. Looking forward to the solutions.

Online Status	Offline
Date Last Visited	‎02-05-2021 03:03 PM

Re: Date Format

Re: Date Format

Re: Date Format

Re: Date Format

Date Format

Re: Test for p-value

Re: Test for p-value

Test for p-value

Re: How to rank three orders within the same ID and count the number o...

Re: How to rank three orders within the same ID and count the number o...

Re: Date Format

Re: Date Format

Re: WARNING: Obtaining minimum variance quadratic unbiased estimates a...

Re: WARNING: Obtaining minimum variance quadratic unbiased estimates a...

Re: sums and counts by group

Re: How to rank three orders within the same ID and count the number o...

Re: Date Format

Re: Date Format

Re: Date Format

Re: Date Format

Date Format

Re: Test for p-value

Re: Test for p-value

Test for p-value

Re: How to rank three orders within the same ID and count the number o...

Re: How to rank three orders within the same ID and count the number o...

Re: How to rank three orders within the same ID and count the number o...

How to rank three orders within the same ID and count the number of ob...