Hi, Try this...Hope it helps.. %let fname=&dataroot&psep.st_26.csv; %macro TABLES; filename st_spec "&fname";     %if %sysfunc(fexist(&fname)) %then     %do;                    data st_26;                infile st_spec dsd firstobs=2 truncover dlm=',';                input date:mmddyy10.;         run;     %end;     %else %do;         %put No schedule table exists;     %end; %mend; %tables; Thanks, Shiva ... View more

Hi , Try this...hope it helps... proc sql;     connect to oledb(dsn=CC_DB_live  uid=test pwd=test provider=sqloledb);            execute (SP_WT_REPORT ) by oledb; quit; Thanks, Shiva ... View more

Hi , Try this... DATA HAVE1; INPUT SERIES_ID $20.; CARDS; SMU01115000000000001 SMU01122200000000001 SMU01138200000000001 SMU01194600000000001 SMU01200200000000001 SMU01225200000000001 SMU01234600000000001 SMU01266200000000001 SMU01336600000000001 SMU01338600000000001 SMU01021000000000001 ; RUN; data fmt (keep=FMTNAME START END LABEL TYPE); length FMTNAME $30. START END $256.; set WORK.have1;       FMTNAME = 'test' ;       START   = substr(SERIES_ID,4,5) ;       END     = Start;       LABEL   = 'test';       TYPE    = 'C' ; run; proc format cntlin=fmt lib=work; run; DATA HAVE2(drop=x); INPUT Area_Code $5. Area_Title $25. ; x=put(Area_code,$test.); if x='test' then output; CARDS; 01000 Alabama -- Statewide 01001 Autauga County, Alabama 01003 Baldwin County, Alabama 01005 Barbour County, Alabama 01007 Bibb County, Alabama 01009 Blount County, Alabama 01011 Bullock County, Alabama 01013 Butler County, Alabama 01015 Calhoun County, Alabama 01017 Chambers County, Alabama 01019 Cherokee County, Alabama 01021 Chilton County, Alabama ; RUN; Thanks, Shiva ... View more

Hi, Try this...You need to rename the variables. data one; input produce $   weight        bags; cards; carrots     10              500 potatos     5               200 garlic        2               100 ; run; data two; input fruit  $   wt  containers; cards; apples     15              100 pears        9                20 ; run; proc append base=one data=two(rename=(fruit=produce wt=weight containers=bags)); run; data final; set one two(rename=(fruit=produce wt=weight containers=bags)); run; Thanks, Shiva ... View more

Hi Jen, Try this...Hope it helps.. data range; input customer_ID range; cards; 17092730413  170927208310 ; run; data fmt (keep=FMTNAME START END LABEL TYPE); length FMTNAME $30. START END $256.; set WORK.range;       FMTNAME = 'Range' ;       START   = Customer_ID ;       END     = Range;       LABEL   = 'Range';       TYPE    = 'N' ; run; proc format cntlin=fmt lib=work; run; data customer;length x $20.; input Customer_ID House_No Street_Name $ 25-39 City $ 40-55 State $ 56 -60; x=put(customer_ID,Range.); cards; 170927308313 123    Elks Grove    Chicago       IL 171540339727 456    Crab Lake    Baltimore   MD 170060423416 7890 Winery Lane    Frederick   MD 170869014929 2468 Lombardi Drive San Francisco  CA 111870069510 13579 PCH            San Diego   CA 165019812149 22226 Reunion Blvd Dallas       TX 172270371229 11597 Gulf Drive    Tampa       Fl ; run; proc print data=customer ; where x='Range'; run; Thanks, Shiva ... View more

Hi, data have; input startdate enddate; informat startdate enddate date9.; format startdate enddate date9.; cards; 01jan2012 15jan2012 01feb2012 05feb2012 ; run; data want; set one; x=intck('day',startdate,enddate); do i =1 to x; y=intnx('day',enddate,-i); output;format y date9.; end; drop x i; run; Thanks, Shiva ... View more

Hi , Try this.. data a; input no; cards; 1 2 3 ; run; data b; input no; cards; 3 4 5 ; run; data c; merge a(in=a) b(in=b); by no; if a ne b ; run; Thanks, Shiva ... View more

Hi Mike, You can try using SAS DI studio 4.21.File->import->Import SAS Code. Hope this helps. Thanks, shiva ... View more