ksharp is probably right, but I think this might work as well (I am not quite sure why you're changing the variable type though): Proc SQL;   Create Table file_combines As   Select A.*,          B.Company_Price   From     (Select Date Format=DDMMYY10., Put(Company_number,6.) As C_Nr Format=$6. Length=6 From File1) As A Left Join (Select Date Format=DDMMYY10., Put(Company_number,6.) As C_Nr Format=$6. Length=6, Company_price From File2) As B   On A.Date eq B.Date AND   A.C_Nr eq B.C_Nr   Order By C_Nr, Date; Quit; ... View more

I think this requires a multi-step approach. One answer to 1) could be: Data A;   Input ID Trns_QTR:YYQ. Val_A Val_B;   format Trns_Qtr YYQs6.;   Datalines; 100 2010Q1 1456 345 100 2010Q2 2500 0 100 2010Q3 2500 0 100 2010Q4 2500 0 200 2010Q4 0 1200 200 2011Q1 3100 0 200 2011Q2 3200 0 200 2011Q3 3100 0 200 2011Q4 3300 0 200 2012Q1 2500 12876 300 2019Q4 2390 0 300 2010Q1 4300 0 300 2010Q2 2300 678 300 2010Q3 5600 0 300 2010Q4 5600 0 300 2011Q1 2500 0 300 2011Q2 3200 0 300 2011Q3 3100 0 300 2011Q4 3300 12876 300 2012Q1 3200 0 300 2012Q1 3100 0 300 2012Q2 3300 0 ; Run; * create new ID; Data B ;   Length ID_dummy $100.;   Set A;   Retain dummy;   By ID;   If First.ID Then dummy=IfN(Val_B eq 0,1,0);   Else Do;     If Val_B eq 0 & dummy eq 0 Then dummy=1;     Else If Val_B gt 0 Then dummy+1;   End;   If Val_B ne 0 Then Nr=0; Else Nr=dummy;   If Nr ne 0;   ID_dummy=Catt(Put(ID,Z3.),'_',Put(Nr,Z2.));   One=1; Run; * get length; Data C (Keep=ID Trns_Qtr Total ID_dummy);   Do i=1 By 1 Until (Last.ID_dummy);     Set B; By ID_dummy; Total=Sum(One,Total);   End;   Do Until (Last.ID_dummy);     Set B; By ID_dummy; Output;   End; Run; * save first and last; Data D;   Length Col $10.;   Set C;   By ID_dummy;   If First.ID_dummy Then Do;     Col="Start"; Output;   End;   Else If Last.ID_dummy Then Do;     Col="End"; Output;   End; Run; * transpose; Proc Transpose Data=D Out=E (Drop=ID_dummy _NAME_);   By ID_dummy ID Total;   Var Trns_Qtr;   ID Col; Run; ... View more

Yes, that's exactly what a meant. I didn't think to put a where-statement after the dataset. Many thanks! ... View more

I would suggest you try the equivalent to Excel's "isblank" instead of "iserror". Could look like: Data A;   Input Birthdate:Date9.; Format Birthdate Date9.;   Datalines;   01JAN2000   09SEP2006   .   ; Run; Proc SQL;   Create Table B As   Select *,          Case When Missing (Birthdate) Then 22 Else                    YrDif(Birthdate,Today(),'Actual') End As Age   From A; Quit; ... View more

Maybe brute force 🙂 Data dummy (Drop=i);   Do i=1 To 50;     Drop_me="SDIAL0"!!Put(i,Z2.)!!"POA"; Output;   End; Run; Proc SQL NoPrint;   Select Drop_me Into :Drop_me Separated by ' ' From dummy; Quit; %Put **&Drop_me.**; data want (drop=&Drop_me.); set xyz; run; ... View more

Depends on how your other columns are named, but a wildcard could help. Try for example: data want (drop=SDIA:); ... View more

.. if you need to combine your where-statement with and-statements you might prefer .. proc sql; create table FI_Locations as select * from maps.uscity where   (Case When city like '%Atlanta%' or              city like '%Cary%' or              city like '%Hartford%' Then 1              Else 0    End)=1; quit; ... View more