I have some data in the following format   data testdate;    input admit_date discharge_date;    date = input(chardate,yymmdd10.); return; datalines; 6/29/2019    8/26/2019 12/27/2018   4/3/2019   ;     I need to determine the number of patient days someone was admitted per month.  For example,for the first row there would be 1 day for June 2019, 31 for July 2019, and 26 for August 2019.  I have about 800 records and would love a way to automate this if possible.  Thanks in advance! ... View more

I have some HR data from our PeopleSoft System for which I am trying to create reports for employees of a certain job type.  I've provided an example of the data below.    Essentially, I need to create some reports for anyone that does NOT have the OFFICE_CD of "individual."  Furthermore, I need to create rolled-up reports at varying levels in our HR hierarchy.  For example, an individual reports to a supervisor, and the supervisor reports to a manager, and a manager reports to a director, and a director reports to a VP, and so on.  The data provides the employee's ID # (EMPLID) and their direct supervisor only.  I'm struggling with how to link data in way to provide reports such as a director-level's report roll-up, which needs to include all the managers, supervisors, and individuals that report underneath them.  The data is very linear, but I'm hitting a roadblock so any suggestions would be greatly appreciated!   Thanks!       COMPANY          EMPLID                                 NAME                                   OFFICER_CD                       SUPERVISOR_EMPLID A                             0931616061                         Ale,Ginger                          Individual                            0389203585101 B                             0415656062                         Daniels,Jack                        Individual                            0389203585101 C                             0201590112                         O'Hara,Scarlet                   Individual                            0389203585101 D                             0704929134                         Palmer,Arnold                   Individual                            0389203585101 A                             0307800788                         Peach,Georgia                  Individual                            0389203585101 A                             0912890678                         Sour,Brandy                       Individual                            0389203585101 B                             0036176062                         Walker,Johnny                  Individual                            0389203585101 B                             0389203585101                  Temple,Shirley                  Supervisor                          0131284859101 B                             0131284859101                   Rogers,Ginger                   Manager I                           0048586929101 A                             0048586929101                    Tia,Mai                                 Dir I                                      0569039562101 B                             0569039562101                     Von Teese,Dita                 VP I                                        0044980664101 C                             0044980664101                   Henkel,Margarita             Exec Ldr                               0453958372101 A                             0453958372                        Beam,James                      Exec Ldr                               0430450225801 A                             0430450225801                    Collins,Thomas                  CEO        ... View more

Hello,   I have data in the current format:   Company  Composite_1 Composite_2 (goes through 13)     A                   75%               60%     B                   72%               90%     C                   40%               42%   And I would like my data to be transformed intot his format:   Composite      Percent   Company    Comp1           75%           A   Comp2           60%           A   Comp 1          72%           B   Comp2            90%           B   Comp1           40%           C    Comp2           42%           C     I've tried the following array but only get the company column:     data comp_long; set comp_wide; length composite $ 10.; array v(*) _numeric_; do i = 1 to dim(v) by 13; composite = scan (vname(v{i}), 1, "-"); Comp1 = v{i}; comp2 = v{i+1}; comp3 = v{i+1+1}; comp4 = v{i+1+1+1}; comp5 = v{i+1+1+1+1}; comp6 =v{i+1+1+1+1+1}; comp7 = v{i+1+1+1+1+1+1}; comp8 = v{i+1+1+1+1+1+1+1}; comp9 = v{i+1+1+1+1+1+1+1+1}; comp10 = v{i+1+1+1+1+1+1+1+1+1}; comp11 = v{i+1+1+1+1+1+1+1+1+1+1}; comp12 = v{i+1+1+1+1+1+1+1+1+1+1+1}; comp13 = v{i+1+1+1+1+1+1+1+1+1+1+1+1}; output; end; keep company; run; I know I'm missing something, so any suggestions are grealty appreciated! Thank you!  ... View more

I have a large number of variables for which I'd like to apply the same If then criteria:   if A1 = 4 or A1 = 5 then A1_pos = 1; if A1 = 3 or A1 = 2 or A1 = 1 then A1_pos = 0; if A1 = . then A1_den = 0; else A1_den = 1; if A3 = 4 or A3 = 5 then A3_pos = 1; if A3 = 3 or A3 = 2 or A3 = 1 then A3_pos = 0; if A3 = . then A3_den = 0; else A3_den = 1;   Rather than write out a large number of if then statements, I'm thinking an array would could down on my code and be a more efficient way to do this.   Any suggestions are greatly appreciated!   Thank you ... View more