I wish to  dynamically name a variable 'leakersN' in the code below. what is the proper code structure for dynamically naming a variable?   %let RN = 3725; %put RN = &RN; data has; set has; if FAULT_CODE = '20-2018' and VEHICLE_NO = "&RN" then leakers'&RN' = count(FAULT_CODE,'20-2018'); run; ... View more

I'm using the following code to begin. I'd like to divide the x variable OCCUR_DATE into monthly,/weekly/daily var charts for each vehicle. The macro will plot data counts for each individual vehicle.   %macro rept_plot_Cycle(num); title "&num Cycle plot"; proc sgplot data=cycle_data; where VEHICLE_NO = "&num" ; yaxis label= "cycle count"; vbar x=OCCUR_DATE y=count(fault_code); run; %mend rept_plot_Cycle; data _null_; array veh_no[39] _temporary_ (3725:3763) ; call execute('proc sql;'); do i=1 to dim(veh_no) while (veh_no(i) ne .); call execute(cats('%nrstr(%rept_plot_Cycle)(',veh_no(i),')')); end; call execute('quit;'); run; ... View more

I am using the code below to generate a series of plots with sgplot in a loop. The process doesn't generate any plots.    data _null_; array veh_no[2] _temporary_ (3725:3726) ; call execute('proc sql;'); do i=1 to dim(veh_no) while (veh_no(i) ne .); call execute(cats('%nrstr(%rept_plot3xxx)(',veh_no(i),')')); end; call execute('quit;'); run; %macro rept_plot3xxx(num); proc sgplot data=DWM_Min_list_3xxx_psi; title "&num scatter plot"; yaxis label= "psi"; scatter x=OCCUR_DATE y=DWM_TRUCK_1_PRESS_2_FDBK_8451; scatter x=OCCUR_DATE y=DWM_TRUCK_2_PRESS_2_FDBK_8453; where VEHICLE_NO = '&num' and DWM_TRUCK_1_PRESS_2_FDBK_8451 between 0 and 25 and DWM_TRUCK_2_PRESS_2_FDBK_8453 between 0 and 25 ; run; %mend rept_plot3xxx; ... View more

With the following macros I create 2 different types of tables using a simple proc means approach. The code works fine.    I need to modify the code to add a column to the TABS_stat_per_axle proc means by dividing the MAX of TABS_stat_per_axle by the MAX of the TABS_stat_slide_risk proc means.    %macro TABS_stat_per_axle(num); proc means data=WORK.QUERY_FOR_COUNTS MAX MAXDEC=2; where SORT_ORDER = # title "TABS Statistic - &num"; Label STATISTIC_ATTRIBUTE_VAL="&num - distance in ft"; class vehicle_no; var STATISTIC_ATTRIBUTE_VAL; run; %mend TABS_stat_per_axle; %macro TABS_stat_slide_risk(num); proc means data=WORK.QUERY_FOR_COUNTS MIN MAX MAXDEC=2; where SORT_ORDER = # title "TABS Statistic - &num"; Label STATISTIC_ATTRIBUTE_VAL="&num - distance in ft"; class vehicle_no; var STATISTIC_ATTRIBUTE_VAL; run; %mend TABS_stat_slide_risk; data _null_; array TABS_no[26] _temporary_ (1113:1138) ; call execute('proc sql;'); do i=1 to dim(TABS_no) while (TABS_no(i) ne .); if TABS_no(i)=1129 then call execute(cats('%nrstr(%TABS_stat_slide_risk)(',TABS_no(i),')')); else call execute(cats('%nrstr(%TABS_stat_per_axle)(',TABS_no(i),')')); end; call execute('quit;'); run; ... View more

I'm attempting to access a variable in have for calling a macro from a do loop. When I try the following code I get errors:   ERROR: The DIM, LBOUND, and HBOUND functions require an array name for the first argument. ERROR 68-185: The function Var_in_have is unknown, or cannot be accessed. data have; call execute('proc sql;'); do i=1 to dim(Var_in_have) while (Var_in_have(i) ne .); call execute(cats('%nrstr(%some_macro)(',Var_in_have(i),')')); end; call execute('quit;'); run; ... View more

I used the following code. proc sql; create table fault_CNT_only as select Unit, fault_code, count(*) as fault_count from all_units_results group by Unit, fault_code; quit; proc sql; create table fault_CNT as select A.Unit, A.fault_code, count(*) as fault_count, B.sw_install_date from all_units_results A left join InstallDate B on A.Unit=B.vehicle_no group by Unit, fault_code ; quit;     The output of fault_CNT_only looks like:   8116 20-1803 1 8118 20-0715 1 8119 20-1801 2 8119 20-1802 2 8119 20-1803 2 8119 20-1804 3 8119 20-1806 2 8133 20-0794 1   while the output of fault_CNT looks like:   8116 20-1803 1 02JAN2015 8118 20-0715 1 01JAN2015 8119 20-1801 2 01JAN2015 8119 20-1801 2 01JAN2015 8119 20-1802 2 01JAN2015 8119 20-1802 2 01JAN2015 8119 20-1803 2 01JAN2015 8119 20-1803 2 01JAN2015 8119 20-1804 3 01JAN2015 8119 20-1804 3 01JAN2015 8119 20-1804 3 01JAN2015 8119 20-1806 2 01JAN2015 8119 20-1806 2 01JAN2015 8133 20-0794 1 01JAN2015   How can I get the same number of rows for fault_CNT as in fault_CNT_only?   Thanks for your help.   ... View more