cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
zimcom
‎02-29-2024
  • 196 Posts
  • 58 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: Subset data with number of records count

by Pyrite | Level 9 in SAS Programming
‎07-03-2020 10:56 AM
‎07-03-2020 10:56 AM
Another related question, in the dataset, now each subject has at least 4 records (up to the maximum of 6). I want to do another subset of only those subjects where the difference between the 2nd to 3rd, 3rd to 4th, 4th to 5th, etc., jumped great than 4 points from the previous one.    Thanks again! ... View more

Re: Subset data with number of records count

by Pyrite | Level 9 in SAS Programming
‎07-03-2020 10:35 AM
‎07-03-2020 10:35 AM
Thank you so much, really appreciated! ... View more

Subset data with number of records count

by Pyrite | Level 9 in SAS Programming
‎07-03-2020 10:20 AM
‎07-03-2020 10:20 AM
    data want; set have; retain z; if first.SUBJECT then z = 1; else z = z + 1; by SUBJECT; run;   After I run the above code, how can I remove the SUBJECT if last.SUBJECT is less than 3 (not the observation of "z LT 3", but the SUBJECT), which means if the SUBJECT has less than 4 records, then they will be deleted.   Thanks as always ... View more

Re: Bi-section report

by Pyrite | Level 9 in ODS and Base Reporting
‎07-03-2020 10:11 AM
‎07-03-2020 10:11 AM
Thanks for your reply @Reeza  Probably I wasn't clear, I have the program to generate the png graph by patient though ODS RTF, so the top part of Word document is the graph I need, I just want to know how to insert the listing of Adverse Events of the same patient in the bottom part of the page.   Dose anyone else have any idea? Your help would be greatly appreciated!!  ... View more

Bi-section report

by Pyrite | Level 9 in ODS and Base Reporting
‎07-02-2020 02:11 PM
‎07-02-2020 02:11 PM
Hi all,   I want to create a bi-section report on one page with the top section being a line graph (like patient weight over the time) and bottom section being the patient Adverse Event listing so that it is easier to review if there is any relationship between weight loss or gain with the Adverse Event experienced.   Could someone point out the direction for me?   Thanks  ... View more

Re: Char to Numeric datetime conversion

by Pyrite | Level 9 in SAS Programming
‎04-13-2020 09:46 AM
‎04-13-2020 09:46 AM
I really appreciated your help, Thank you so much! Have a great day ... View more

Re: Char to Numeric datetime conversion

by Pyrite | Level 9 in SAS Programming
‎04-13-2020 09:29 AM
‎04-13-2020 09:29 AM
num_date_time=input(char_date_time,datetime.); I tried to convert using input as above, but it did not work (probably because there is a "T" in the character string to separate the date and time). ... View more

Char to Numeric datetime conversion

by Pyrite | Level 9 in SAS Programming
‎04-13-2020 09:05 AM
‎04-13-2020 09:05 AM
  I have the date and time in Char as below   Date and time 2017-03-01T12:10 2017-03-01T13:02 2017-03-07T22:15 2017-03-19T09:32 2017-04-12T11:45   I want to converted to date and time into Numeric What is the best way to handle this coversion?   THANKS!! ... View more

Re: SAS Date add 1 year

by Pyrite | Level 9 in SAS Programming
‎03-12-2020 03:48 PM
‎03-12-2020 03:48 PM
@novinosrin You are great help to me, thank you so much! ... View more

SAS Date add 1 year

by Pyrite | Level 9 in SAS Programming
‎03-12-2020 03:42 PM
‎03-12-2020 03:42 PM
Greetings!   What I have is a SAS data variable (e.g., 2015-03-07) What I want is to add one year to the above variable (e.g., 2016-03-07)   When I used    DSDAT = intnx('year',DSDAT,1);   I got "2016-01-01", any idea why I did not get "2016-03-07"   Thanks     ... View more

Re: Data manipulation

by Pyrite | Level 9 in SAS Programming
‎03-05-2020 03:38 PM
‎03-05-2020 03:38 PM
thank you @novinosrin, !!! ... View more

Data manipulation

by Pyrite | Level 9 in SAS Programming
‎03-05-2020 03:19 PM
‎03-05-2020 03:19 PM
    Greeting!!   what I have shipping date site Subject ID SiteIntialDate 2017-03-01 1 1001 01-Mar-17 2017-03-01 1 1002 . 2017-03-07 1 1003 . 2018-11-14 1 1062 . 2018-11-19 1 1063 . 2018-12-02 1 1064 . 2018-01-09 2 2001 09-Jan-18 2018-02-02 2 2002 . 2018-03-05 2 2003 . 2018-12-19 2 2030 . 2019-01-03 2 2031 . 2017-07-07 3 3001 07-Jul-17 2017-11-29 3 3002 . 2017-12-12 3 3003 . 2017-09-28 4 4001 28-Sep-17 2017-12-14 4 4002 . 2017-12-20 4 4003 . 2018-02-01 4 4004 . 2018-02-05 4 4005 . 2018-03-28 4 4006 . 2018-05-14 4 4007 .   what I want  Shipping date site Subject ID SiteIntialDate 2017-03-01 1 1001 01-Mar-17 2017-03-01 1 1002 01-Mar-17 2017-03-07 1 1003 01-Mar-17 2018-11-14 1 1062 01-Mar-17 2018-11-19 1 1063 01-Mar-17 2018-12-02 1 1064 01-Mar-17 2018-01-09 2 2001 09-Jan-18 2018-02-02 2 2002 09-Jan-18 2018-03-05 2 2003 09-Jan-18 2018-12-19 2 2030 09-Jan-18 2019-01-03 2 2031 09-Jan-18 2017-07-07 3 3001 07-Jul-17 2017-11-29 3 3002 07-Jul-17 2017-12-12 3 3003 07-Jul-17 2017-09-28 4 4001 28-Sep-17 2017-12-14 4 4002 28-Sep-17 2017-12-20 4 4003 28-Sep-17 2018-02-01 4 4004 28-Sep-17 2018-02-05 4 4005 28-Sep-17 2018-03-28 4 4006 28-Sep-17 2018-05-14 4 4007 28-Sep-17   Thanks ... View more

Re: Macro question

by Pyrite | Level 9 in SAS Programming
‎03-05-2020 10:20 AM
‎03-05-2020 10:20 AM
  %sumcat5(datin=adqs3, clsvar=trt01pn, byvars=avisitn, anvar=aval);   "Yes, that summarizes the data and puts it in a format for the .rtf file. It is not required for the proc logistic analysis. You can get the summary statistics by replacing it with a proc freq."   @ballardw @Tom @novinosrin  I got reply and not quite sure how to replace the above marco with a proc freq, would you be able to provide any insight on this?     ... View more

Re: Macro question

by Pyrite | Level 9 in SAS Programming
‎03-04-2020 06:48 PM
‎03-04-2020 06:48 PM
Thanks for the insight, after today’s discussion I kind of have an idea of Marco code now. I have requested from the original programmer for the marco code. I am solo SAS user in the entire company and I learned a lot of things from here, I just want to say that I appreciated your help so much !!! ... View more

Re: Macro question

by Pyrite | Level 9 in SAS Programming
‎03-04-2020 03:03 PM
‎03-04-2020 03:03 PM
@Tom @novinosrin @ballardw  This is very helpful and I will reach out to the original programmer and find out if he can send me the Marco setup file. Thank you all again, your continuous help and support make my SAS learning possible.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-29-2024 06:55 AM
Likes given to
Likes from
View All
Quick links