About Abraham

Var_Jog · ‎10-25-2021

As mentioned in that link, changing parsing validation level from 'High' to 'Minimal' worked. But just trying to find out adverse effects (if any) of not using 'High' validation when parsing. Can anyone provide futher information as to which option is used as a 'default' or there are any rules around parsing levels. Thanks.

Astounding · ‎03-18-2019

I'm the sluggard using the handheld: 3 minutes late.

Abraham · ‎02-27-2019

Perfet Patick. Thanks once again for your time in looking into my issue. If possible, check that I am getting one duplicate records with quote in the last row which is not required. Based on your suggestion, I will convert all double quote ("") with ("""") Thanks once again

Tom · ‎11-08-2017

Don't include the trailing spaces in your search pattern. where upper(c.product) like '%' || upper(trim(m.Med_product)) || '%' or upper(p.product) like '%' || upper(trim(c.Med_product)) || '%' Or better still just use the FIND() function. where find(c.product,m.Med_product,'it') or find(p.product,c.Med_product,'it') Also note that the UPPER() function is only available in SQL code. The normal SAS function of UPCASE() can be used anywhere in SAS code.

Kurt_Bremser · ‎10-25-2017

Why do you want to have 226 included? There's no blank at the beginning or in the middle, only at the end. Checking a SAS character variable for trailing blanks makes no sense, as _all_ SAS character variables have trailing blanks (unless they're completely filled). "Empty" character variables contain blanks. To find the others, you might want to check if indexc(trim(countryname),' ') > 0;

Abraham · ‎10-24-2017

Can anybody help me is it possible to capture special characters using regular expression including space. Thanks in advance

Abraham · ‎08-11-2017

Thanks for the solution

Abraham · ‎07-14-2017

Thanks Shmuel for your great help and guidance. The issue is still there. I will try with some other program.

Patrick · ‎05-25-2017

@Abraham I didn't expect such volumes.... That means also for the If..Then..Else approach that you're tendentially going to scan the "Clob" many times before you get a hit. You could split up your Event data into multiple RegEx. Not sure which one of the two approaches would perform better. I believe it's "if..then..else". If you've got any idea which events should happen more often (i.e. you've got some additonal distribution info) then make sure to pre-sort the event table accordingly from most common to most rare events.

Abraham · ‎03-03-2017

Thank you very much everyone for your support and help

Ksharp · ‎11-01-2016

Maybe you can use the Oracle function like sas's lengthm() to get that character variable length. proc sql; connect to oracle (user=abc orapw=bcd path=efg); create table work.emp as Select * from connection to oracle (SELECT * , lengthm(char_var) as len FROM IBM.Employee ); disconnect from oracle; quit;

Patrick · ‎12-09-2015

If you really MUST download all the data from Oracle then one thing which could eventually speed up things is storing the data in SAS using the libname SPDE engine.

PGStats · ‎11-16-2015

To complement @Astounding's ideas, if your records are properly grouped (all records for the same pid/disease appear together) but not always in order, you could do: data want; do until(last.disease); set abc; by pid disease notsorted; firstSno = min(firstSno, sno); end; /* To skip groups with a single record */ if first.disease then call missing(firstSno); do until(last.disease); set abc; by pid disease notsorted; if sno = firstSno then do; output; /* To get only the first record of ties */ call missing(firstSno); end; end; drop firstSno; run;

RW9 · ‎08-03-2015

Hi, data want; set emp; length dts $200; retain dts; by deptno; if first.deptno then dts=put(doj,date9.); else dts=catx(',',dts,put(doj,date9.)); if last.deptno then output; run;

Kurt_Bremser · ‎07-02-2015

Try this: data report; set hospital (keep=patno serial lab Sdate); by patno lab serial; retain prev_date; format prev_date date9.; if first.lab then prev_date = .; output; if sdate ne . and sdate > prev_date then prev_date = sdate; run;

Online Status	Offline
Date Last Visited	‎03-18-2019 11:24 AM

Copy all tables beginning with certain keyword from one lib to other

Re: capture data within brackets into respective column along with ali...

Re: capture data within brackets into respective column along with ali...

Re: capture data within brackets into respective column along with ali...

Re: capture data within brackets into respective column along with ali...

Re: capture data within brackets into respective column along with ali...

capture data within brackets into respective column along with alignme...

Like operator not working during pattern matching

Getting error while importing xml file

how to capture character variable data containing space

Re: How to capture special character space in character string

Re: How to display dataset record in email template

Re: Not send email if error exist

Re: Not send email if error exist

Re: Operator Contain not working while searching text in CLOB column c...

Remove null value from CLOB data with spl char.

Re: Getting error while importing xml file

Re: Copy all tables beginning with certain keyword from one lib to oth...

Re: capture data within brackets into respective column along with ali...

Re: Like operator not working during pattern matching

Re: how to capture character variable data containing space

Re: How to capture special character space in character string

Re: How to display dataset record in email template

Re: Not send email if error exist

Re: Operator Contain not working while searching text in CLOB column c...

Re: Like operator not working

Re: How to include space in sas

Re: pass through facility very slow

Re: find record

Re: Display row data in a line

Re: Not getting correct output when using function