About Oligolas

Oligolas · ‎07-12-2021

Hi, I'm wondering if you could please help with a custom time format that could represent negative durations (end before start) That's what I've got, Time5. works but not my picture format DATA have; Bloodsample='2020-01-12T15:00'; Infusion='2020-01-12T15:10';output; Bloodsample='2019-11-18T14:40'; Infusion='2019-11-18T10:30';output; Bloodsample='2019-11-13T15:13'; Infusion='2019-11-18';output; RUN; PROC FORMAT; picture mytime low - < 0 ='%Hh %0Mmn' (datatype=time prefix='-') 0 - high='%Hh %0Mmn' (datatype=time) ; run; DATA want; set have; if length(Bloodsample) eq 16 and length(Infusion) eq 16 then do; dur=input(Infusion,b8601DT.) - input(Bloodsample,b8601DT.); time5=put(dur,time5.); picture=put(dur,mytime.); *ERROR for Infusion < Bloodsample; end; RUN; PROC PRINT;RUN;

Oligolas · ‎07-09-2021

In my eyes it looks like a randomisation. rule 1°) each person should have one type1/week AND one type2/week AND one type3/week. But only one type(1 or 2 or 3) per date (and per person). A)Can you have a type3 today and a type1 tomorrow? rule 2°) for each day, and each type (1,2,3), it should have at leat 2 persons B)Are you trying to get the maximum or the minimum possible occupation of persons per day and week? rule 3°) each person should have one type4 per month. it should be on saturday C)with 14 subjects and 4 weeks a month you would get an occupation of up to 4 persons a saturday, if I balance the groups, is that what you intend to do? rule 4°) each person should have one type5 in the week when he has a type4 D)Otherwise no day off!? how many type5 per month? E)And what are the rules for type0? what does type0 mean? How many per week/month? F)what's the difference between Type0 and Type5? G)Is there the intention to maximize or minimize some Types per week? get the less or the maximum occupation?

Oligolas · ‎07-09-2021

Hi, in SAS you have to adhere to the Rules for Most SAS Names when creating a dataset Special characters, except for the underscore, are not allowed. After a proc import for example from an excel file by using options validvarname=any; you could have datasets not respecting these rules. To further proceed, the solution is to rename the variables like this: PROC IMPORT out=test1 <..>RUN; data test2; set test1; rename 'Some strange variable name'n=var1; run; It's not clear to me if you can write out these special characters to a SQL server table, but it might be worth to try 'varname'n

Oligolas · ‎07-07-2021

Hi, this should help you for a start: PROC SQL ; CREATE TABLE have AS SELECT month(day) as month, week(day, 'w') as week, day , put(weekday(day),dowName.) as weekday, person , daytype_code, daytype_description FROM t_team , t_calendar, t_daytype ORDER BY month, week, day, person , daytype_code ; QUIT ;

Oligolas · ‎07-07-2021

DATA want; length STUDYID $8 DOMAIN $2 USUBJID $17 SEX $1; set have; array chars STUDYID DOMAIN SITENO PT SEX; do over chars; chars=strip(upcase(chars)); end; SUBJID=strip(put(PT,best.)); if cmiss(STUDYID,SITENO,SUBJID) ne 0 then put 'E' 'RROR: Missing unexpected variables encountered' STUDYID= SITENO= SUBJID=; else USUBJID=catx('-',STUDYID,SITENO,SUBJID); SEX=ifc(SEX^='',substr(SEX,1,1),''); RUN;

Oligolas · ‎07-07-2021

Hi, the order of execution is FROM ON JOIN WHERE GROUP BY HAVING SELECT DISTINCT ORDER BY Please consult https://www.w3schools.com/sql/ since this tutorial is excellent and what you need has nothing to do with SAS directly

Oligolas · ‎07-07-2021

Hi, what does your data structure look like? is this what you're looking for? data have; input week $; datalines; 1801 1802 1852 1901 1902 1952 2001 2002 2052 1701 1702 1752 2101 2102 2152 ; run; data want; set have; if '18'<=:week<=:'20'; run;

Oligolas · ‎06-22-2021

The code you posted contains a typo, you need to remove the semi-colon after "then"

Oligolas · ‎06-18-2021

data test; a= " 12345 *duplicate ID/Name "; b= input(compress(a,,'kd'),best.); run;

Oligolas · ‎06-11-2021

