About 01SASUser

01SASUser · ‎01-27-2015

I tried the program and it worked! thanks for helping!

01SASUser · ‎01-27-2015

I have a table that looks like this: Col1 Col2 Col3 1st 2nd 3rd Info Info 4th What I want to do is I will update the values of Col2 and Col3 by getting the value of Col2 and Col3 in the next row. For example, after updating my initial table, it should now look like this Col1 Col2 Col3 1st 2nd Info Info 3rd 4th

01SASUser · ‎11-21-2014

I use the INPUT function in order for me to convert character to numeric variable: Ex: (INPUT(txt_to_numeric,23.)) as txt_to_numeric length = 8 However, I am having an issue converting it to numeric. If the character variable is enclosed in parenthesis, in accounting term this is a negative value, the input function does not read it as a negative value but rather it reads it as NULL. May I know how to revise my code such that if the character value is (5) for example, it will convert it to numeric value as -5? Thanks.

01SASUser · ‎08-14-2014

I revised my program by changing time. to time12. : data FINAL; set RAW; format start_dT date9.; format start_Time time12.; format end_dT date9.; format end_Time time12.; start_dT = INPUT(SUBSTR(dt_start,1,10),mmddyy10.); start_time = INPUT(SCAN(dt_start ,2, "")||SCAN(dt_start ,3, ""),time12.); End_dT = INPUT(SUBSTR(dt_end,1,10),mmddyy10.); End_time = INPUT(SCAN(dt_end ,2, "")||SCAN(dt_end ,3, "") ,time12.); run; 10:00:00 PM now became 22:00:00. My question is will this program won't have any "glitch". Because in my previous program the time from 10:00:00 PM to 12:59:59PM produce a result of 10:00:00 to 12:59:59 instead of 22:00:00 to 00:59:59. But right now I get 22:00:00 to 00:59:59. I just want to be sure that my new program has now "glitch".

01SASUser · ‎08-13-2014

Below is my initial data set Below is my program that will separate date and time: data FINAL; set RAW; format start_dT date9.; format start_Time time8.; format end_dT date9.; format end_Time time8.; start_dT = INPUT(SUBSTR(dt_start,1,10),mmddyy10.); start_time = INPUT(SCAN(dt_start ,2, "")||SCAN(dt_start ,3, ""),time.); End_dT = INPUT(SUBSTR(dt_end,1,10),mmddyy10.); End_time = INPUT(SCAN(dt_end ,2, "")||SCAN(dt_end ,3, "") ,time.); run; However, there seems to be a problem with the program. Please refer to below image Error: The value of start_time should be 22:10:33 but it returns a value of 10:10:33. May I know how to fix this?

01SASUser · ‎07-18-2014

Thank you for the support!

01SASUser · ‎07-15-2014

I have an automated daily job in SAS DI that fails at some point in time (usually once a month). Please refer on the error below: 954 proc metalib; 955 omr (libid="" 956 repid="A5NLR6CO"); 957 report(type = summary); 958 update_rule = (noadd); 959 select (A5NLR6CO.BQ0001NE); 960 run; ERROR: The user does not have permission to perform this action. May I know how come this happens and how to fix it?

01SASUser · ‎06-26-2014

Hello. Thank you for the response. What if the conditions are: - IF TABLE_RAW_DATA1 AND TABLE_RAW_DATA2 AND TABLE_RAW_DATA3 EXISTS - ELSE IF ((TABLE_RAW_DATA1 AND TABLE_RAW_DATA2 EXISTS) AND (TABLE_RAW_DATA3 DOES NOT EXISTS)) May I know how to convert it into SAS code?

01SASUser · ‎06-26-2014

Hello. May I know how to convert my comment (/* */) into SAS code? Thanks. %macro loop; proc sql; select max(tnx_dt) into: today from TESTING; quit; %DO k= %sysevalf("&today"d) %TO %eval(%sysfunc(today())-2); proc sql; select max(tnx_dt) into: today1 from TESTING; select max(tnx_dt-1) into: yesterday from TESTING; select max(tnx_dt+1) into: tomorrow from TESTING; quit; %let day = %substr(&today1,1,5); %let dt1 = %substr(&yesterday,1,9); %let dt2 = %substr(&tomorrow,1,9); /*IF TABLE_RAW_DATA EXISTS, DO THE CODE BELOW */ proc sql; insert into TESTING values("&dt2"d); quit; /*ELSE IF TABLE_RAW_DATA DOES NOT EXISTS, DO THE CODE BELOW*/ proc sql; insert into TESTING (tnx_dt) select tnx_dt from previous_data; quit; %end; %mend; %loop;

