About wajmsu

wajmsu · ‎05-12-2016

Hi, I have a matched data set (shown below). I want to carry out the following analysis: 1. Descriptive table 2. conditional logistic regression unadjusted (outcome is fev) 3. conditional logistic regression adjusted (outcome is fev) 4. conditional logistic regression with interaction terms (opwo*race) (outcome is fev). Please guide me. Thanks Group Type Control Id id age edu race parity wt ht opwo fev 1 Case . 5 32 9 1 0 90 5.2 1 1 1 Control 1 70 32 9 1 0 90 5.2 1 0 1 Control 2 99 35 10 1 0 90 5.2 0 0 2 Case . 12 35 12 1 2 110 5 0 1 2 Control 1 43 35 12 1 1 110 5 0 0 2 Control 2 101 33 11 1 2 110 5 0 0 3 Case . 22 25 14 3 0 110 5.4 0 1 3 Control 1 125 25 13 3 0 110 5.4 0 0 3 Control 2 51 28 12 3 0 110 5.4 0 0 4 Case . 29 27 12 2 1 95 5 1 1 4 Control 1 32 29 12 2 2 125 6.2 1 0 4 Control 2 31 27 10 2 1 95 5.5 0 0 5 Case . 40 28 10 3 2 130 6 1 1 5 Control 1 58 28 10 3 2 130 6 0 0 5 Control 2 93 27 11 3 2 130 6 1 0

wajmsu · ‎05-12-2016

Thanks PG; it did work.

wajmsu · ‎05-11-2016

Hi PG, For my matching strategy, the final step is creating problem. Please see the log below and guide me how to fix it. proc sql; 217 create table pe.allMatches as 218 select a.group, a.type, a.ctrlId, b.* 219 from pe.stackedMatches as a inner join pe.sample as b on a.id=b.id 220 union all corresponding 221 select a.group, a.type, a.ctrlId, b.* 222 from pe.stackedMatches as a inner join pe.control as b on a.id=b.id 223 order by group, type, ctrlId; NOTE: Data file PE.SAMPLE.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file PE.CONTROL.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. 224 quit

wajmsu · ‎05-11-2016

Thanks. Going back to the creation of data Links, the controlNode becomes character and sampleNode becomes numeric variables. So, it does not work for the 'proc optnet' statement due to different in the type. How can I bring the controlNode (which is 4 digit label) to sampleNode (lenght 8, infromats 10.2 and format 10). I added 'format controlNode 4.0.' the log statement showed 'converted from character to numeric but in actuality it did not. Here is the orginal code, (without format for controlNode, which does not work): --- data pe.links; set pe.matches; where not missing(controlId); controlNode = controlId; do i = 1 to min(99, &controlsPerSample); sampleNode = sampleId + i/100; output; end; format sampleNode 10.2; keep sampleNode controlNode distance; run; /* Perform best linear assignment algorithm */ proc optnet data_links=pe.links graph_direction=directed; data_links_var from=sampleNode to=controlNode weight=distance; linear_assignment out=pe.bestMatches; run; --- Thanks

wajmsu · ‎05-11-2016

I have added format for conrolNode in the sas code as shown below. This format was not present in the sas code previosuly. However, it does not change the type in the data file but log says: 'converted from character to numeric'. WHen I run proc optnet statement, the message comes. Thanks for your time and support!

wajmsu · ‎05-11-2016

You are right; Controlnode is character fromat and informat=$4. Samplenode is numeric format=10.2 ans infromat=10. Controlnode is 4 digits and samplenode is 0000.00. I want to to convert to numeric, is it ok, please guide me? What should be the format and informat for controlnode (changing from character to numeric)? Thanks

wajmsu · ‎05-11-2016

Thanks.

wajmsu · ‎05-11-2016

Hi FreelanceReinhard, Thanks, it worked as far as not getting any log error. However, the very next issue comes about the 'from' and 'to' as shown below: OTE: ---------------------------------------------------------------------------------------------- ERROR: The FROM and TO variables in the DATA_LINKS= data set must have the same type. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set PE.BESTMATCHES may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set PE.BESTMATCHES was not replaced because this step was stopped. NOTE: PROCEDURE OPTNET used (Total process time): real time 0.23 seconds cpu time 0.21 seconds 36 37 proc sql; 38 select 39 floor(sampleNode) as sampleId, 40 controlNode as controlId 41 from pe.bestMatches; ERROR: Table PE.BESTMATCHES doesn't have any columns. PROC SQL requires each of its tables to have at least 1 column. ERROR: Function FLOOR requires a numeric expression as argument 1. ERROR: The following columns were not found in the contributing tables: controlNode, sampleNode. 42 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds

wajmsu · ‎05-11-2016

As I mentioend earlier, I've Links dataset in my permanent library. While using Proc optnet data_links=links, the program takes it, probably, as coming from Work library which is actually not. How can I use my libref which is "pe." here? Where should I write it? Thanks

wajmsu · ‎05-11-2016

Hi, I am using Proc Optnet for matching my cases with controls (both as independent datasets), please see below. I can do that in Work library; however, when I try to do that for my permamnet folder/Libref it does not work. The log says: Work.Links.Data not available. I have one file as pe.Links in my permanent library. How can I add libref with proc optnent? Thanks proc optnet data_links=links graph_direction=directed; data_links_var from=sampleNode to=controlNode weight=distance; linear_assignment out=bestMatches; run; proc sql; select floor(sampleNode) as sampleId, controlNode as controlId from bestMatches; quit;

wajmsu · ‎05-11-2016

Dear PGStats: Referring to Proc Optnet, I am trying to use it for my original dataset with libref 9not work library) it does not work. Log says 'Work.Links.Data' not found. Please guide me. Thanks

wajmsu · ‎05-03-2016

Hi, I want to eliminate the decimal points from my sas datafile. Can I have the code for that specific variable? there are codes to bring the outcome without decimal points but I want to change it in the datafile. Thanks

wajmsu · ‎05-02-2016

Thanks SASKiwi! my varaible to be rounded off is 'gesta_age_wks'. how should i write the code? Best

wajmsu · ‎05-02-2016

Hi, I have sas data file with more than 5 decimal points. I want to remove decimal with rounding off the last digit. How can I do? Thanks

wajmsu · ‎03-11-2016

I ran the code and it gives todays date and also creats columns for all categories for age but it does not calculate the age and cells/data are blank or missing.

Online Status	Offline
Date Last Visited	‎08-07-2016 04:08 AM

error in the log

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: small sample conditional logistic

Re: Class statement reference

Re: Class statement

Re: Class statement

matched data analysis

Re: Matching cases with controls

Re: Matching cases with controls

Re: Matching cases with controls

Re: matching

Re: matching

Re: Matching cases with controls

Re: matching

Re: Matching cases with controls

matching

Re: Matching cases with controls

Code for rounded

Re: How to manage decimal points?

How to manage decimal points?

Re: date of birth and age