data have; input age1 age2 age3 age4 age5 age6; datalines; 11 22 33 44 55 65  44 88 99 65 32 77 ; run;   data want ; input age1 age2 age3 age4 age5 age6  final_age; datalines; 11 22 33 44 55 65  65  44 88 99 65 32 77  99 ; run; ; run;     ... View more

data have; input product_code product_1 product_id; datalines; 1011/1234                        abc  99 1011                                  def    88 1023/4098/7778/8989      gcj      76 ; run;   data want; input product_code product_1 product_id; datalines; 1011        abc  99 1234       abc  99 1011      def    88 1023      gcj      76 4098      gcj      76 7778      gcj      76 8989      gcj      76 ; run; ... View more

i have excel file that contain variable like name age date. and every date is in different format. i import this date as character and now the problem is i dont no how to get date in one format.     data have; input name age date; datalines; rahul 66 03dec2020 rohit  55 2020nov17 nisha 44 12/10/2020 ; run;      data want; input name age date; datalines; rahul 66 03dec2020 rohit  55 17nov2020 nisha 44 10dec2020 ; run;  ... View more

i can do this using proc sql but my variables are 100 so it will take lot of time .Is their any other way so that i haven't to wright 100 variable in select statement   data a; input s1 s2 s3 s4; datalines; 1  2  3 4 2  2  4  5 9  9  9  9 ; run; output s1  s2  s3  s4 12 13  16   18 ... View more

data have; input num1 num2; datalines; 1  2 4  3 7  9 11  10 ; run;   output  num1     num2      num3 1              2             2 4              3             4 7              9             9 11            10            11   ... View more

data have; input state $ income; datalines; delhi             1000 delhi             3000 chandigarh   4000 chandigarh   3000 patna             300 delhi               400 ; run;   data want; input state $ income; datalines; delhi             4400 chandigarh   7000 ; run; ... View more

animal         city    dog         delhi cat           delhi lion          delhi bear       mumbai cat           mumbai mouse     mumbai dog          chennai mouse      chennai bear          chennai         output  animal         city  delhi            bear delhi            mouse mumbai       dog mumbai       lion chennai       cat chennai       lion     ... View more

data have; input accid   branch; datalines; 1001  pune,hyderabad,banglore 1002  haryana,delhi 1003  shimla ; run;     data want; input accid  branch; datalines; 1001  pune 1001  hyderabad 1001  banglore 1002  haryana 1002  delhi 1003  shimla ; run; ... View more

i have 10000 variable and i want to keep only 500 variable. without using keep drop ... View more