About Mystik

Mystik · ‎11-27-2018

I was able to get around it. Firstly i created new variables for all my groups of interest. Then using IF, OR and THEN statements i was able to create my Pheno group. Finally, defining a new variable and using IF statement, i was able to create my three exclusive groups. Thanks!

Mystik · ‎11-26-2018

Thank you. I was able to execute the 1st step however, i got an Error: the Format GRP was not found or could not be loaded. Can you pls give me some clarifications in the 2nd step; data "temp"; set "have"; what specifically should "temp" and "have" denote?

Mystik · ‎11-25-2018

I have been working around this since Friday, can't seem to get around it. Let me present my case again. I have over 232million observations. I need to categorize my IDs into 3 groups. Namely Whyz, Emfy and Pheno based on codes which an ID has in hltcode. ID's have more than one observations for hltcode. If an ID have only one of the following codes (35, 37, 38, 39, 484, 7827, 2728, 2539, 2218, 2721912) in hltcode then it is Whyz. If an ID have only one of the following codes (728, 7298, 722, 27218, 2721821, 27282, 27218) in hltcode then it is Emfy. However if an ID have both Whyz code AND Emfy code in hltcode then that ID needs to categorized as Pheno. Also, If any ID have any of these codes (637383, 35363, 9830) then that ID also have to be categorized as Pheno. Now, there are other 5 groups, called Klig, Uttr, Thaip, Ghait, Dondj the hltcode for Klig are (6373, 3633, 73392, 11928, 638383, 362892, 3691101) Uttr are (7748, 373229, 372382, 363763, 36373) Thaip are (872920,647474, 3731738, 646) Ghait are (77747, 6377, 36787, 46478498, 738991) Dondj are (7733, 63599, 37383, 3663, 37137) if any ID have a hltcode for Whyz AND Klig then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Whyz AND Klig AND Dondj then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Whyz AND Thaip AND Dondj then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Emfy AND Thaip then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Emfy AND Utter AND Thaip then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Emfy AND Dondj AND Thaip then that ID also have to be categorized also as Pheno. if any ID have a hltcode for Emfy AND Klig AND Dondj then that ID also have to be categorized also as Pheno. This was what i tried doing but realized that was not appropriate based on suggestions in SAS community. libname obs_rad "C:\obs_rad"; data obs_rad.radft; set obs_rad.radft; data obs_rad.SOB; set obs_rad.radft; if hltcode in (262, 2727, 26252, 227272) then alc_grp="Whyz"; if hltcode in (626228, 227, 22772, 26252, 7383) then alc_grp="Emfy"; if hltcode in (637383, 35363, 9830) then alc_grp="Pheno"; if hltcode in (636, 6363, 4484, 37393, 383839, 393, 3737) and hltcode in (636, 2262, 2627, 26272) then alc_grp="Pheno"; if hltcode in (262, 2727, 26252, 227272) and hltcode in (636, 6363, 4484, 37393, 383839, 393, 3737) and hitcode in 636, 2262, 2627, 26272) then alc_grp="Pheno"; proc freq data=obs_rad.SOB; table alc_grp; run;

Mystik · ‎11-23-2018

However, i need some clarifications. 1. My 3 distinct groups are Whyz, Emfy or Pheno. That means each of my ID has to be grouped into either Whyz, Emfy or Pheno. In your last SAS statement, you coded: drop Whyz Emfy lgel etope 2. Also, if an ID with a hltcode of both Whyz AND Emfy = Pheno hltcode of both Whyz AND Etope = Pheno hltcode of both Emfy AND Lgel = Pheno hltcode of Emfy, Lgel, Etope = Pheno hltcode of both Polp AND Lopr= Pheno Actually i have 13 features: Whyz, Emfy, Etope, Lgel, Etope, Polp, Klig, Uttr, Thaip, Ghait, Dondj, Lopr, Bduc. It can be a combination of any two only, three only or four only which i have to define based on the definition in the literature. There is a code for Pheno only as well, which needs no combination but represent "Pheno".

Mystik · ‎11-23-2018

Thanks!

Mystik · ‎11-23-2018

***////This is an example of my input data into SAS look like. The codes in the bracket are not necessary what they represented///*****; libname obs_rad "C:\obs_rad"; data obs_rad.radft; set obs_rad.radft; data obs_rad.SOB; set obs_rad.radft; if hltcode in (262, 2727, 26252, 227272) then alc_grp="Whyz"; if hltcode in (626228, 227, 22772, 26252, 7383) then alc_grp="Emfy"; if hltcode in (636, 6363, 4484, 37393, 383839, 393, 3737) and hltcode in (636, 2262, 2627, 26272) then alc_grp="Pheno"; if hltcode in (262, 2727, 26252, 227272) and hltcode in (636, 6363, 4484, 37393, 383839, 393, 3737) and hitcode in 636, 2262, 2627, 26272) then alc_grp="Pheno"; proc freq data=obs_rad.SOB; table alc_grp; run;

Mystik · ‎11-23-2018

No please. There is another variable called "ID"; Therefore; if If an ID has a code in hltcode that contains only one code in Whyz, then it's Whyz. If an ID has a code in hltcode that contains only one code in Emfy, then it's Emfy. if an ID has a code in hltcode contains BOTH codes of Whyz AND Emfy, then it's Pheno. if an ID has combination of 3 codes of Whyz AND Emfy AND Lgel, then it's still Pheno If an ID has combination of 4 codes of Whyz AND Emfy AND Lgel AND Etope, then it's still Pheno. Also, an ID have several observations for hltcode

Mystik · ‎11-23-2018

