Hi , I am using SAS grid and using the following conditions. %LET DWPROD='jdbc:db2://pwg1.INFO53.COM:9030/LGRDWP1:useJDBC4ColumnNameAndLabelSemantics=false;'; %LET EDWPROD='jdbc:db2://saflokydcedwc01:50000/EDWPROD:useJDBC4ColumnNameAndLabelSemantics=false;'; LIBNAME edw JDBC URL=&EDWPROD user=&eid_db2conn. password=&pwd_db2conn. DRIVERCLASS=&DB2CLASS; LIBNAME dwp1 JDBC URL=&DWPROD user=&eid_db2conn. password=&pwd_db2conn. DRIVERCLASS=&DB2CLASS ;   I would like to create a pass through connection to fetch the data from below tables. The below code is throwing error since the connection is different for edw and dwp1 tables . I would like to know the syntax to create a passthrough for both DWP1 and EDW.   (For example only) proc sql ; connect using edw; CREATE TABLE Od_6 AS SELECT * FROM CONNECTION TO dwp1 ( select distinct hper.hh_key, from dwp1.dep_acct_mo_dw as depm inner join dwp1.dep_acct_dim as depd on depm.i_rec_key = depd.i_rec_key inner join dwp1.rltn_dim as rltn on depm.i_rec_key = rltn.i_rec_key inner join dwp1.time_dim as time on depm.i_prtn = time.i_prtn_mo_84 inner join edw.common_account_daily_dim as cadd on depm.i_rec_key = cadd.i_rec_key inner join edw.household_periodic as hper on cadd.acct_key = hper.acct_key and time.d_per = hper.date_key where /* time.d_per between &prior6_month. and &current_month.*/ time.d_per between '09/01/2021' and '02/28/2022' /* time.d_per between %bquote(date(&prior6_mth.)) and %bquote(date(&current_mth.))*/ and time.x_lst_day_mo = 'Y' group by hper.hh_key WITH UR); QUIT;               ... View more

Hi,   Currently my data set is :   DT_APP product category apps Jan2021 Cards 12363 Jan2021 Lending 6716 Feb2021 Cards 13217 Feb2021 Lending 7030 Mar2021 Cards 17400 Mar2021 Lending 8475 Apr2021 Cards 15488 Apr2021 Lending 7958 May2021 Cards 14316 May2021 Lending 8000 Jun2021 Cards 15559 Jun2021 Lending 8508 Jul2021 Cards 14255 Jul2021 Lending 9027 Aug2021 Cards 13901 Aug2021 Lending 12557 Sep2021 Cards 12515 Sep2021 Lending 11630 Oct2021 Cards 11295 Oct2021 Lending 10435 Nov2021 Cards 11416 Nov2021 Lending 8904 Dec2021 Cards 10424 Dec2021 Lending 8685 Jan2022 Cards 10836 Jan2022 Lending 8520   and after running sgplot with this code  :   proc sgplot data=prod_cat_WITH_DM_Apps_Graph1; title justify=center "test" justify=center; styleattrs datacontrastcolors=(blue green orange brown); series x=dt_app y=apps / group=product_category lineattrs=(thickness=2 pattern=solid) legendlabel="Actual+Forecast"; yaxis grid label="apps"; xaxis label="Application Month" valuesformat=monyy.; run;   I am getting output as :     Question: Why am I getting Mar22 in the horizontal axis when i don't have Mar22 in the dataset.           ... View more