I know how to access SQL server via SAS Access / Pass Through Connection to read SQL server database tables. I would like to know, is there a way to execute a SAS program via a SQL Server Management Studio script or store procedure?   I've written a SAS Logger / Adapter program which executes several SAS programs then reporting if the programs contained errors.    My Vice-President however would like SQL Server management Studio to execute the SAS Logger / Adapter program. I'm looking for SAS code examples or documentation.    Thanks,  ... View more

I hear this a lot from people and I've said it a few times myself and find myself saying it today, "I written SAS code like this a thousand times without issue".... Any way the below code issues the ERROR: Variable DATACOLLECTION_FINISHTIME not found   proc tabulate data=&CMTH&YR._MAS_IIS_MOB_SF_NEW missing; var DATACOLLECTION_FINISHTIME; table DATACOLLECTION_FINISHTIME, n nmiss (min max median)*f=mmddyy10. range; run; A second pair of eyes would help. Thanks....             ... View more

In the attached excel spreadsheet I've store a path to a checkbox image ie "^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}"; Basically Tabel3 will contain the above information. I expect the below on the PDF. This doesn't appear to be a syntax issue, but i could be mistaken. Any suggestions would be appreciated.   What I expect is: checkbox image Normal checkbox image Abnormal checkbox image Normal etc.   What I'm gettting is: "Normal"; "Abnormal_____"; etc.   The SAS CODE:   ods region x=5.0in y=1.5in;   proc report data = pg2tabl3 out=testfile nowindows nowd style(report)=[rules=none frame=void cellspacing=0 cellpadding=1pt just=l fontsize=3pt] style(header)=[background=white font_weight=bold just=l font_size=5pt]; column table3; define table3 / '* (Mandatory - Complete at least one system)' style(column)=[cellwidth=3.0in] ; rbreak after / summarize; compute table3; if table3 ^= ' ' then call define (_row_, 'Style', 'style= [font_size=9pt vjust=middle cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); if table3 ^= ' ' then call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]'); endcomp; Run;         ... View more

Given the below code I would like to produce a SAS dataset containing observations with single date and  total. As shown by the 2 lines highlighted in RED below. However, the logic is producing the dataset with repeating dates and summarized totals. Any suggestions as to what should be done to produce the desired results.   %let begdate = 201501; %let enddate = 201506; proc sql;    create table test as    select t1.Paid_Date              as Paid_Dte format=YYMMN6.,           sum(t1.Adjusted_Paid_Amt) as Adjusted_Paid_Amount         FROM rpt_prod.rv_claims_medical t1,         rpt_prod.rv_group_product  t2   where t1.group_product_sk = t2.group_product_sk and         t1.Paid_Date_ccyymm between ("&begdate") and ("&enddate")             group by t1.paid_date  ;   Paid_Dte Adjusted_Paid_Amount 201501 16565.31 201501 2003159.95 201502 2152220.5 201502 1169554.64 201501 2019725.26 201502 3321775.14   quit; ... View more

