About kelxxx

kelxxx · ‎04-20-2023

Hello, my have and want tables are as following data have; input id_appel id_demande $ demand_label $20. ; cards; 1 A-01 Appointement 1 C-09 Contract 2 A-08 Appointement 2 D-10 Devis 2 C-11 Contract 2 C-29 Contract ; run; data want; input id_appel nb_dmd_A nb_dmd_B nb_dmd_C nb_dmd_D ; cards ; 1 1 0 1 0 2 1 0 2 1 ; run; This code is work for me proc sort data= have; by id_appel demand_label; quit; data want; set have; by id_appel; if first.id_appel then do; nb_dmd_A=0; nb_dmd_B=0; nb_dmd_C=0; nb_dmd_D=0; end; retain nb_dmd_: 0; if demand_label="Appointement" then nb_dmd_A = nb_dmd_A+1; if demand_label="BBB" then nb_dmd_B = nb_dmd_B+ 1; if demand_label="Contract" then nb_dmd_C = nb_dmd_C+1; if demand_label="Devis" then nb_dmd_D= nb_dmd_D+ 1; if last.id_appel; drop id_demande demand_label; run; I am looking to optimise my codes because i have many demand_label different . Can my codes be optimized ? Can you help me please? If you have any suggestion i am open for more details ... Thanks. Regards!!!

kelxxx · ‎03-31-2023

Yes, I agree with you. I need to import the data into a file. There is a date field, and in this field there are year values < 1582. Certainly, there are errors or incidents to report. But I want to know if there is a solution to circumvent it. Because this SAS error will block what I want to do next.

kelxxx · ‎03-31-2023

data test; datestr='01JAN1581'd; datestr2='01JAN1582'd; run; Yes, that's it, it's the year 202. I just did a test, and the error shows up from 1581.

kelxxx · ‎03-31-2023

Hello, I am working with the code below and I'm getting the error. 29 datestr='12Mar202'd; ___________ 77 ERROR: Invalid date/time/datetime constant '12Mar202'd. ERROR 77-185: Invalid number conversion on '12Mar202'd. 30 datestr2='12Mar0202'd; ____________ 77 ERROR: Invalid date/time/datetime constant '12Mar0202'd. ERROR 77-185: Invalid number conversion on '12Mar0202'd. data test; datestr='12Mar202'd; datestr2='12Mar0202'd; run; I don't know why SAS doesn't accept a 3 digit year. Is there a way to read 3 digit year in SAS? I thank you in advance for your help.

kelxxx · ‎08-16-2022

if date = intnx('month',date,1)-1; or if date = intnx('month',date,0,'E');

kelxxx · ‎08-16-2022

Unless I am mistaken, mat_nbr = remove the Matched Pattern in variable NBR , the value of times is –1, then matching patterns continue to be replaced until the end of source is reached. Sequence: match all of the followings in order BeginOfLine CapturingGroup GroupNumber:1 Repeat 0 zero or more times =>>> remove Leading Zeros in the varible nbr nbr = 0001 => mat_nbr=1 nbr= 001 01 => mat_nbr=1 01

kelxxx · ‎07-21-2022

data have; date="07/20/2022"; run; data want; set have; format date2 YYMMDDN8.; date2 = input(date, mmddyy10.); run; hello, you can find a lot of similar topics in the forum.

kelxxx · ‎03-14-2022

%gen_base(old_gwic_others_&P_YYMMDD.,Gwic_old_others); data &Portofo._VAL (KEEP= MOB DQ_6); >>> old_gwic_others_&P_YYMMDD._VAL set monthly.score_&Portofo.(keep=account_no CURR_DELQMONTH_ON_BOOK bad); >>> monthly.score_old_gwic_others_&P_YYMMDD.

kelxxx · ‎01-24-2022

data want; set have; if 3 <= ID <= 5; run;

kelxxx · ‎01-24-2022

/*if type of variable date = numeric */ data have; input date ; cards; 20110405 20120604 20130806 20140603 20150607 20160705 ;run; data want; set have; if 20130806 <= date <= 20150607; run; /*if type of variable date = character */ data have; input date $ ; cards; 20110405 20120604 20130806 20140603 20150607 20160705 ;run; data want; set have; if '20130806' <= date <= '20150607'; run; /*if type of variable date = date sas */ data have; input date yymmdd8. ; cards; 20110405 20120604 20130806 20140603 20150607 20160705 ;run; data want; set have; if '06AUG2013'd <= date <= '07JUN2015'd; run;

kelxxx · ‎12-28-2021

you don't need to input one by ont, because the macro will do that.

kelxxx · ‎12-28-2021

my program returns this result

kelxxx · ‎12-27-2021

It's awesome!!!!!!!

kelxxx · ‎12-27-2021

It's awesome!!!!!!!

kelxxx · ‎12-26-2021

You can try this. It works for me options noxwait; %let source_path= C:\Users\PNG\Documents; %let file_name= test.xlsx; %let destination_path=C:\users\png; X move &source_path\&file_name &destination_path; Please give me a like if you find it useful.Thanks!

Online Status	Offline
Date Last Visited	Tuesday

Opimisation SAS code

Re: How to read a 3 digit year? Invalid date/time/datetime constant

Re: How to read a 3 digit year? Invalid date/time/datetime constant

How to read a 3 digit year? Invalid date/time/datetime constant

Re: flagged end of the month

Re: Prxchange understanding

Re: Transforming date values from 07/20/2022 to 20220720 keeping the c...

Re: macro variable

Re: select a duration

Re: select a duration

Re: Looking for records which are "close" but won't be detected with N...

Re: Looking for records which are "close" but won't be detected with N...

Re: LAG function bad for copilot...shall I trust copilot?

Re: LAG function bad for copilot...shall I trust copilot?

Re: Formatting a macro variable

Re: Prxchange understanding

Re: Transforming date values from 07/20/2022 to 20220720 keeping the c...

Re: calculate stock cost based on FIFO

Re: How to convert only a word in an email text to bold/colored?

Re: get matching name in a string of another clumn

Opimisation SAS code

Re: How to read a 3 digit year? Invalid date/time/datetime constant

Re: How to read a 3 digit year? Invalid date/time/datetime constant

How to read a 3 digit year? Invalid date/time/datetime constant

Re: flagged end of the month

Re: Prxchange understanding

Re: Transforming date values from 07/20/2022 to 20220720 keeping the c...

Re: macro variable

Re: select a duration

Re: select a duration

Re: calculate stock cost based on FIFO

Re: calculate stock cost based on FIFO

Re: calculate stock cost based on FIFO

Re: calculate stock cost based on FIFO

Re: Move directory that contains excel files from one location to anot...

SAS Inner Circle Panel

SAS Analytics Explorers