12-27-2024
tarheel13
Rhodochrosite | Level 12
Member since
12-05-2017
- 593 Posts
- 311 Likes Given
- 39 Solutions
- 136 Likes Received
-
Latest posts by tarheel13
Subject Views Posted 542 11-06-2024 05:18 AM 608 11-05-2024 10:51 PM 648 11-05-2024 08:45 PM 2234 05-12-2024 07:08 AM 684 05-04-2024 10:24 PM 703 05-04-2024 07:20 PM 2358 05-04-2024 06:59 PM 1492 03-09-2024 06:06 PM 1825 03-06-2024 10:39 AM 1829 03-06-2024 10:37 AM -
Activity Feed for tarheel13
- Posted Re: SAS installation is stuck on SAS Programming. 11-06-2024 05:18 AM
- Posted Re: SAS installation is stuck on SAS Programming. 11-05-2024 10:51 PM
- Liked Re: Extracting line from free text that contains a keyword for s_lassen. 11-05-2024 08:46 PM
- Posted SAS installation is stuck on SAS Programming. 11-05-2024 08:45 PM
- Liked Re: Identify and flag the latest day for Patrick. 05-13-2024 10:26 AM
- Liked Re: account verification for kortom01. 05-13-2024 10:25 AM
- Posted Re: Seeking Advice on SAS for Entry into Pharma Industry on New SAS User. 05-12-2024 07:08 AM
- Liked Re: create a new library for Ronein. 05-09-2024 02:13 PM
- Posted Re: Identify death date over a list of dates on New SAS User. 05-04-2024 10:24 PM
- Liked Re: Person-years form a start to an end date for Quentin. 05-04-2024 07:27 PM
- Posted Re: Identify death date over a list of dates on New SAS User. 05-04-2024 07:20 PM
- Liked Re: Interaction plot for Ksharp. 05-04-2024 07:02 PM
- Posted Re: Seeking Advice on SAS for Entry into Pharma Industry on New SAS User. 05-04-2024 06:59 PM
- Liked Re: How do I return the data on nth row of a dataset? for FreelanceReinh. 03-12-2024 09:13 AM
- Liked Re: How to count rows that come after a certain date? for Bumble_15. 03-12-2024 09:12 AM
- Posted Re: How to count rows that come after a certain date? on SAS Programming. 03-09-2024 06:06 PM
- Liked Re: macro within a macro for yabwon. 03-08-2024 08:09 AM
- Liked Re: a question on regular expression for Patrick. 03-07-2024 06:35 AM
- Liked Re: a question on regular expression for Patrick. 03-07-2024 06:34 AM
- Liked Re: Need help to impute NULL with value from the same ID for Patrick. 03-06-2024 01:27 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 03-06-2024 10:35 AM 1 03-06-2024 10:39 AM 1 03-04-2024 02:46 PM 1 03-04-2024 02:40 PM 1 01-05-2024 07:17 AM
01-11-2025
10:26 AM
Does anyone have the code that created the CDISC Pilot study data . I cant upload the data and I need to regenerate in my environment
... View more
11-06-2024
05:18 AM
I just extracted the whole thing again and I still cannot get past 3. SAS/SECURE Java Component.
... View more
05-12-2024
07:08 AM
well no one will really want to hire you without CDISC experience but you need to know CDISC to get hired. well you are going to have to be hired as associate stat programmer or stat programmer I. at the entry level, you should not have to know as much CDISC. but people don't necessarily have time to train on SDTM and ADaM so that's why they are reluctant to hire someone without CDISC.
... View more
05-04-2024
10:24 PM
Index_date has values of 0 and 1. You are talking about the code variable
... View more
03-11-2024
08:20 AM
1 Like
Thank you so much! this worked well 🙂
... View more
03-06-2024
11:30 PM
1 Like
You need to pass the RegEx as a string to the SAS RegEx function. That's why you need the outer quotes. The can be single or double quotes.
"/^'\s*'$/"
To not get into some complicated masking exercise the inner quotes must just be different from the outer quotes (if outer single then inner double and vise versa).
The inner quotes are now just part of the Regular Expression - which I assume is not what the developer intended to do.
The RegEx is: ^'\s*'$
^ Beginning of string
' the single quote character
\s a non-printable character ,
* zero, one or many occurrences of the previous character -> zero, one or many non-printable characters
' the single quote character
$ end of string
Above RegEx will find a match if the source string only contains zero, one or multiple non-print characters that are embedded into single quotes. If there is any other character in the string then it won't be a match (because of ^'...'$).
Because SAS is padding character variables with blanks what's also really important is to use trim() or strip() around the source variable to search.
... View more
03-06-2024
11:23 AM
1 Like
Ok sounds the best solution also for further computations. I will keep them as they are until the analysis will be finished. Thank you very much!
... View more
03-04-2024
07:16 PM
Thanks for your suggestion:)
... View more
01-20-2024
10:49 AM
might want to check your local SAS user groups as well as your university resources if you're a student or recent graduate. pharmaceutical companies and CROs as well as academic medical centers should be hiring statisticians. LinkedIn can sometimes help you find a job too.
... View more
01-15-2024
09:42 AM
1 Like
I assume that what you have are SAS text variables that contain carriage returns and/or linefeeds. To extract the relevant lines from that, you could try something like this (assuming your initial variable is called TEXT, and the found lines will be in the variable LINE):
data want;
set have;
prxid=prxparse('/[^\r\l]*carbapenem[^\r\l]*/i');
pos=1;
do until(0);
call prxsubstr(prxid,text,pos,len);
if pos=0 then leave;
line=substr(text,pos,len);
output;
pos+length;
end;
run;
... View more
01-15-2024
05:47 AM
Hi @Kurt_Bremser
do you have solution for below scenario...
My supervisor has another bizarre request with RANK value in this data
This is how we develop RANK value up till now. but my client need highlighted value for obs. 7 and 8 as 5 and not 1
like this...
Reason: He says...while deriving RANK value for obs. 7, he wanted to check latest of LLT = urea value, which is obs. no. 4 and AENDT of obs. no. 4 is not equal to ASTDT of obs. no. 7, so we need to keep adding RANK +1.
currently while deriving RANK value for obs. 7, we are considering obs. no. 3.
can we modify our existing code for this requirement.
sorry to trouble you with this again.
I am also attaching the datalines for this.
data test;
input @1 usubjid $3.
@5 ae $8.
@14 llt $8.
@23 astdt date9.
@33 aendt date9.
;
format astdt aendt date9.;
datalines;
410 amino alan 19JUL2022 08AUG2022
410 amino aspar 01AUG2022 08AUG2022
410 Toxicity urea 26JUL2022 18AUG2022
410 Toxicity urea 02AUG2022 15AUG2022
410 Toxicity prot 08AUG2022 21SEP2022
410 Toxicity creat 11AUG2022 22AUG2022
410 Toxicity urea 18AUG2022 18AUG2022
410 Toxicity urea 18AUG2022 02SEP2022
410 Toxicity minuria 29AUG2022 21SEP2022
410 Toxicity urea dec 15SEP2022 21SEP2022
720 Toxicity estim 27DEC2022 17JAN2023
720 Toxicity urea 03JAN2023 17JAN2023
720 Toxicity creat 10JAN2023 24JAN2023
720 Toxicity estim 17JAN2023 28FEB2023
720 Toxicity urea 31JAN2023 14FEB2023
720 Toxicity creat 31JAN2023 14FEB2023
720 Toxicity urea 21FEB2023 28FEB2023
720 Toxicity estim 28FEB2023 21MAR2023
;
run;
... View more
01-05-2024
07:17 AM
1 Like
I learned call execute in a class I took at my university.
... View more
01-03-2024
08:02 PM
Paige, It is about stuff submitted to FDA ,not about " If I was a professor grading the presentations". I agreed with tarheel . There are standard table layout you have to follow up if you are in Pharam field . It is not up to you to discuss these questions, it is question for statisticians and FDA . You just followed it if you are a sas programmer .
... View more