changing the order of values in a variable in sas data (row-wise ordering ) -
my sasdata output this.

can make values in particular order ?(change order of rows)
ie in order of "less 10 lakh, between 10-20 lakh,between 21-30.... above 1 crore".
i want change row order. right rows ordered in ascending order. can in manual order?
build format , order data after format value:
proc format; invalue i_range 'above rs. 1 crore' = 6 'between rs. 10-20 lakh' = 2 'between rs. 21-30 lakh' = 3 'between rs. 31-50 lakh' = 4 'between rs. 51 lakh - rs. 1 crore' = 5 'less rs. 10 lakh' = 1 ; run; data temp_order; set hsi_income_range; order_data = input(incomerange,i_range.); run; proc sort data = temp_order; order_data; run; data hsi_income_range (drop= order_data); set temp_order; run;
Comments
Post a Comment