I am running into a problem where I would like to duplicate data from one row that contains data to other rows with the same key value, but does not contain any additional data. However, ONLY conditioned if variable 3 or V3 is equal to "Cardio". For instance. I have a dataset that looks like this.         The first two row contain the same key, but the second row does not contain any other information other than the key (no value for v1,v2, v3 etc.) Because the first row has "cardio" for V3, this row would need to be duplicated to the second row that does not contain the information. Now the second image is what I want the dataset to look like.       How am I able to do that in SAS? Thanks in advance. ... View more

Good morning, I am currently creating an ordinal logistical model for my job and I am trying to diagnose the model to ensue that it fits the data. I am using the "lackfit" statement right after the model statement, however every time I run the code, the usual output is displayed, however no Hosmer and Lemeshow analysis is never displayed. I am currently using SAS 9.3 through SAS Enterprise 7.1. Here is my code below.    proc logistic data=upper_limit; class Profitrank dlr_zip RUCA2 area_description/ param= ref; model profitrank = num_booked--percentage_of_new average_vehicle_age--average_truist_rate RUCA2 state_median_income--state_pop State_pop*RUCA2/lackfit rsq; output out=new p=ppred; run;   Would greatly appreciate any help! ... View more