changing the order of values in a variable in sas data (row-wise ordering ) -


my sasdata output this.

enter image description here

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

Popular posts from this blog

How to connect android app to App engine -

gcc - MinGW's ld cannot perform PE operations on non PE output file -

php - display validation error message next to the textbox in codeigniter -