About miss2223

miss2223 · ‎10-16-2022

The code works!! But it generates the email when the data does not exist. 1 The SAS System 09:49 Monday, October 17, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; ERROR: The %IF statement is not valid in open code. 23 %if %sysfunc(exist(work.CUSTOM1)) 24 %then %do; 25 %put Dataset found!; Dataset found! 26 filename send email 27 to=('test@abc.com') 28 type='text/html' 29 subject="Data_FAILED" 30 from='test@abc.com' 31 ; 32 ods html body=send; NOTE: Writing HTML Body file: SEND 33 ods text="something for the mail"; 34 ods html close; Message sent To: 'test@abc.com' Cc: Bcc: Subject: Data_FAILED Attachments: 35 filename send clear; NOTE: Fileref SEND has been deassigned. ERROR: The %END statement is not valid in open code. 2 The SAS System 09:49 Monday, October 17, 2022 ERROR: The %ELSE statement is not valid in open code. 36 %end; 37 %else %do; 38 %put Dataset not found!; Dataset not found! 39 data dataset; 40 input var1 $ CON_DATE_START :ddmmyy10. PL_DATE_START :ddmmyy10. SS_DATE_START :ddmmyy10.; 41 format CON_DATE_START ddmmyy10. PL_DATE_START ddmmyy10. SS_DATE_START ddmmyy10.; 42 datalines; NOTE: The data set WORK.DATASET has 4 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 739.53k OS Memory 21852.00k Timestamp 17/10/2022 10:47:45 AM Step Count 6 Switch Count 46 47 ; 48 %end; ERROR: The %END statement is not valid in open code. 49 50 GOPTIONS NOACCESSIBLE; 51 %LET _CLIENTTASKLABEL=; 52 %LET _CLIENTPROJECTPATH=; 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 56 ;*';*";*/;quit;run; 57 ODS _ALL_ CLOSE; 58 59 60 QUIT; RUN; 61

miss2223 · ‎10-13-2022

1 The SAS System 09:08 Friday, October 14, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; ERROR: The %IF statement is not valid in open code. 23 %if %sysfunc(exist(work.CUSTOM1)) 24 %then %do; 25 %put Dataset found!; Dataset found! 26 filename send email 27 to=('test@abc.com') 28 type='text/html' 29 subject="Data_FAILED" 30 from='test@abc.com' 31 ; 32 ods html body=send; NOTE: Writing HTML Body file: SEND 33 ods html close; Message sent To: 'test@abc.com' Cc: Bcc: Subject: Data_FAILED Attachments: 34 filename send clear; NOTE: Fileref SEND has been deassigned. ERROR: The %END statement is not valid in open code. ERROR: The %ELSE statement is not valid in open code. 2 The SAS System 09:08 Friday, October 14, 2022 35 36 %end; 37 %else %do; 38 %put Dataset not found!; Dataset not found! 39 data ; 40 input var1 $ CON_DATE_START :ddmmyy10. PL_DATE_START :ddmmyy10. SS_DATE_START :ddmmyy10.; 41 format CON_DATE_START ddmmyy10. PL_DATE_START ddmmyy10. SS_DATE_START ddmmyy10.; 42 datalines; NOTE: The data set WORK.DATA5 has 4 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 739.59k OS Memory 22108.00k Timestamp 14/10/2022 11:15:13 AM Step Count 7 Switch Count 46 47 ; 48 49 %end; ERROR: The %END statement is not valid in open code. 50 51 GOPTIONS NOACCESSIBLE; 52 %LET _CLIENTTASKLABEL=; 53 %LET _CLIENTPROJECTPATH=; 54 %LET _CLIENTPROJECTNAME=; 55 %LET _SASPROGRAMFILE=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62 Sorry for the confusion. Email generate and datastep run, when 'work.CUSTOM1' is available Email generate and datastep run, also when 'work.CUSTOM1' is unavailable I thought 'else' statement will only execute when data 'work.CUSTOM1' is unavailable? Thanks for your time.

miss2223 · ‎10-12-2022

1 The SAS System 15:04 Thursday, October 13, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 %macro test; 24 %if %sysfunc(exist(work.CUSTOM1)) 25 %then %do; 26 %put Dataset found!; 27 filename send email 28 to=('test@abc.com') 29 type='text/html' 30 subject="Data_FAILED" 31 from='test@abc.com' 32 ; 33 ods html body=send; 34 ods html close; 35 filename send clear; 36 %end; 37 %else %do; 38 %put Dataset not found!; 39 data ; 40 input var1 $ CON_DATE_START :ddmmyy10. PL_DATE_START :ddmmyy10. SS_DATE_START :ddmmyy10.; 41 format CON_DATE_START ddmmyy10. PL_DATE_START ddmmyy10. SS_DATE_START ddmmyy10.; 42 datalines; 43 A 12/12/2008 11/01/2022 05/10/2007 44 B 19/01/2001 11/02/2008 01/03/2020 45 C 23/10/2008 02/08/2019 02/02/2010 46 D 01/09/2002 01/01/2000 19/03/2006 2 The SAS System 15:04 Thursday, October 13, 2022 47 ; 48 %end; 49 %mend; 50 51 GOPTIONS NOACCESSIBLE; 52 %LET _CLIENTTASKLABEL=; 53 %LET _CLIENTPROJECTPATH=; 54 %LET _CLIENTPROJECTNAME=; 55 %LET _SASPROGRAMFILE=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62 The code runs fine with no error, but no email send when 'work.CUSTOM1' is available when 'work.CUSTOM1' is unavailable, the data step doesnt generate. Please see above log. Thanks in advance