Please! I have a data that has one of its variable called hltcode. The hltcode variable have codes that denotes different features. I need to create another variable (called hlt_grp) and group Whyz, Emfy and Pheno based on a code or combination of codes from hltcode. Any of these codes in hltcode (35, 37, 38, 39, 484, 7827, 2728, 2539, 2218, 2721912) represent Whyz any one of these codes (728, 7298, 722, 27218, 2721821, 27282, 27218) represent Emfy any one of these codes (73, 252, 27, 252, 262782, 5262, 27272, 27282, 2722, 272626, 25215,526) represent Lgel any one of these codes (6316, 126137, 126316, 1351, 2636, 26317, 73171) represent Etope Therefore; If a code in hltcode contains ANY code of Whyz, then it's Whyz. If a code in hltcode contains ANY code of Emfy, then it's Emfy. if a code in hltcode contains BOTH codes of Whyz AND Emfy, then it's Pheno. if a code in hltcode should have a combination (3 combinations) of Whyz AND Emfy AND Lgel, then it's still Pheno If a code in hltcode should have a combination (4 combinations) of Whyz AND Emfy AND Lgel AND Etope, then it's still Pheno. I have tried series of SAS trials but don't seem to work out completely. Please any help?

Mystik · ‎11-22-2018

worked out perfectly. Thanks!

Mystik · ‎11-22-2018

Hello, I am running this data (called drases) and wanted the resulting SAS data to be created (tcalled all_drases), to be stored in one of my Library folders (called jdata) instead of that file automatically going into Work folder. Please what is the appropriate SAS programming for this? Below is the SAS program i am running; libname samma "F:\samma"; data drases; set samma.drases; data all_drases; set drases; if crodcode in (678, 790, 890, 898, 920, 930, 940) then alc_grp="AMAS"; if crodcode in (67, 87, 93, 97, 98, 99, 1028, 8282, 82829, 63789) then alc_grp="AMAL"; run;

Mystik · ‎11-14-2018

Hello, Your Webinar was very helpful. However, you did speak about cartesian product interactions for Inner Join but not for Full Join. I run a sas program and had a problem where observations that should be 57Million is now over 300Million. This was what i run; proc sql; create table t12 AS select coalesce(t1.ID,t2.ID) as ID, t1.Evnop, t1.Syst, t1.Conyst, t1.Contr, t1.Metype, t1.Steno, t1.Epidem, coalesce(t1.Entrant,t2.Entrant) as Entrant, coalesce(t1.Adde,t2.Adde) as Adde, t2.Set1, t2.Set2, t2.Set3, t2.Set4, t2.Set5,t2.Set6,t2.Set7 from table1 t1 FULL JOIN table2 t2 on (t1.Adde = t2.Adde); quit; What is the probable sas code i have to run to avoid the cartesian product interaction happening in my case, when i use a Full Join? Thank you.

Mystik · ‎11-14-2018

That was a very helpful Webinar! However, in the Webinar, the demonstration was for "inner join with summarization". Even though i clearly understood the cartesian product interactions in the video, there was little said about it and its prevention in the case of FULL JOIN(which is mine situation). Is there a way to use the summary function in the FULL JOIN to prevent full blown cartesian product interaction? Is the cartesian product interaction bad or its just another way of having a complex table?

Mystik · ‎11-14-2018

Thank you. Wish we have more people of your kind to give us clear and succinct ideas on PROC SQL. After run time of 1:03:09.14 (just over an hour), Table_12 was created with over 324 Million+ rows (yes over 300million) and 17 columns. Please, what will be the appropriate INOBS= option on PROC SQL for my scenario for quicker tests?

Mystik · ‎11-14-2018

Thank you. However, PROC SQL running has been on for more than 20 minutes now. Table1 have over 58million observations and Table2 have over 16million observation. Dunno if this is the cause.

Mystik · ‎11-14-2018

Thank you. Made the necessary changes. However, what is the difference between your t1 and Table1 or t2 or Table2? This is because i have two files/tables (Table1 and Table2) which i want to Full Join.

Online Status	Offline
Date Last Visited	‎03-20-2020 06:58 PM

Re: nested case-control sampling macro analysis matching

Re: nested case-control sampling macro analysis matching

Re: nested case-control sampling macro analysis matching

nested case-control sampling macro analysis matching

Re: How do i run a univariate analysis for this?

Re: How do i run a univariate analysis for this?

Re: How do i run a univariate analysis for this?

How do i run a univariate analysis for this?

Re: Delete subjects that have duplicates; not the duplicates

Re: Delete subjects that have duplicates; not the duplicates

Re: nested case-control sampling macro analysis matching

Re: Full Join using proc sql

Re: Full Join using proc sql

Re: nested case-control sampling macro analysis matching

Re: Full Join using proc sql

Re: How do i code a group of codes as Pheno and combination of 2 or mo...

Re: How do i code a group of codes as Pheno and combination of 2 or mo...

How do i code a group of codes as Pheno and combination of 2 or more c...

Re: How do I name a code and combinations of codes in a particular var...

Re: How do I name a code and combinations of codes in a particular var...

Re: How do I name a code and combinations of codes in a particular var...

Re: How do I name a code and combinations of codes in a particular var...

How do I name a code and combinations of codes in a particular variabl...

Re: How do i create a new file to be stored in my created Library SAS ...

How do i create a new file to be stored in my created Library SAS fold...

Re: SAS SQL: An Introduction

Re: Full Join using proc sql

Re: Full Join using proc sql

Re: Full Join using proc sql

Re: Full Join using proc sql