Hi I  want to append data from his_new to hist_old table but the issue is I am not getting proper format for below dates coloumn max_date and min date. Please note that I am getting min_date and max_date avlues  from macro variable   data hist_entry; format entity_name $18. ; format date yymmdd10. ; format checksum_column_nm $12. ; format checksum_column_val best32. ; format date_column_nm $16. ; format record_count best32. ; format active_flag $1. ; format distinct_date_count best32. ; informat max_date yymmdd10. ; informat min_date yymmdd10. ; format max_date yymmdd10. ; format min_date yymmdd10. ; entity_name="invoice"; date=today(); checksum_column_nm="sell_qty"; checksum_column_val= 4102745354; date_column_nm= "sell_dt"; record_count=4586000; active_flag="Y"; distinct_date_count = 50; max_date = 2022-03-06; min_date =2022-01-16; output; run; proc append base=hist_old data=hist_new ; run;   the issue is for max_date value is coming as 1965-07-06 and min_date is coming as 1965-06-28 I am not sure why this is happening . Could you please help.   Also max_date = 2022-03-06; min_date =2022-01-16; these values are getting resolved from macro variables.   ... View more

How to read value like this    03/2020 - sunday check 3x75g   This value is present in csv file along with many other variables values. This particular column (values like 03/2020 - sunday check 3x75g)  which is  as mentioned is coming as blank . Please advise ... View more

I have a table ABC . ABC is having a column ONE  .   Column one is having value like this  month_num  week_in_month   bc_type   cycle   event_daysnum  event_flag  SEGMENT_CD  BRAND_SEGMENT_CD SUBBRAND_CD   FLAVOR_CD   LH_CATEGORY_CD   LH_MARKET_SEGMENT_CD   LH_UMBRELLA_BRAND_CD LH_MATERIAL_BRAND_CD   LH_SUBGRP_CD   LH_MATERIAL_VARIANT_CD   CUSTOMER_HIERARCHY_LVL1_CD     I  need to remove the  part MN_Natural_san_CD , but keeping the rest of the table intact month_num week_in_month bc_type cycle event_daysnum event_flag SEGMENT_CD BRAND_SEGMENT_CD SUBBRAND_CD FLAVOR_CD LH_CATEGORY_CD LH_MARKET_SEGMENT_CD LH_UMBRELLA_BRAND_CD LH_MATERIAL_BRAND_CD LH_SUBGRP_CD  MN_Natural_san_CD CUSTOMER_HIERARCHY_LVL1_CD   please help.   Tried  below code  data new; set ABC; one = compress(one,"MN_Natural_san_CD"); run;   This is not working   1. got value like this (Its incorrect ) monthnum weekinmonth bctype cycle eventdaysnum eventflag SG BSG SUBB FO GOY KSG UBB B SUBGP USOY1    2.  WARNING: Data too long for column "One"; truncated to 128 characters to fit. ... View more

I have a sample data like this: Here invoice_dt is in format DDMMYYS10.; Sale   invoice_dt A      23/07/2018 B      01/07/2018 C      22/07/2018 D      04/03/2019 E      31/03/2019 R      31/07/2018 F       01/05/2018 I        10/07/2015 J       01/02/2014   I want to write a where condition in datastep to delete records  where invoice_dt is in between  01/07/2018 to 31/07/2018 and 01/03/2019 to 31/03/2019,    Please help.         ... View more

I am getting error while inserting data using proc fedsql   Proc fedsql;  create table paylist  (IdNum char(4),  Gender char(1),  Jobcode char(3),  Salary double,  Birth date,  Hired date); insert into paylist  values('1639','F','TA1',42260,date'26JUN70',date'28JAN91')  values('1065','M','ME3',38090,date'26JAN54',date'07JAN92')  values('1400','M','ME1',29769,date'05NOV67',date'16OCT90')  values('1561','M',null,36514,date'30NOV63',date'07OCT87')  values('1221','F','FA3',.,date'22SEP63',date'04OCT94'); quit;   error : syntax error at or near values. Please help me to resolve this issue. ... View more

Dear member,   Could you please help me in below query: input Data  one; input all $50. ; datalines;  ram is "amazing" shyan needs "/books/lamps" we are "/travellling/" ; run;    I need output dataset New having values like this  in a new variable two.   two amazing /books/lamps   /travellling/         ... View more