About Manol_Jovani

Manol_Jovani · ‎10-09-2021

Yes, the code above the macro works fine, there is no problem there. Is that what you are asking?

Manol_Jovani · ‎10-08-2021

I have used SAS for a few years and I consider myself a relatively good user, but have not done matching before, and I need it for a study. I found your paper, and it looks fantastic: https://www.frontiersin.org/articles/10.3389/fdata.2019.00004/full Mine is a simple clinical dataset. I am basically running it as created above, since the variables "age" and "gender" in my dataset are the same. However, I get an error when I run the code, and I don't understand why. Below I will give the code I use, and the error I get. THE CODE: data population; set edge; if lams_size=1 then casecontrol=1; else casecontrol=0; run; %LET agerange = 5; %LET ratio = 2; DATA cases controls; SET population; IF casecontrol = 1 THEN OUTPUT cases; ELSE OUTPUT controls; RUN; PROC FREQ NOPRINT DATA=cases; TABLES age*gender/OUT=caseout; RUN; %MACRO sample(v_age, v_gender, v_count); DATA qualify1; SET controls; WHERE (&v_age-&agerange <= age <= &v_age+&agerange) AND (gender = "&v_gender"); case_age = &v_age; case_gender = "&v_gender"; SEED = RANUNI(0); PROC SORT; BY SEED; DATA qualify2; SET qualify1 NOBS=totobs; IF _N_ <= &v_count*&ratio; IF &v_count*&ratio <= totobs THEN tag = 'yes'; ELSE tag = 'no'; PROC APPEND BASE=matches DATA=qualify2 force; /*new data set ‘matches’ will contain the matched controls*/ PROC SORT DATA=qualify2 OUT=temp1 (KEEP=uniqueid); BY uniqueid; PROC SORT DATA=controls OUT=temp2; BY uniqueid; DATA controls; MERGE temp1(IN=in1) temp2(IN=in2); BY uniqueid; IF in2 AND NOT in1; %MEND sample; DATA _NULL_; /*This data step calls the macro.*/ SET caseout; CALL EXECUTE ('%sample('||age||','||gender||','||count||')'); RUN; THE ERROR The error I get is the following (which then of course influences everything that follows): NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 254:30 254:40 254:53 NOTE: There were 29 observations read from the data set WORK.CASEOUT. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: CALL EXECUTE generated line. 1 + DATA qualify1; SET controls; WHERE (25-0 <= age <= 25+0) AND (gender = "0"); case_age = 25; case_gender = "0"; SEED = RANUNI(0); ERROR: WHERE clause operator requires compatible variables. "25" is simply the youngest age in my data set, which ranges from 25 to 76. I do not understand why it gives the error that "where" needs a compatible variable. Both "age" and "gender" are numeric in my dataset. I double checked to make sure. I am not sure if the "NOTE" above it has somehow converted one of them in a character, and hence the mistake? Any help to figure this out would be greatly appreciated. Thank you very much

Manol_Jovani · ‎11-14-2017

Hello Thank you so much for the answers. I truly appreciate a lot. For many reasons, I have not been able to work on this project until now. When a few weeks ago I was running the code on the "training" dataset, I wrote that it worked. In a way it did. However, even back then I had noticed a problem there that I bypassed, since in that "training" dataset it was still giving the desired results. The problem was that "all5" was not being created, but instead "all4" was being copied, and from it some of the observations were eliminated, as desired. Apparently while in the "training" dataset this did not in the end create real problem since the desired results were achieved, in the real dataset this problem blocks the program from running. In order to explain in detail this point I am including an attachment, with all the steps described in detail, including the results. Please see attached document (seems long, but it is really not, it is so just because I included also the results as Tables). Thank you so very much

Manol_Jovani · ‎11-13-2017

