I have two variables   one is named yr and is an integer e.g. 2017 and one called quarter taking values Q1, Q2, Q3 etc.   How can I produce a variable called Time which contains YearQuarter concatenated e.g. 2017Q1 etc?   I tried this:   rsubmit; DATA dataset_1; SET dataset_1; Time=cat(yr, quarter); RUN; endrsubmit;    but it returns empty values ... View more

Hello,   I have a dataset that has date entried in the following form:   2017-06-30 2017-06-30   and I would like to generate a new variable that has the year and the quarter in the following format:   YYYYQQ   i.e. the above entries would be:   2017Q2   How can I do that? ... View more

I am using a weighted logistic regression of the form:   rsubmit; proc logistic data=dataset_1 outest=stepwise_ot; model dependent_variable(event="1") = var1 var2 var3 var4 var5 var6 var7 / selection = stepwise details expb stb lackfit rsquare; weight correct_weight; output out=Output_1 pred=PD Xbeta=logodds p=est_response; store output_1; run; endrsubmit;   for the first row SAS gives me a value of the linear predictor equal to -1.118603402 while when I do the calculations in Excel through a linear relationship of the form intercept + b1*x1 + b2*x2 + ..... with the estimated coefficients I get -1,118603402... Could this be due to a rounding error? How does SAS calculate the value of the Linear Predictor? ... View more

The output of a logistic regression gives me the following information:     Association of Predicted Probabilities and Observed Responses     Percent Concordant 71,3 Somers' D 0,457 Percent Discordant 25,6 Gamma 0,471 Percent Tied 3,1 Tau-a 0,164 Pairs 56483682 c 0,728   and    Response Profile       OrderedValue deterioration TotalFrequency TotalWeight 1 0 13542 19214,7 2 1 4171 7150,3     What is the formula to calculate the percent concordant from the above? ... View more

I am using the following code to estimate the average of a column:   rsubmit; proc sql; create table want as select *, mean(total_balance) as avg_balance from have; quit; endrsubmit;   in the following dataset:   total balance 100 200 300 400   and I am getting output   total balance avg_balance 100               100 200               200 300               300 400               400   instead of    total balance avg_balance 100               250 200               250 300               250 400               250     what am I doing wrong? ... View more

I have a dataset that looks like:   Variable name qy                        balance 2010 Q1              100 2010 Q1              100 2010 Q2              150 2010 Q2              150 2010 Q3              50 2010 Q3              50 2010 Q4              20 2010 Q4              20 2011 Q1              300 2011 Q2              300   and I would like to create a new variable sum_balance_per_quarter that has the sum of the balances per quarter i.e. desired output:      Variable name qy                        balance             sum_balance_per_quarter  2010 Q1              100                    200 2010 Q1              100                    200 2010 Q2              150                    300 2010 Q2              150                    300 2010 Q3              50                      100 2010 Q3              50                      100 2010 Q4              20                       40 2010 Q4              20                       40 2011 Q1              300                      600 2011 Q2              300                      600       How can I do that? ... View more