miss2223 · ‎10-10-2022

It doesnt seem to be working. With above code you advised: When work.CUSTOM1 is available, it doesnt send out email, and no further action. When work.CUSTOM1 is NOT available, it doesnt process the data step. I suspected I might missed something in the code. Thanks

miss2223 · ‎10-09-2022

Hi all Below is my code. I would like to do : If work.CUSTOM1 is available/exist then send out an email to notify then STOP, with no further action. if data not available then process the data step as per usual. The code below it allows to send an email when CUSTOM1 is available, however the process step runs as well. I want it to stop processing when we know CUSTOM1 is there. Thanks in advance. data _null_; if exist("work.CUSTOM1") then call execute(catt( "filename send email " ," to=('test@abc.com')" ," type='text/html' " ," subject=""Data_FAILED"" " ,"from='test@abc.com' ;" ,"ods html body=send;" ,"ods html close;" ,"filename send clear;" )); else; data original_data; input var1 $ CON_DATE_START :ddmmyy10. PL_DATE_START :ddmmyy10. SS_DATE_START :ddmmyy10.; format CON_DATE_START ddmmyy10. PL_DATE_START ddmmyy10. SS_DATE_START ddmmyy10.; datalines; A 12/12/2008 11/01/2022 05/10/2007 B 19/01/2001 11/02/2008 01/03/2020 C 23/10/2008 02/08/2019 02/02/2010 D 01/09/2002 01/01/2000 19/03/2006 ; run; run;

miss2223 · ‎09-12-2022

Hi, Yes you are right. What we been told the latest update of the service_req has the correct information, we just presume thats the case. As we are just dealing with the data, it comes from the book. So I guess its fine to apply to all people. Thanks

miss2223 · ‎09-12-2022

Hi I have got two questions, below is my data code. data input; input Account Name$ birthday: ddmmyy10. startdate: ddmmyy10. enddate: ddmmyy10. service_req; format birthday: ddmmyy10. startdate: ddmmyy10. enddate: ddmmyy10.; datalines; 1232 Ryan 01/01/1990 07/04/2017 01/03/2022 9356 1232 Ryan 01/01/1990 02/03/2022 27/08/2022 9667 1440 Chris 13/12/1987 11/03/2019 19/03/2022 5112 1440 Chris 11/12/1987 01/04/2022 30/12/9999 7891 1211 May 05/04/1998 13/09/2017 11/08/2022 1209 1265 Sandy 10/12/1988 12/08/2022 01/10/2022 1287 ; It will be great if someone can help me out, as I'm new to SAS. Please break down to one code per question instead of combine the code to answer both question, if its possible. 1. Typo on Chris's birthday, account 1440 for Chris, one entry of the birthday is 13/12/1987, the other one is 11/12/1987. We believe the latest service request provides the correct date of birth Account Name birthday 1232 Ryan 1/01/1990 1440 Chris 11/12/1987 1211 May 5/04/1998 1265 Sandy 10/12/1988 2. I want the latest service request if there is dup under the same ID and same name. In this scenario I want 9667 for Ryan's service request. And 7891 for Chris. Account Name service_req 1232 Ryan 9667 1440 Chris 7891 1211 May 1209 1265 Sandy 1287 Many thanks!

miss2223 · ‎09-04-2022

Hi I got a dataset with a date type (MRCL_DATE_START), but the result is an 'A' rather than a date format? I am trying to code up to identify the students with 'A' from this table. I tried where MRCL_DATE_START = 'A', but obviously doesnt work, as this is a date type and A is a string. Please help.

miss2223 · ‎08-24-2022

Hi Below is my input code. data input; input ID Name$ startdate: ddmmyy10. enddate: ddmmyy10.; format startdate: ddmmyy10. enddate: ddmmyy10.; datalines; 132 Ryan 07/04/2017 01/03/2022 132 Ryan 02/03/2022 27/08/2022 144 Chris 11/04/2019 31/03/2022 144 Chris 01/04/2022 01/06/2022 12 May 13/09/2017 11/08/2022 12 Sandy 12/08/2022 01/10/2022; run; I would like my output to be when ID and Name is the same, combine them into one. Instead of the line one end date, change to line two end date ID Name startdate enddate 132 Ryan 7/04/2017 27/08/2022 144 Chris 11/04/2019 1/06/2022 12 May 13/09/2017 11/08/2022 12 Sandy 12/08/2022 1/10/2022

