About di_niu0

di_niu0 · ‎07-13-2023

Got it. Thanks!

di_niu0 · ‎07-13-2023

What if I have many values? How to expand v{i} = v{i} * v{i-1}; ?

di_niu0 · ‎07-12-2023

Hi I've write another post to ask the question more clearly. https://communities.sas.com/t5/SAS-Programming/Write-codes-to-show-increment-of-a-sequence/m-p/884599#M349484

di_niu0 · ‎07-12-2023

Hi all. I would like to transform table 1 to table 2. Table 2 means the bigger value has to times all the previous values. How do I write the code to show such increment? Thanks! Table 1: Value1 Value2 Value3 5 6 7 Table 2: Value1 Value2 Value3 5 5*6 5*6*7

di_niu0 · ‎07-12-2023

Hi all. I would like to write codes to transform table from Table 1 to Table 2. Thank you! Table 1: ID Value1 Value2 Value3 1 1 2 3 2 4 5 6 3 7 8 9 Table 2: ID Value4 Value5 Value6 1 1-(1-1) 1-(1-1)(1-2) 1-(1-1)(1-2)(1-3) 2 1-(1-4) 1-(1-4)(1-5) 1-(1-4)(1-5)(1-6) 3 1-(1-7) 1-(1-7)(1-8) 1-(1-7)(1-8)(1-9)

di_niu0 · ‎04-28-2022

It's to incorporate other codes.

di_niu0 · ‎04-28-2022

Thanks!

di_niu0 · ‎04-27-2022

Please use data step if possible.

di_niu0 · ‎04-27-2022

Hi all, I am trying to sum the cost to get the variable TOTAL (it only has ID and cost in the original table). Please see below. Thank you in advance! ID COST TOTAL 1 10 100 2 40 100 3 50 100

di_niu0 · ‎12-09-2021

Hi All. I am doing a multilevel model using PROC GLIMMIX. proc glimmix data=schools method=quad; class school_id class_id; model score = class_id / solution dist=binary link=logit; random intercept / subject=school_id solution; run; Result: Covariance Parameter Estimates Cov Parm Subject Estimate Standard Error Intercept school_id 0.04852 0.39480 How do I output the p value for this estimate of parameter?

di_niu0 · ‎12-09-2021

Hi All. I am doing a multilevel model using PROC GLIMMIX. proc glimmix data=schools method=quad; class school_id class_id; model score = class_id / solution dist=binary link=logit; random intercept / subject=school_id solution; run; Result: Covariance Parameter Estimates Cov Parm Subject Estimate Standard Error Intercept school_id 0.04852 0.39480 How do I output the p value for this estimate of parameter?

di_niu0 · ‎11-30-2021

Thanks!!

di_niu0 · ‎11-30-2021

Hi All, How to transpose table 1 into table 2? Thanks! TABLE 1 Client StartDate EndDate OrderID1 OrderID2 OrderID3 1 01JAN 31JAN 1 . . 1 01FEB 29FEB 1 2 . 2 01MAR 31MAR 1 2 3 TABLE 2 Client StartDate EndDate OrderID 1 01JAN 31JAN 1 1 01FEB 29FEB 1 1 01FEB 29FEB 2 2 01MAR 31MAR 1 2 01MAR 31MAR 2 2 01MAR 31MAR 3

di_niu0 · ‎08-06-2021

Hi All, I've got a SAS data set like the one below. The second and third rows are the mean and median for the total fee, respectively. Similarly, the last two rows are the mean and median for the unit, respectively. This table is hard to do analysis. I would like to add some indicators to differentiate the two sets of mean and median. Not sure how to do. Thank you in advance. Variable Value total_fee mean 100 median 110 flag_customer 1000 unit mean 10 median 12

di_niu0 · ‎08-04-2021

Hi All, I have two data sets and would like to see the number of common IDs, number of IDs in data set 1 but not 2 and number of IDs in data set 2 but not 1. How should I write the PROC COMPARE. Thank you. Data Set 1: ID 1937 3947 6932 7059 9960 9999 Data Set 2: ID 1937 3947 4509 7059 8394 8899 9304

Online Status	Offline
Date Last Visited	‎07-21-2023 05:54 PM

Re: Write codes to show increment of a sequence

Re: Write codes to show increment of a sequence

Re: Write efficient code for a sequence

Write codes to show increment of a sequence

Write efficient code for a sequence

Re: How to sum a column

Re: How to sum a column

Re: How to sum a column

How to sum a column

How to output p value for covariance parameter estimates when using PR...

Re: How to apply loop in proc sql to create new variables in SAS

Re: Assign random date

Re: Assign random date

Re: Assign random date

Re: Create unique id based on two variables

Re: Write codes to show increment of a sequence

Re: Write codes to show increment of a sequence

Re: Write efficient code for a sequence

Write codes to show increment of a sequence

Write efficient code for a sequence

Re: How to sum a column

Re: How to sum a column

Re: How to sum a column

How to sum a column

How to output p value for covariance parameter estimates when using PR...

How to output p value for covariance parameter estimates when using PR...

Re: Transpose a datasets

Transpose a datasets

Restructure a table

Proc compare a common variable in two data sets