About fredbell

fredbell · ‎10-14-2010

Hello Trouble with Datepart, any suggestions. I'm told if i wrap variable in an input statement it will convert it to sas datetime, can anyone provide example? proc sql; create table Total_CallsHandled_by_Day as select datepart(ReportTime), sum(agentcallshandled) as Calls_Handled from ccar_callshandled; quit; Log below 251 proc sql; 252 create table Total_CallsHandled_by_Day as 253 select datepart(ReportTime), sum(agentcallshandled) as Calls_Handled 254 from ccar_callshandled; ERROR: Function DATEPART requires a numeric expression as argument 1. 255 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ReportTime example 2010-09-30 00:00:00.000000 Please help Message was edited by: fredbell

fredbell · ‎10-12-2010

So very frustrating, below code finally worked. %let MTDFromDate= '2010-10-01 00:00:00.000000'; %let MTDToDate = '2010-10-12 00:00:00.000000'; proc sql; create table test as select * from jennifer.vccart_sceintrvl WHERE ReportTime ge &MTDfromdate and ReportTime le &MTDTodate; quit; Thanks Fred

fredbell · ‎10-12-2010

Hi sbb Yes i have been looking all weekend but can't find anything that explains it so i can understand. Reading and more reading, tried many many variations without success. If anyone has an example please that would be great. Fred Message was edited by: fredbell Message was edited by: fredbell Message was edited by: fredbell

fredbell · ‎10-12-2010

Hi Ksharp Sorry your code resulted in the below error. ERROR: Expression using IN has components that are of different data types. Fred

fredbell · ‎10-08-2010

Hi everyone! I'm having an issue with the below code and the error in the Subject. %let MTDFromDate= '01-oct-2010:00:00:000'dt; %let MTDToDate = '10-oct-2010:00:00:000'dt; proc sql; create table test as select * from jennifer.vccart_sceintrvl WHERE ReportTime ge &MTDfromdate and ReportTime le &MTDTodate; quit; Log 212 %let MTDFromDate= '01-oct-2010:00:00:000'dt; 213 %let MTDToDate = '10-oct-2010:00:00:000'dt; 214 proc sql; 215 create table test as 216 select * from jennifer.vccart_sceintrvl 217 WHERE ReportTime ge &MTDfromdate and ReportTime le &MTDTodate; ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL where clause optimization. 218 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.39 seconds cpu time 0.01 seconds Help Please Fred

fredbell · ‎10-06-2010

I am very new to SAS but i will try to work through what you have posted, any chance you could post example? Thanks sbb Fred

fredbell · ‎10-06-2010

Hello I need to append records from one table to another but have the append fuction not append if record already exists in Base dataset. Example of Base Dataset, Name of Base dataset "Employees" Name Age Sex Province -------------------------------------------------------------- FRED 48 M ONT. SAM 55 M ONT. KIM 19 F ONT. KAREN 33 F ONT. Example of dataset that i want to append to Base, Name "NewEmployees" Name Age Sex Province ------------------------------------------------------------- FRED 48 M ONT. Tony 51 M ONT. I don't want it to append record below because it already exists in Base. Name Age Sex Province ------------------------------------------------------------- FRED 48 M ONT. I do want it to append this record because it does not appear in Base. Name Age Sex Province ------------------------------------------------------------- Tony 51 M ONT. proc append Base = Employees Data = NewEmployees FORCE ; run; Thanks and i hope this is clear and possible. Fred

fredbell · ‎10-06-2010

Once again thanks for all your help and patience. I have just started a new job in June 2010 and without any previous knowledge of SAS inherited several programs and have built a few, very big learning curve. I will work harder to going forward to be clear and include examples for any future posts. Cynthia your last reply clarified it for me and I got it to work. Thanks Fred

fredbell · ‎10-05-2010

Hi Cynthia Below is my code and then the resulting error, any suggestions? %let dsid = %sysfunc(open(ccar.tracking)); %let nobs = %sysfunc(attrn(&dsid, nobs)); %put number of obs in ccar.tracking is: &nobs; data ccar.Master/view=ccar.master; set ccar.tracking; id=&nobs+_n_; run; proc append Base =ccar.Master Data = ccar.Dupes_virtual_queue FORCE ; run; -------------------------------------------------------------------------------------------------------------------- proc append Base =ccar.Master Data = ccar.Dupes_virtual_queue FORCE ; ERROR: Unable to open the read only view CCAR.MASTER for UPDATE. 46 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.25 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. Fred

fredbell · ‎10-05-2010

Hi again One thing that is causing some confusion that maby you can help with. _ERROR_=0 _N_=1 shows after the results in the email body, can you confirm what it means and suggest a way to suppress it? Thank Fred

fredbell · ‎10-05-2010

Thank you so much everyone for your help and patience, i got it to work. Fred

fredbell · ‎10-04-2010

Hi Duke Please see my code and below that the log error filename mymail email "fred.standard@symptico.ca" subject="test message"; data _null_; SET ccar.count; file mymail; PUT _all_= ; run; quit; Log Error below 26 filename mymail email "fred.standard@sympatico.ca" subject="test 27 message"; 28 data _null_; 29 SET ccar.count; 30 file mymail; 31 PUT _all_= hello; - 22 ERROR 22-322: Expecting a name. 32 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.00 seconds 32 ! quit;

fredbell · ‎10-04-2010

Sorry I was attempting to be clear. I checked and read the info on the link you attached and it does not explain how to embed the results from a dataset into the email body. Fred

fredbell · ‎10-04-2010

Running this created error below data temp/view=temp; set ccar.dupes_virtual_queue; id=&nobs+_n_; run; 22 data temp/view=temp; 23 set ccar.dupes_virtual_queue; 24 id=&nobs+_n_; - 22 WARNING: Apparent symbolic reference NOBS not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. 25 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds

fredbell · ‎10-04-2010

Hi everyone! I am attempting to send email with the results of dataset as part of email body, not as attachment. I've looked and looked but can't find something that works. Please keep in mind i am new to SAS. Thanks Fred

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Collapse table of Contents

Plot of unknown * date

Re: Table of Contents

Table of Contents

ERROR: Expression using IN has components that are of different data t...

Re: Proc Import Excel

Re: Proc Import Excel

Proc Import Excel: get column names from different range

Re: Date=input(ReportTime, anydtdtm22.);*this converts it to datetime ...

Re: FULL JOIN

Proc Import Excel: get column names from different range

Re: Function Datepart

Re: ERROR: Expression using IN has components that are of different da...

Re: ERROR: Expression using IN has components that are of different da...

Re: ERROR: Expression using IN has components that are of different da...

ERROR: Expression using IN has components that are of different data t...

Re: Append Unique records

Append Unique records

Re: Assign ID

Re: Assign ID

Re: Email results as part of body

Re: Email results as part of body

Re: Email results as part of body

Re: Email results as part of body

Re: Assign ID

Email results as part of body