miss2223 · ‎08-19-2022

Thanks for explaining it. It works fine without having %macro TECHNOLOGY; on the top row. May I ask why having %macro SAS does not give the output data tab as usual? I realised quite a few of the macro code are doing the same thing.

miss2223 · ‎08-19-2022

Below is my code. No error running the code, but I want to see the output data. Is there a way to check the output for 'customer_details' from SAS? Also I want to export the data to excel after. %macro TECHNOLOGY(); %let _DT1=2022-03-01; %let DT1=%sysfunc(inputn(&_DT1, yymmdd10.), date9.); %put &DT1.; %let _DT2=2022-08-31; %let DT2=%sysfunc(inputn(&_DT2, yymmdd10.), date9.); %put &DT2.; data customer_details; set work.installation; where Contract = 'Y' AND Colour in ('Red', 'Orange', 'Blue') and contract_date_start="&dt1"d and contract_date_end="&dt2"d; run; %mend TECHNOLOGY; Many Thanks!!

miss2223 · ‎08-15-2022

datalines; Amy ,2 Stream St Mary,1/891 Mason Street John,821 Stream Road Ivy,67 Tork CL Martin ,5/891 Mason Avenue ; I have one row that is St and another is Street. Applying the code tranwrd(_Addr,'St', "Street"). The result turn up to be Streetreet. Any chance of fixing that? Amy 2 Streetream Street Mary 1/891 Mason Streetreet

miss2223 · ‎08-11-2022

Hi there My input data is below, I would like to change Rd to Road, AVE to Avenue, CL to close etc this is part of it I have lots of weird address as well. I have tried propcase(tranwrd(ADDR,'Cl','Close')) as ADDR. But this only does one name per time. Is there any chance I can update Rd, AVE and CL in one data step? Input Name Addr Amy 12 Stream Rd Mary 1/891 Mason AVE John 821 Stream Road Ivy 67 Tork CL Martin 5/891 Mason Avenue Expectation output Name Address Amy 12 Stream Road Mary 1/891 Mason Avenue John 821 Stream Road Ivy 67 Tork Close Martin 5/891 Mason Avenue Many thanks!

miss2223 · ‎08-01-2022

Original data is &lib..&customersdetail data original_data; input var1$ CON_DATE_START PL_DATE_START SS_DATE_START; datalines; A 12/12/2008 11/01/2022 05/10/2007 B 19/01/2001 11/02/2008 01/03/2020 C 23/10/2008 02/08/2019 02/02/2010 D 01/09/2002 01/01/2000 19/03/2006; run; I want to replace the current CON_DATE_START, instead of that to use calculation CON_DATE_START = min(PL_DATE_START, SS_DATE_START) Expecting to see: var1 CON_DATE_START PL_DATE_START SS_DATE_START A 05/10/2007 11/01/2022 05/10/2007 B 11/02/2008 11/02/2008 01/03/2020 C 02/02/2010 02/08/2019 02/02/2010 D 01/01/2000 01/01/2000 19/03/2006 Because the next step is in macro, I dont know how to link my replacement calculation of CON_DATE_START, so I dont need to change anything to below. proc sort data=&lib..&customersdetail out=_&customersdetail; where also ANLAGE eq "&anlage"; run; %if %length(&anlage) %then _&customersdetail; %else &lib..&customersdetail; (rename=(DONOTBUY=_DONOTBUY) where=(_DONOTBUY is missing))

miss2223 · ‎08-01-2022

Hi I would like to add an additional calculation to replace the current date in the dataset - 'CON_DATE_START = min(PL_DATE_START, SS_DATE_START);' The original code is below: I am aware I cannot add variables/calculation to the proc sort step. I have tried to add an extra data step above the sort step, but then the final step of %if(length) is a macro variable linking to the step from the proc sort. Which my datastep will not work considering it returns to a normal output rather than a macro output. Could you please advise how I can add a macro variable step to add the calculation in. Many Thanks! proc sort data=&lib..&customersdetail out=_&customersdetail; where also ANLAGE eq "&anlage"; run; %if %length(&anlage) %then _&customersdetail; %else &lib..&customersdetail; (rename=(DONOTBUY=_DONOTBUY) where=(_DONOTBUY is missing))

Online Status	Offline
Date Last Visited	‎08-25-2023 03:05 AM

Re: if then else

Re: if then else

Re: if then else

Re: if then else

if then else

Re: Data cleaning on date and number

Data cleaning on date and number

Date type return an 'A'

Combine two line into one based in conditions

Re: Export data in macro step

Count observations in BY group

Re: if then else

Re: if then else

Re: if then else

Re: if then else

if then else

Re: Data cleaning on date and number

Data cleaning on date and number

Date type return an 'A'

Combine two line into one based in conditions

Re: Export data in macro step

Export data in macro step

Re: Addresses update tranwrd

Addresses update tranwrd

Re: Add variable/observation to a macro

Add variable/observation to a macro