Hello Thank you very much for your suggestion. I would like to kindly ask another related question. The dataset I sent above was simply a "training" dataset, just to make sure that I was doing all the necessary and correct exclusions. So, when i wrote that it worked in my comment, I meant that it worked perfectly well in the "training" dataset. The "training" dataset mimics the real dataset, in which each participant (determined by "newid") can have different lines for each cancer that they have (differerent observations; if they have more than one cancer). However, when I tried to apply the code to the real dataset, SAS gets "blocked" (every time it goes in the state of "SAS non responding") Let me explain: The real dataset contains about 5000 observations. I do a first code of exclusion to eliminate all non-melanoma prevalent cancers, with the following code: proc sql; create table all4 as select * from all3 where newid not in (select distinct newid from all3 where incidence eq 0 and nomel eq 0) ; quit; This code runs perfectly well in less than one minute. If there is an individual (defined by "newid") that has a prevalent cancer, then this codes eliminates all lines that are associated with that "newid" (it eliminates all the observations from that person). In this case "nomel" is non-melanoma skin cancer. Now I try to apply the code that was suggested here to the new dataset created in this case, namely "all4". I try to eliminate here all the "nomel" only in those that have multiple observations, but keep it in those that do not have multiple observations. I run the following: proc sql; create table all5 as select newid from all4 group by newid having count(*) > 1; delete from all4 where newid in (select newid from all5) and NOMEL=1; select * from all4; quit; however, when I run this, SAS gets "blocked". It just does not run ("SAS non responding"). I tried this different times in many different days, but the same problem persists. At first I assumed that it was a complex operation that just needed time, but I left it running for an hour, and nothing changed. In the "training" dataset that I brought it, it worked perfectly fine and quickly. I do not know why when i try to run it in the real dataset, it creates this problem, since it is not very different from the other "proc sql" code above. Can you please help me? Thank you very much

Manol_Jovani · ‎10-18-2017

Thank you so much, it worked Best

Manol_Jovani · ‎10-18-2017

Hello I am using SAS, version 9.4 I have the following dataset: data have; input id IDTYPE CANC TOPO TIME NOMEL INCIDENCE; datalines; 001 1 1 173 2 1 0 002 1 1 173 3 1 1 003 1 1 173 4 1 0 003 1 1 145 6 0 1 004 3 1 173 1 1 0 004 3 1 184 2 0 1 004 3 1 185 6 0 1 004 3 1 173 9 1 1 005 1 1 122 3 0 1 006 0 . . . . . ; run; As you can observe, patient 1 (ID=001) and 2 (ID=002) have only one observation. Same for patients 5 and 6, whereas patients 3 and 4 have more than one observation. I would like to eliminate the row with nomel=1 in patients 3 and 4, but not eliminate patients 1 and 2 even though they have also nomel=1. Thus, for patient 3 I would like to eliminate the first row, whereas for patient 4 I would like to eliminate a first and fourth row. I was thinking that the best way to do that would be to create a variable that is the same for all rows with the same ID. For example, if I create the variable “nomel_del” that would be “1” if nomel=1 and there is more than one observation on the same patient, or “0” otherwise (if there is nomel=1 but there are no other observations on the same patient, as in patients 1 and 2, or if nomel =0 or nomel=.). Then I could easily eliminate all rows with nomel=1 and nomel_del=1. The end result should be following: Obs id IDTYPE CANC TOPO TIME NOMEL INCIDENCE 1 1 1 1 173 2 1 0 2 2 1 1 173 3 1 1 3 3 1 1 145 6 0 1 4 4 3 1 184 2 0 1 5 4 3 1 185 6 0 1 6 5 1 1 122 3 0 1 7 6 0 . . . . . I am trying to figure out how to do this, but I am not being able to. Would be very grateful if someone can help me. Thank you very much

Online Status	Offline
Date Last Visited	‎10-09-2021 12:13 AM

Re: MATCHING WITH SAS

MATCHING WITH SAS

Re: Create a variable that connects different observations (rows) on t...

Re: Create a variable that connects different observations (rows) on t...

Re: Create a variable that connects different observations (rows) on t...

Create a variable that connects different observations (rows) on the s...

Create a variable that connects different observations (rows) on the s...

Re: MATCHING WITH SAS

MATCHING WITH SAS

Re: Create a variable that connects different observations (rows) on t...

Re: Create a variable that connects different observations (rows) on t...

Re: Create a variable that connects different observations (rows) on t...

Create a variable that connects different observations (rows) on the s...