proc import datafile="C:\Users\xxxx\Desktop\Rajadhani_Trains.xlsx" out=rajadhani dbms=xlsx replace ; getnames=yes; quit;   Hi Guys, Here i have excel file in Tr_No variable observations have embeded spaces please see above marking so i want remove embaded space while import that file  ... View more

data nth_occurence; string="abc12abc56abc" ; run; how to find nth abc (nth occurence) substring in a string without regex ... View more

data test1; input id state $15. ; datalines; 111 Texas 222 Florida 333 Kansas 444 Lowa 555 Louisiana ; run; data test2; input id state $15. ; datalines; 666 Hawaii 777 Kentucky 888 Maryland 999 Michigan 110 Missouri ; run; data test3; input id state $15. ; datalines; 112 Montana 113 Neveda 114 New Jersey 115 New York 116 Virgina ; run; proc sql ; select * from test1 (obs=1) union select * from test3 (obs=1) union select * from test2 (obs=1); quit; How to extract first record from each table using proc sql i tried above code   monotonic function is undocumented so in this case how to achive with proc sql for N records pull from tables ... View more

Hi Experts, What is difference between worddate and nldatel formates  Can you  explain with examples above formats ... View more

data ds; length emp_name $20; input emp_name $ dep_id salary; datalines; Siva 1 30000 Ravi 2 40000 Prasad 1 50000 Arun 1 30000 Sai 2 20000 ; run; proc sql; create table _temp as select dep_id,max(salary) as max_sal ,min(salary) as min_sal from ds group by dep_id ; create table _temp as select a.* ,b.emp_name as emp_name_min,c.emp_name as emp_name_max from _temp as a left join ds as b on a.min_sal=b.salary left join ds as c on a.max_sal=c.salary; quit; proc sort data=_temp nodupkey ; by dep_id; run; proc print; run; How to get min and max salary for each dept_id using proc sql and datastep in the above code result I got only one minsalary from dep_id 1 but given data two min salary are same how to fix this ... View more

Hi experts, Here I want to extract S ,E ,y letters contains team  for example output South Africa Egland Albany data dsn; input team $ 20.; datalines; India India Australia South Africa England Albany ; run; data want; set dsn; where team like 'S%' and 'E%' or '_y'; run; ... View more

data ds; array x[10] ( 1, 2, 3, 4, 5, 6, 7, 8, 9,10); do i = 1 to dim(x); if mod(x[i], 2) = 0 then do; even_number = x[i]; output; end; end; drop i; proc print noobs; run; i want output like below   x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 even_numbers 0 2 0 0 0 0 0 0 0 0 2 0 0 0 4 0 0 0 0 0 0 4 0 0 0 0 0 6 0 0 0 0 6 0 0 0 0 0 0 0 8 0 0 8 0 0 0 0 0 0 0 0 0 10 10   ... View more