About PaulaC

PaulaC · ‎01-19-2017

Thank you for the explanation. I don't recall seeing anything in the log, but I will check again. Doesn't the input command change the variable from character to numeric?

PaulaC · ‎01-18-2017

I have a question for you regarding the length of 7 putting the character "01" since only the month and year were provided. I ended up with a diagnosis date of 2019 and a duration of -22, but not sure why. When I made it the character "01" a numeric 01, the value became missing. Do you have any explanations for this?

PaulaC · ‎01-17-2017

Thank you

PaulaC · ‎01-17-2017

I just tried and I got an error message with the "then". Please find the message from the log below: 123 data diagfix1; 124 set disease; 125 len = length(strip(date02)); 126 select (len); 127 when (4) then diagdate = mdy(01,01,input(date02,4.)); ---- 180 128 when (7) then diagdate = input('01'||date02, date9.); ---- 180 129 when (9) then diagdate = input(date02,date9.); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 130 otherwise put 'Check obs ' _N_ date02=; 131 end; 132 diagtime=intck('year',diagdate,daterand); 133 run; NOTE: The SAS System stopped processing this step because of errors. Thanks.

PaulaC · ‎01-17-2017

Thank you. I am trying this now. Would you mind explaining what this code is doing so that I will know for the future? Will I be getting three separate datasets?

PaulaC · ‎01-17-2017

The variable diagdate is a character variable (as mentioned in the original post). Some examples of the data are as follows: 1963 1964 1970 1972 198 1980 1981 APR1993 DEC1991 FEB1995 JUL1980 MAR1993 MAY1995 NOV1973 NOV1994 OCT1979 01APR1993 01APR1997 01AUG1991 Thanks.

PaulaC · ‎01-17-2017

I have a dataset that has a diagnosis date variable. This variable is a character variable. I would like to use this variable to cacluate the duration since diagnosis (randomization date-diagnosis date). Unfortunately the variable is stored in three different way for the subjects. I have about 40 subjects with only a year, 50 subjects with just a month and year and the remainder have a month, day and year. I want to split the dataset by the way the diagnosis date is reported and then impute the date where the missing information is present. After the imputation, I am planning on merging all the data back together. The data is currently as yyyy(40 subjects), mmmyyyy (50 subjects) and ddmmmyyyy(remainder) I am expecting to have three datasets after the split. I have used the following code in SAS 9.4 and it did not work (error message also included): 113 data diagfix1; 114 set disease; 115 if diagdate=diagdate year4.; ------ 388 201 76 ERROR 388-185: Expecting an arithmetic operator. ERROR 201-322: The option is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 116 run; Any help on how to split this data based on the date format would be appreciated. Thanks.

PaulaC · ‎01-10-2017

My apologies again. It did run, but I added I few more variables to make it closer to my actual dataset and now I can't seem to get it to run properly. I fixed the number of variables from what I can tell. Sorry about that. I am not very experienced at creating mock data and complicated mock data at that.

PaulaC · ‎01-09-2017

Please find the code below to generate the data data mock; infile datalines dsd; input trialid $ centre pt visit examdt mmddyy. body $ exam $ diag $ sex $ race $ consent $ consentdt mmddyy. wt randomdt mmddyy. performstat trt $ stopreas $ trtgive $ age trtdt mmddyy. ctrpt $ trialctrpt $ ; datalines; abc,1,1,2/3/1990,head,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,eye,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,ear,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,nose,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,throat,abnormal,lump,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,neck,abnormal,enlarged,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,lymphnode,abnormal,large,,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,breast,abnormal,warm,,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,heart,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,abdomen,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,lung/thorax,abnormal,dyspnea,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,genitourinary,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,extremities,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,musculoskeletal,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,skin,abnormal,discolored,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,1,1,2/3/1990,neurologic,normal, ,F,W,Yes,2/1/1990,115,2/1/1990,1,x,PD,x,25,2/3/1990,1/1,abc/1/1 abc,2,1,2/3/1990,head,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,eye,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,ear,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,nose,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,throat,abnormal,lump,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,neck,abnormal,enlarged,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,lymphnode,abnormal,large,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,breast,abnormal,warm,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,heart,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,abdomen,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,lung/thorax,abnormal,dyspnea,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,genitourinary,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,extremities,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,musculoskeletal,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,skin,abnormal,discolored,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,2,1,2/3/1990,neurologic,normal, ,F,B,Yes,2/3/1990,110,2/3/1990,1,x,PD,x,30,2/3/1990,2/1,abc/2/1 abc,3,1,2/3/1990,head,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,eye,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,ear,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,nose,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,throat,abnormal,lump,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,neck,abnormal,enlarged,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,lymphnode,abnormal,large,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,breast,abnormal,warm,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,heart,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,abdomen,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,lung/thorax,abnormal,dyspnea,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,genitourinary,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,extremities,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,musculoskeletal,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,skin,abnormal,discolored, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,3,1,2/3/1990,neurologic,normal, ,M,W,Yes,2/3/1990,140,2/3/1990,1,x,death,x,30,2/3/1990,3/1,abc/3/1 abc,4,1,2/3/1990,head,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,eye,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,ear,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,nose,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,throat,abnormal,lump,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,neck,abnormal,enlarged,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,lymphnode,abnormal,large,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,breast,abnormal,warm,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,heart,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,abdomen,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,lung/thorax,abnormal,dyspnea,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,genitourinary,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,extremities,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,musculoskeletal,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,skin,abnormal,discolored,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 abc,4,1,2/3/1990,neurologic,normal, ,M,B,Yes,2/3/1990,165,2/3/1990,1,x,death,x,45,2/3/1990,4/1,abc/4/1 ; run; Thanks for your help.

