Thank you, Robert for providing the solution to the problem. ... View more

You could use ods exclude where=(_NAME_= 'ProductLimitEstimates'); before proc statement. ... View more

Hi, You might have a connection error or user log in error. Can you send the log from your analytic server folder to SAS Support for more help? Regards, Murphy ... View more

Data data1; input age $ var1; cards;    <20          755    20-24     115401    25-29     445878    30-34     830072    35-39    1033127    40-44    1317303    45-49    1541838    50-54    2083025    55-59    1343919    60+        81271 ; Data data2; input age $ var2; cards;    <20         5577    20-24     173245    25-29     522938    30-34     875553    35-39    1091014    40-44    1377601    45-49    1566436    50-54    2177721    55-59    1084776    60+       247865    ;    run;    proc sql;    create table data3 as           select data1.age,var1,var2                       from data1,data2                       where strip(data1.age)=strip(data2.age); quit; proc print;run; ... View more

Park, The fact that the data were not created on the mainframe may be key.  If the step to upload the data to the mainframe is flawed, then it doesn't matter what you have done on download.  If the data started out as text (say on a unix box of some sort), then the user can upload it as text (rather than binary) and you can FTP it down as text.  The FTP service will do the conversion from one coding schema to another. Doc Muhlbaier Duke ... View more

Or use merge skill mentioned by Peter.C data temp; input  id  : $10.   var1                   yr ; cards; 000000001                 1                 1997 000000001                 2                 1998 000000001                 3                 1999 000000001                 4                 2002 000000002                 5                 2007 000000003                 6                 2001 000000003                 7                 2003 ; run; data want(drop=_yr i _id); merge temp temp(keep=yr id rename=(yr=_yr id=_id) firstobs=2); output; if _yr-yr gt 1 and id=_id then do;                      do i=yr+1 to _yr-1;                      yr=i; output;                      end;                      end; run;                        Ksharp ... View more