Hi, not sure I understood you properly, you mean, you'd like to do the same proc phreg for the variable Y and so on like this? proc phreg data=table1; model TIME*outcome (0)=Y/TIES = EFRON RL; array pp{*} Y1-Y5; array tt{*} t1-t6; t1=1; t2=2; t3=3; t4=4; t5=5; t6=6; if TIME <tt[1] then Y=Y0; else if TIME >= tt[6] then Y=Y6; else do i=1 to dim(pp); if tt[i] <= TIME < tt[i+1] then Y= pp[i];end; run; if yes then you only need to loop over the variables that you need: %MACRO loop(varlist=x y z); %local varlist i currItem; %LET i=1; %LET currItem=%SCAN(&varlist.,&i.,%STR( )); %DO %WHILE(%LENGTH(&currItem.)>0); proc phreg data=table1; model TIME*outcome (0)=&currItem./TIES = EFRON RL; array pp{*} &currItem.1-&currItem.5; array tt{*} t1-t6; t1=1; t2=2; t3=3; t4=4; t5=5; t6=6; if TIME <tt[1] then &currItem.=&currItem.0; else if TIME >= tt[6] then &currItem.=&currItem.6; else do i=1 to dim(pp); if tt[i] <= TIME < tt[i+1] then &currItem.= pp[i];end; run; %put &=varlist &=i &=currItem; %LET i=%EVAL(&i.+1); %LET currItem=%SCAN(&varlist.,&i.,%STR( )); %END; %MEND loop; %loop(varlist=X Y Z);

Oligolas · ‎06-04-2021

@ChrisNZ your solution is correct, my bad. I meant that all the variables had to meet the prefix defined, but one is enough according to the requirements. This is definitely haute couture of programming as I like it.

Oligolas · ‎06-03-2021

@Chris you need a starting anchor in the regex so IMHO catx is not suitable here maybe something like this: ARRAY attribs ATTRIB1-ATTRIB20; DO i=1 to dim(ATTRIBS); if not prxmatch('/^(123|13a|2a1)/',ATTRIBS(i)) then leave; if i eq 20 then output; END; drop i;

Oligolas · ‎05-31-2021

Hi, you need to escape with backslash each of the metacharacters {}[]()^$.|*+?\ DATA WANT; length regEx EscIgnoreChars $200 string $3000; STRING='β∞∞π'; EscIgnoreChars=translate(trim(' { } [ ] ( ) ^ $ . | * + ? \'),'\',' '); regEx=cats('s/','[','\w',EscIgnoreChars,',#-~`!@&_=><:;%',']','//i'); put regex=; Identified_Specialcharacters = cats('>>',prxchange(regEx,-1,STRING),'<<'); if Identified_Specialcharacters ne '>><<' then put 'E' 'RROR:' Identified_Specialcharacters=; RUN; Make sure you run SAS with unicode Support to be able to display any of the special chars.

Oligolas · ‎05-25-2021

Hi, use '30Apr2019'd or mdy(04,30,2019)

Oligolas · ‎05-25-2021

Hi, you might have leading not printable characters in your dataset but it's not clear to me. Can you provide some raw data?

Online Status	Offline
Date Last Visited	‎03-21-2025 04:50 PM

Re: Simplify proc sql multiple joins

Re: Use of colon after a comparison operator

Re: Use of colon after a comparison operator

Use of colon after a comparison operator

Re: IF-THEN statement not working for all observations

Re: Notation scientifique dans une variable de type alfanumerique $cha...

Re: Resolve macro variable name in intnx function to generate SQL code

Re: Resolve macro variable name in intnx function to generate SQL code

Re: nested macro definition causes :Open code statement recursion dete...

Re: nested macro definition causes :Open code statement recursion dete...

Re: Count number of value 1 using do loop

Re: cmiss(of _all_)

Re: How to create an if then statement to drop dates for the same obse...

Re: how do we apply where condition when there are multiple values in ...

Re: How dhms is calculating hours, minutes and seconds?

Re: Creating flag and additional record

Re: IF-THEN statement not working for all observations

Re: Count number of value 1 using do loop

Re: Using ODS Layout for customizing PDF Output

Re: Convert UTC timestamp string to date

Picture format for negative time duration

Re: algorithme to create planning with rules

Re: writing dataset with several special column names to SQL server

Re: algorithme to create planning with rules

Re: How do i get this concatinated output using Dataset method?

Re: explain about clauses funtionalities

Re: Array for character variable with two changing components

Re: If condition in SAS

Re: Remove different types of characters together from numeric values

Re: How to export HR (95% CI) from Proc Phreg Macro

Re: Looping through variables when importing data

Re: Looping through variables when importing data

Re: SAS Programming

Re: problem with if statement on dates

Re: How to remove ^M Junk values while converting sas dataset to flat ...

SAS Analytics Explorers