Given the below code specifically the Compute Last_Name logic [see purple code], my questions are why are the lines highed in RED repeating with just the last name value on the line, 2) why would there be a line which appears to be a break line printing populating the last_name field when there's no Compute Afer Last_Name block? Report #1 is what is happening. Report #2 is what I would like to happen. I truly would appreciate any assistance in clearing this up.   Thank your very murch in advance....   proc report data=vbb_rpt out=vbb_out split='*' missing nowd             style(header)={tagattr="wrap:YES"}             style(lines)={tagattr='Format:@'};       column incent_plan_effdt incentive_plan_name incentive_component_name last_name first_name subscriber_id            subscriber_and_sfx relationship_code reward_earndt reward_type reward_amount incent_comp_achieve_earndt            incent_comp_achieve_createdt elig_ruleset eff_cnt ;       define incent_plan_effdt / group 'Incentive*Plan*Eff Dt' width=9;  define incentive_plan_name / group 'Incentive*Plan*Name' width=9 style(column)={tagattr="wrap:YES"};  define incentive_component_name / group 'Incentive*Component*Name' width=9 style(column)={tagattr="wrap:YES"};;       define last_name / order  order=formatted 'Last*Name' width=5;  define first_name / order order=formatted 'First*Name' width=5;     define subscriber_id / group 'Subscriber*Id' width=9;  define subscriber_and_sfx  / group 'Member*Id' width=9;     define relationship_code / order order=formatted 'Relationship*Code' width=11;     define reward_earndt / order order=formatted 'Reward*Earned Dt' width=9;  define reward_type / order order=formatted 'Reward*Type' width=6;  define reward_amount / order order=formatted 'Reward*Amt' width=6 format=dollar5.2;     define incent_comp_achieve_earndt / order order=formatted 'Incentive*Component*Achievement*Earn Dt' width=11;  define incent_comp_achieve_createdt / order order=formatted 'Incentive*Component*Achievement*Created Dt' width=11;  define elig_ruleset / order order=formatted 'Eligibility*Classification' width=11;  define eff_cnt / analysis sum noprint;    compute before incent_plan_effdt;   last_name = "";   uniqsub = 0;   uniqsub+eff_cnt.sum;     endcomp;    break after incent_plan_effdt / summarize;  compute after incent_plan_effdt;   /* Test No Records */   If incent_plan_effdt ^= . then      do;      last_name = "";      subscriber_id = uniqsub;         subscriber_and_sfx = uniqsub;   end;    endcomp;   compute before incentive_plan_name;   last_name = "";      ipname = incentive_plan_name;   uniqmem = 0;   uniqmem+eff_cnt.sum;     endcomp;  break after incentive_plan_name / summarize;  compute after incentive_plan_name;    /* Test No Records */   if incentive_plan_name ^= ' ' then      do;      last_name = "";      incent_plan_effdt = ' ';      incentive_component_name = 'Count';         if uniqsub > uniqmem then            do;              subscriber_id = uniqsub;              subscriber_and_sfx = uniqsub ;          end;         else do;                subscriber_id = uniqmem;                subscriber_and_sfx = uniqmem;           end;            end;     endcomp;     compute before incentive_component_name;   last_name = "";   subcnt=0;      subsfx_cnt=0;     endcomp;    break after incentive_component_name / summarize;     compute after incentive_component_name;    /* Test No Records */          if incentive_component_name ^= ' ' then      do;      last_name = "";      incent_plan_effdt = ' ';         incentive_plan_name = ' ';         subscriber_id = subcnt;         subscriber_and_sfx = subsfx_cnt;   end;     endcomp;  compute last_name;   /* Correct issue of blank last names */   if last_name ne ' ' then hlast_name = last_name;   if last_name eq ' ' then last_name = hlast_name;   endcomp;     compute after subscriber_id;   subcnt+1;     endcomp;   compute after subscriber_and_sfx;   subsfx_cnt+1;  endcomp; run;   #1 Report output: Last Name First Name Boss Tom Smith Brenda Smith   Johnson James Johnson   Taylor Mike Teller Jones   #2 Report should look like this:   Last Name First Name Boss Tom Smith Brenda Johnson James Taylor Mike Teller Jones   ... View more

I'm new to Proc Report and ODS processing. How to I prevent duplication of data given the below code. The line in RED shouldn't print.   Physician  Component                        63         63              Welcome to your Bible            Count  104        104              Welcome to your Bible            Count  104        104                  proc report data=vbb_rpt out=vbb_out split='*' missing nowd;    column incent_plan_effdt incentive_plan_name incentive_component_name last_name first_name subscriber_id            subscriber_and_sfx relationship_code reward_earndt reward_type reward_amount            incent_comp_achieve_earndt incent_comp_achieve_createdt elig_ruleset eff_cnt plan_cnt;       define incent_plan_effdt / group 'Incentive Plan Eff Dt' width=22;  define incentive_plan_name / group 'Incentive Plan Name' width=19;  define incentive_component_name / group 'Incentive Component Name' width=25;   define last_name / order order=internal 'Last Name' width=9;  define first_name / order order=internal 'First Name' width=10;     define subscriber_id / group 'Subscriber Id' width=13;  define subscriber_and_sfx  / group 'Member Id' width=14;     define relationship_code / order order=data 'Relationship Code' width=17;     define reward_earndt / order order=data'Reward Earned Dt' width=16;  define reward_type / order order=data 'Reward Type' width=11;  define reward_amount / order order=data 'Reward Amt' width=10 format=dollar5.2;     define incent_comp_achieve_earndt / order order=data 'Incentive Component*Achievement Earn Dt' width=40;  define incent_comp_achieve_createdt / order order=data 'Incentive Component*Achievement Created Dt' width=42;  define elig_ruleset / order order=data 'Eligibility Classification' width=11;  define eff_cnt / analysis sum noprint;  define plan_cnt / analysis sum noprint;         compute before incent_plan_effdt;      uniqsub = 0;   uniqsub+eff_cnt.sum;   endcomp;    compute after incent_plan_effdt;   line @1 ipname $60. @62 'Count' @68 uniqsub 4. @79 uniqsub 4.;    endcomp;   compute before incentive_plan_name;      ipname = incentive_plan_name;   uniqmem = 0;   uniqmem+plan_cnt.sum;      endcomp;  compute after incentive_plan_name;     line @1 incentive_plan_name $60. @62 'Count' @68 uniqmem 4. @79 uniqmem 4.;  endcomp;     compute before incentive_component_name;      subcnt=0;     endcomp;     compute after incentive_component_name;       line @10 incentive_component_name $30. @95 subcnt 4. @115 subcnt 4.;     endcomp;  compute after subscriber_id;      subcnt+1;     endcomp;     rbreak after / summarize ul ol;   run;           ;   ... View more