Please try the below code   data test; label n = "num" c = "char"; input n c $; cards; 1 123 2 xyz run; proc contents data=test; run; ... View more

Please try the anydtdte20. format   data test; set prevdata; s_date = input("&file_date.", anydtdte20.); format s_date yymmdd10.; run; ... View more

Alternatively you can try the below code where you derive a new variable source2 and use this variable in place of source could you please try the let me know if this resolves the issue   proc format ; value $src 'Bakk'='Bakken (ND & MT)' 'Eagl'='Eagle Ford (TX)'; run; data Long ; set Long ; source2=put(source,$src.); run; ods graphics on / width=7in height=4.5in maxlegendarea=60; proc sgplot data=Long dattrmap=myattrmap; vbar date / response=Value group=Source2 groupdisplay=stack grouporder=data attrid=myid; xaxis type=time thresholdmin=0 max=21100 display=(nolabel); yaxis grid values=(0 to 7) GRIDATTRS=(color=white) label="Million barrels per day"; keylegend /title=""; run; ... View more

The easiest and best approach would be to use a format on the source variable as below and then apply that format in sgplot to source variable   proc format ; value $src 'Bakk'='Bakken (ND & MT)' 'Eagl'='Eagle Ford (TX)'; run; ods graphics on / width=7in height=4.5in maxlegendarea=60; proc sgplot data=Long dattrmap=myattrmap; vbar date / response=Value group=Source groupdisplay=stack grouporder=data attrid=myid; xaxis type=time thresholdmin=0 max=21100 display=(nolabel); yaxis grid values=(0 to 7) GRIDATTRS=(color=white) label="Million barrels per day"; keylegend /title=""; format source $src.; run; ... View more

if you want to concatenate you can try the below code   data want; set have; account_number=cats(branch,account); run; ... View more

If the expected output is to have the list of text not in list2 but in list 1 the try the below code   data have1; input list$; cards; AAAU ACIM ACWF ACWX ADRD ADRE ADRU AGG ; data have2; input list$; cards; ACIM ACWF AGG ; proc sort data=have1; by list; run; proc sort data=have2; by list; run; data want; merge have1(in=a) have2(in=b); by list; if a and not b; run; ... View more

Please let us know if you are trying to identify the text not in either of the both list. ... View more

please try   data want; set raw_tbl; by id yymm; retain Ind_Touch_Failure No_Failures; if first.id then do; Ind_Touch_Failure=.;No_Failures=.;end; if grade=11 then Ind_Touch_Failure=1; else Ind_Touch_Failure=0; if grade=11 then No_Failures+1; else No_Failures=0; if last.id; run; ... View more