About Oligolas

Oligolas · ‎09-24-2021

the 'now' option is only available since the TS1M5 release of SAS9.4 I'm afraid you'll need to use the good old excelxp tagset to accomplish these results and convert the xml afterward to a native xlsx document.

Oligolas · ‎09-24-2021

Hi, you've seen LOTR too often, remember Sauron looses it all in the end. Just joking. Well thank you for sharing, it's interesting since you're using fcmp

Oligolas · ‎09-22-2021

Hi, there is a way but why don't you simply use surveymeans?? PROC SURVEYMEANS data=sashelp.class geomean; var age; run; if you still want to use proc means, proceed like this: DATA class1; set sashelp.class; ln_age=log(age); run; PROC MEANS data=class1 mean stddev; var ln_age; output out=class2means mean=a_mean stddev=a_stddev; run; DATA class3; set class2means; geo_mean=exp(a_mean); geo_stddev=exp(a_stddev); run; PROC PRINT data=class3 noobs; var geo_mean geo_stddev; run;

Oligolas · ‎09-21-2021

Well, you could check if the value of 'new' does not correspond to one of the terms to exclude before incrementing your count. For my part, as counting proceeds rather vertically, i'd like to transpose the 'diags', count them and merge back the results: data have; input id diag_1 :$9. diag_2 :$9. diag_3 :$9. diag_4 :$9. diag_5 :$9. age; cards; 01 diabetes stress . . . 42 02 stroke cancer stroke infection death 78 03 stroke copd . copd . 66 ; run; PROC TRANSPOSE data=have out=hlp1; by id; var diag_1-diag_5; RUN; PROC SQL; CREATE TABLE hlp2 AS SELECT id, count(DISTINCT col1) AS count FROM hlp1 WHERE upcase(col1) NOT IN ('STRESS' 'INFECTION') GROUP BY id ; CREATE TABLE want AS SELECT a.*,b.count FROM have a LEFT JOIN hlp2 b ON a.id eq b.id ; DROP TABLE hlp1,hlp2 ; QUIT;

Oligolas · ‎09-16-2021

Hi, use 'IN' instead of contains

Oligolas · ‎09-01-2021

Hi, use this: DATA have; input patient_id collection_date : $15. test_type : $15. test_result : $15.; datalines; 1 3/1/2020 Antibody Positive 1 3/3/2020 PCR Positive 1 3/14/2020 PCR Negative 2 2/12/2020 Antibody Negative 2 4/10/2020 Antibody Positive 3 6/10/2020 Antibody Positive 3 6/15/2020 PCR Negative ; RUN; PROC SQL; CREATE TABLE have1 AS SELECT a.*, CASE WHEN missing(b.patient_id) then 1 ELSE 0 END as noPCR_done FROM have a LEFT JOIN have b ON a.patient_id eq b.patient_id AND upcase(b.test_type) eq 'PCR' ORDER BY a.patient_id, a.collection_date, a.test_type ; QUIT; DATA want; set have1; *select patient having no PCR done and having any AB positive; where noPCR_done eq 1 AND upcase(test_type) eq 'ANTIBODY' AND upcase(test_result) eq 'POSITIVE'; RUN;

Oligolas · ‎08-31-2021

Hi, You'll find what you need in the dictionary tables. You'll get the list of columns with this query: PROC SQL noprint; SELECT name INTO :my_var SEPARATED BY ', ' FROM sashelp.vcolumn WHERE libname eq 'SASHELP' AND memname eq 'CLASS' ; QUIT; %put &=my_var;

Oligolas · ‎08-04-2021

Hi, did you check if you have missings in your treatment variable?

Oligolas · ‎07-16-2021

