@FreelanceReinh , Thank you. Perfect solution ... View more

No need to modify the macro.  1559 1560 %cardataset(carlst=("Audi","BMW","Ford")) MPRINT(CARDATASET): data new; MPRINT(CARDATASET): set sashelp.cars; MPRINT(CARDATASET): if make in(("Audi","BMW","Ford")); MPRINT(CARDATASET): run; NOTE: There were 428 observations read from the data set SASHELP.CARS. NOTE: The data set WORK.NEW has 62 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.04 seconds IN operator does not seem to mind extra random parentheses (although it would complain if actually included brackets like [ ] or { } ). ... View more

@surajmetha55 wrote: 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     You might try changing your SAS session encoding to UTF-8. If your SAS session encoding is already UTF-8 then I'm not sure why you are having the issue unless proc import is somehow treating the file as having Latin encoding.         ... View more

It is really uneasy . This could give you a start.   data have; input have $80.; cards; 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 ; data want; set have; pid=prxparse('/\b\d+\W+[a-z]+\W+\d+\b/i'); s=1; e=length(have); call prxnext(pid,s,e,have,p,l); do while(p>0); want=substr(have,p,l); output; call prxnext(pid,s,e,have,p,l); end; drop s e p l pid; run; ... View more

You need not, need to Install R in your PC. You can directly use it on cloud platform. See the following link, might be helpfull.  link: https://rstudio.cloud/ ... View more

Hi @surajmetha55    The devil is in the detail. You omitted the little caret-symbol ^ from @andreas_lds 's code. ... View more