I want to pass multiple value to one macro parameter.     %macro cardataset (carlst=); data new; set sashelp.cars; if make in(&carlst); run; %mend cardataset; %cardataset(carlst="Audi","BMW","Ford") When I am trying to run above macro, I get following error   Statement is not valid or it is used out of proper order. ERROR: All positional parameters must precede keyword parameters.     ... View more

Dear all,              I am trying to import Excel file using 2 different program and also tried using SAS import wizard but non of them help me out :    Program 1:   proc import datafile="W:\auto\Trial.xlsx" out = T dbms = xlsx ; sheet="TI"; getnames=yes; run; gives all observation but warning message in log :   WARNING: Some character data was lost during transcoding in column: IETEST at obs 3.   Program 2:   libname sur pcfiles path="W:\auto\Trial.xlsx" ; data ag; set sur.'Ti$'n; run; Both of the program are not able to read "β" (Beta-symbol) and superscript number come to base.   Can you please help me to deal with importing "xlsx" without changing special character.     Sample excel data     ... View more

Dear All,              I want to extract all dates from  term variable:   The data in term vriables is:   Days of 08 April 19 count on 10 May 2019, 05 May  2018, 08-Jan-2005 apply i.e. 08 April 19 and 10-Jan-2005   I want ro extract all dates from above variable, in one or multiple vriables using regex or perl regular expression    I tried the following program but I am geting only last date   data cd.new; set cd.Date_ex; dsdate=prxchange('s/.*(\d{2}(\s+|-)\w+(\s+|-)\d{2,4}).*/\1/', 1, term); run; Output: 08 April 19 08-Jan-2005 10-Jan-2005   ... View more

I am trying following code: data new; input id Value $; datalines; 1 50 2 1 3 500 4 56 5 1000 ; run; data new1; set new; where prxmatch('/\d{2}/',Value); run; After submitting above code, I am getting following output: According to following documentation https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/265-29.pdf Expected output: id Value 1 50 4 56 But in output I am getting 2 digit number and greater then 2 digit number even-though my pattern is only for 2 digit number       ... View more