Hi,  Please could you assist me regarding the fictious program below (there is only one variable to transpose). It's not work. I would to have one row by id (patient) without use proc TRANSPOSE. Because, I would like transpose more than 3 variables by patient.   data A; length id 8. ; input id Date_exam; format Date_exam ddmmyy10.; informat Date_exam ddmmyy10.; datalines; 0001 01/10/2020 0002 11/10/2001 0003 16/09/2010 0004 30/01/1960 0001 02/10/2020 0002 15/10/2001 0002 15/10/2002 0003 16/09/2010 0004 30/01/1960 0003 16/09/2004 0003 16/09/2018 0005 06/09/2017 ; run ; proc sort data=A;by id Date_exam; run ; %let i=1; data B; set A; by id; retain id Date&i; array date[1:4]; do i=1 to 4; Date&i=Date_exam; output; end; run ;   I don't have one row by patient for the variable Date_exam. Please, not use Proc TRANSPOSE. I know this row, it's ok for me but not efficience when you have more yhan 3 variables. Thank you so much in advance. Corinne  ... View more

Hi,  1) Could somebody tell me how to check quickly the LOG? Please an other  way as: CTLF+F=error or warning.... 2) Do the statement PUTLOG deals with it? Please, If yes, could you tell me how it runs.   Thanks in advance for all answers.   Regards, Corinne ... View more

Hi,  Please, somebody could help me? I don't undersand the LOG. I have no result, because zero rows! Thanks in advance. Corinne. Subject: I would like to join 4 tables, see below:  sq.statepopulation                  sq.regioncode           sq.divisioncode                    sq.statecode Region (the region code)        RegionCode            DivisionCode                      StateCode Division (the division code)    RegionName           DivisionName                      StateName Name (the state code)    Births3 (an indicator of state-lvel, three-year projected births)      My code is:  proc sql feedback; /*create table toto as*/ select s.Births3 format=ddmmyy10. ,r.RegionName ,d.DivisionName ,t.StateCode from sq.statepopulation as s inner join sq.regioncode as r on s.Region=r.RegionCode inner join sq.divisioncode as d on s.Division=d.DivisionCode inner join sq.statecode as t /*** <--------ISSUE THERE!*/ on s.Name=t.StateName; quit;   My Log says: OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 proc sql feedback; 70 /*create table toto as*/ 71 select s.Births3 format=ddmmyy10. 72 ,r.RegionName 73 ,d.DivisionName 74 ,t.StateCode 75 from sq.statepopulation as s inner join 76 sq.regioncode as r 77 on s.Region=r.RegionCode inner join 78 sq.divisioncode as d 79 on s.Division=d.DivisionCode inner join 80 sq.statecode as t 81 on s.Name=t.StateName; NOTE: Statement transforms to:   select S.Births3 format=DDMMYY10.0, R.RegionName, D.DivisionName, T.StateCode from SQ.STATEPOPULATION S inner join SQ.REGIONCODE R on S.Region = R.RegionCode inner join SQ.DIVISIONCODE D on S.Division = D.DivisionCode inner join SQ.STATECODE T on S.Name = T.StateName;   NOTE: No rows were selected. 82 quit; NOTE: PROCEDURE SQL a utilisé (Durée totale du traitement) : real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 6436.18k OS Memory 31156.00k Timestamp 08/10/2021 01:48:53 PM Step Count 89 Switch Count 0 Page Faults 0 Page Reclaims 342 Page Swaps 0 Voluntary Context Switches 18 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 ... View more