PaulaC · ‎01-09-2017

There would not be a body_head. It would be exam_head and diag_head. The entries under body are head, eye, ear, nose, throat, etc. I will include my code in a separate reply

PaulaC · ‎01-06-2017

Sorry about that. An example of the dataset is: TrialID Center Patient Visit ExamDt Body Exam Diag Sex Race Consent ConsentDt Wt abc 1 1 1 2/3/1990 head normal F W Yes 2/1/1990 115 abc 1 1 1 2/3/1990 neck normal F W Yes 2/1/1990 115 abc 1 1 1 2/3/1990 heart abnormal htn F W Yes 2/1/1990 115 abc 2 1 1 2/3/1990 heart abnormal htn F B Yes 2/3/1990 110 RandomDt PerformStat Trt StopReas TrtGive Age TrtDt CtrPt TrialCtrPt 2/1/1990 1 x PD x 25 2/3/1990 1/1 abc/1/1 2/1/1990 1 x PD x 25 2/3/1990 1/1 abc/1/1 2/1/1990 1 x PD x 25 2/3/1990 1/1 abc/1/1 2/3/1990 1 x PD x 30 2/3/1990 2/1 abc/2/1 I would like the data to be the same for all the variables except body, exam and diag which I would think would be column headings of exam_head, exam_neck, etc and the same for diag (diag_head, diag_neck, etc.). Hopefully that helps clarify what I am looking for. Thank you for your help.

PaulaC · ‎01-06-2017

It is currently in the long format, but I only want to convert three of the variables to the wide format. I do not want to convert all the variables to the wide format since I need the long format for analysis. Thanks.

PaulaC · ‎01-05-2017

Hi All, I have a dataset with 24 variables, but I would only like to transpose 3 of them while keeping the others in the same orientation. The dataset describes a physical exam by body part and whether the exam is normal/abnormal and if abnormal the diagnosis is indicated. The datasets looks as follows: TrialID Center Patient Visit ExamDt Body Exam Diag Sex Race Consent ConsentDt Wt RandomDt PerformStat Trt StopReas TrtGive Age TrtDt CtrPt TrialCtrPt Body has the following categories: head, eye, ear, nose, throat, neck, lymph node, breast, heart, abdomen, lung/thorax, genitourinary, extremities, musculoskeletal, skin, neurologic, additional Each patient has an enty for each body part so there are numerous rows with the same patient. Is there a way to only transpose body, exam and diag while keeping the other variables in the same orientation? I have tried, but it seems that only the variable in the code below and the other variables will be dropped in the transposed dataset. proc transpose data=medhistory out=transmedhist(drop=_:) prefix=exam_; var exam; by TrialCtrPt; id body; run;

PaulaC · ‎12-09-2016

Thank you for your suggestion. I will try that.

PaulaC · ‎12-02-2016

Yes, visit is a character variable. I strip(visit)="001.00" and I got a result but it did not seem to subset the data to give the counts with only one observation per patient. The number I got was much more than it should be. Thanks.

Online Status	Offline
Date Last Visited	‎10-02-2018 01:48 PM

Re: Export results from proc freq 2 by 2 table to excel

Re: Export results from proc freq 2 by 2 table to excel

Re: Export results from proc freq 2 by 2 table to excel

Export results from proc freq 2 by 2 table to excel

Re: Input not working to convert character to numeric values

Re: Input not working to convert character to numeric values

Input not working to convert character to numeric values

Re: multiple if then else statements using a do loop

Re: multiple if then else statements using a do loop

Re: multiple if then else statements using a do loop

Re: Splitting data based on date format type

Re: Can I Transpose only 1 variable out of Many in a dataset

Re: How do I recode a race variable keeping the same variable name?

Re: Splitting data based on date format type

Re: Splitting data based on date format type

Re: Splitting data based on date format type

Re: Splitting data based on date format type

Re: Splitting data based on date format type

Re: Splitting data based on date format type

Splitting data based on date format type

Re: Can I Transpose only 1 variable out of Many in a dataset

Re: Can I Transpose only 1 variable out of Many in a dataset

Re: Can I Transpose only 1 variable out of Many in a dataset

Re: Can I Transpose only 1 variable out of Many in a dataset

Re: Can I Transpose only 1 variable out of Many in a dataset

Can I Transpose only 1 variable out of Many in a dataset

Re: Counting the number of patients and frequencies for other categori...

Re: Counting the number of patients and frequencies for other categori...