My suggestion is that you rename your variables with valid variables names before any further processing. (_2020_01 instead of 2020-01) Based on the results of your proc contents this is how I would do it here: DATA have1; set GD.GLIMS_DATA_2021_MERGE; RUN; DATA _NULL_; set sashelp.vcolumn(keep=libname memname name) end=last; where libname eq 'WORK' and memname eq 'HAVE1' and prxmatch('/^[0-9]/',name); length newname $32; newname=cats('_',translate(name,'_','-')); if _N_ eq 1 then call execute('DATA HAVE2; SET HAVE1; rename '); call execute("'"||strip(name)||"'n="||strip(newname)); if last then call execute(';RUN;'); RUN; DATA want; length Eerder_2021 8; set HAVE2; Eerder_2021 = (Sum(of _201:)+sum(of _2020:)); RUN;

Oligolas · ‎07-16-2021

These are invalid variable names, since they start with a digit. Did you import them from an excel sheet?

Oligolas · ‎07-16-2021

Hi, With your variable names fixed, this is how I'd expect your dataset to be. And in your request you specify 2021 but your code only adds up to 2020. %MACRO doit(); DATA have; length count 8; %let count=0; %do i=14 %to 21; %do j=1 %to 12; _20%sysfunc(putN(&i,z2))_%sysfunc(putN(&j,z2))=1; %let count=%eval(&count.+1); %end; %end; count=&count; output; RUN; %MEND doit; %doit(); DATA want; length Eerder_2021 8; set have; Eerder_2021 = (Sum(of _201:)+sum(of _2020:)); RUN;

Oligolas · ‎07-14-2021

Hi, I think there must be a lot of similar/repetitive data in your XML. For every day/activity? You may be able to analyze and reduce the source data to feed the XML mapper, see #3

Oligolas · ‎07-14-2021

Hi, thank you all for your posts that led to this powerful demonstration. I think for now a single line data step check is the easiest solution. But wow, I'm astonished by the combination of fcmp with the format, never thought of that. One is able to logically adjust the format on the fly, it's amazing. I'll definitely use it in the future and optimize some processes Thank you very much

Oligolas · ‎07-13-2021

Hi, I guess you've got unicode signs in your datasets. 1.Start SAS with unicode support and 2. Run this to identify the variables: %let libname=TMP1; DATA _NULL_; SET sashelp.vtable(keep=libname memname); WHERE libname eq "%upcase(&libname.)"; call execute("DATA WORK."||strip(memname)||"; set &libname.."||strip(memname)); call execute(compbl('ARRAY chars _CHARACTER_; DO OVER chars; if prxmatch("/[^\x20-\x7E]/",chars) then put "W" "ARNING:# special character detected in '||strip(memname)||' dataset " chars=; END;') ); call execute('RUN;'); RUN;

Oligolas · ‎07-13-2021

Hi, thanks the 3rd row is fine, sorry for the ambiguity. My problem is the 2nd row. @ballardw So, do you mean minus signs are not allowed because the %H directive is showing hours? @data_null__ indeed with '-%Hh %0Mmn' I get a minus sign output " -19h 50mn" with datatype=datetime, but I'd like to modify the picture format to get "-4h 10mn" in the 2nd row. in a datastep I would fix it with PROC FORMAT; picture mytime low - high ='%Hh %0Mmn' (datatype=time); RUN; and want=cats(ifc(dur<0,'-',''),put(abs(dur),mytime.)); But how can I do this with the picture format?

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

Re: Export to XLSX Excel :2 sheets and 3 tables in each sheet

Re: The concat function to rule them all

Re: Is there a way to find geometric mean in proc means

Re: Counting number of unique responses by row, across multiple variab...

Re: How to use 'like' or 'contains' in case there are a list of values...

Re: Working with multiple obs for same person - choosing a particular ...

Re: Working with metadata, I have a list of columns I want to dynamica...

Re: Why I got incorrect number of All obs after PROC PSMATCH procedure...

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

Re: Is there a way to read iphone 12 pro max status data XML

Re: Picture format for negative time duration

Re: Format ERROR

Re: Picture format for negative time duration

SAS Analytics Explorers