Hi, I have the below code : data report_week_oct_dec_data; set report_04_01_2021(rename=(date = chardate)) report_11_01_2021(rename=(date = chardate))       report_18_01_2021(rename=(date = chardate)) report_25_01_2021(rename=(date = chardate))        report_28_12_2020(rename=(date = chardate)) if not missing(chardate) then date = input(chardate,yymmdd10.); run;   But this is throwing error. Error is : variable hardate has been defined as bth character and numeric.   Please help. ... View more

Hi,   I am setting two data sets.Please find my code below : data login_oct_dec; set login_old Oct_Dec_Data; if (date > '2020-10-01' and date < '2020-12-31'); run; In this error is : variable date is character and numeric both. Using proc contents , i found that in login_old , date is char while in Oct_Dec_Data, date is num. Please help. ... View more

Hi ,   I am getting duplicate rows in data. The result is correct but it's generating same rows multiple times. The code is : proc sql; create table final as select month_year , count(distinct ccsid) as unique_visitor from login_old where ccsid ne '  '  group by month_year; quit;   I am getting result as below : 2020-04-01    12989 2020-04-01    12989 2020-04-01    12989 2020-04-01    12989 2020-05-01    17894 2020-05-01    17894 2020-05-01    17894 2020-05-01    17894 I want only one row for each result. Duplication is not needed. ... View more

Hi   when I am running the below code, it's running endless.Please help. %let date_start = '2021-02-01'; %let date_end = '2021-04-30'; %let country = sg proc sql; %conximp(p_&country._eap_v,implink,db,dbmax_test = 30) create table login_newas select * from conection to implink ( select *  from p_&country._eap_v.eap_event where mis_date between &date_start and &date_end )a; quit;   but, when I ru the below code, it runs fine: %let date_start = '2021-02-01'; %let date_end = '2021-04-30'; %let country = sg proc sql; %conximp(p_&country._eap_v,implink,db,dbmax_test = 30) create table login_newas select * from conection to implink ( select ccsid,mis_date from p_&country._eap_v.eap_event where mis_date between &date_start and &date_end )a; quit;   Only if i add select * , it runs endless. Please help.   ... View more

Hi,   I am getting error in group by ; the error is esyntax error expecting gt lt get let ! !! <= >= and othe such conditionals.   My code is : proc sql; select clnt_seg_beo_code, count(*) as count from beo group by month clnt_seg_beo_code order by count; quit;   Please help... ... View more