01SASUser · ‎06-25-2014

The command "data _null_; call symput('YTDAY',put(today()-1,date9.)); run; %put &YTDAY.;" worked! Thank you for the support!

01SASUser · ‎06-25-2014

The command worked! Thank you for the support.

01SASUser · ‎06-25-2014

Hello. May I know how to output yesterday's date? To output today's date, what I do is execute "%put %sysfunc(today(),date);" 141 %put %sysfunc(today(),date); 25JUN14 I tried yesterday's date by revising my code to "%put %sysfunc(today()-1,date);" but I am receiving an error: ERROR: Expected close parenthesis after macro function invocation not found. 1,date) This also didn't work "%put %sysfunc((today(),date)-1);": ERROR: Function name missing in %SYSFUNC or %QSYSFUNC macro function reference. today(),date)-1)

01SASUser · ‎06-23-2014

It is now working! Thank you for the support.

01SASUser · ‎06-18-2014

Hello. Thank you for your response. I'm still receiving an error after performing the suggested code: 602 proc sql; 603 select max(date) into: fdate from RCBC_TB.CIV_APPENDED2; 604 run;quit; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. NOTE: PROCEDURE SQL used (Total process time): real time 0.20 seconds cpu time 0.09 seconds 605 606 %macro do_it; 607 %if %eval(%sysfunc(date())-"&fdate"d) ne 2 %then %do; 608 proc sql; 609 create table test as 610 select * from RCBC_TB.CIV_APPENDED2 611 having date=max(date); 612 quit; 613 614 data TEST2; 615 set TEST; 616 do 617 date=date+1 to today()-2; 618 output; 619 end; 620 run; 621 622 proc append 623 base=RCBC_TB.CIV_APPENDED2 624 data=TEST2 force; 625 run; 626 %end; 627 %mend; 628 %do_it; SYMBOLGEN: Macro variable FDATE resolves to 17JUN2014 ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 19893-"17JUN2014"d ERROR: The macro DO_IT will stop executing. " The condition was: 19893-"17JUN2014"d " --> is there a way to revise the program that will make "17JUN2014"d into numeric format (eg. for 17JUN2014 it should be 19891) The parameters of DATE column are indicated below:

01SASUser · ‎06-18-2014

Hello. Thank you for your response. I receive an error upon executing the suggested code: SYMBOLGEN: Macro variable FDATE resolves to 17JUN2014 ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 19892-17JUN2014 ERROR: The macro DO_IT will stop executing. May I know how to fix this?

Online Status	Offline
Date Last Visited	‎12-02-2016 01:27 AM

Re: Update of Table

Update of Table

Conversion from Character to Numeric (Accounting Numbers)

Re: Time Conversion

Time Conversion

Re: Error in SAS DI

Error in SAS DI

Re: IF-ELSE Condition if a table exists

IF-ELSE Condition if a table exists

Re: Macro function to output yesterday's date

Re: IF-ELSE Condition to Perform a Loop

Re: IF-ELSE Condition to Perform a Loop

Re: IF-ELSE Condition to Perform a Loop

Re: PROC SQL LOOP (Inserting data in an existing table)

Re: PROC SQL LOOP (Inserting data in an existing table)

Macro function to output yesterday's date

Re: Update of Table

Update of Table

Conversion from Character to Numeric (Accounting Numbers)

Re: Time Conversion

Time Conversion

Re: Error in SAS DI

Error in SAS DI

Re: IF-ELSE Condition if a table exists

IF-ELSE Condition if a table exists

Re: Macro function to output yesterday's date

Re: Macro function to output yesterday's date

Macro function to output yesterday's date

Re: IF-ELSE Condition to Perform a Loop

Re: IF-ELSE Condition to Perform a Loop

Re: IF-ELSE Condition to Perform a Loop