About crashz204

crashz204 · ‎07-11-2019

I have a table created in SAS with a list of values. I have a secondary table that I caluclated values on based on table 1. I am wanting to update table 1 with the calculated values from table 2. I use the following code. PROC SQL; update TEST_MAIN set (value_1) = (select calc1 from CR_CALC) where FIELD= 'CR'; RUN; This updated the VALUE_1 field with the data i need. however, I have multiple fields to update so I used this example: PROC SQL; update TEST_MAIN set (value_1, value2) = (select calc1. calc2 from CR_CALC) where FIELD= 'CR'; RUN; I get this error: _ 22 76 ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored. I'm not sure what the error is. I used this in SQL syntax all the time without issue. Thank You!

crashz204 · ‎06-18-2019

Thank You, this worked great!

crashz204 · ‎06-17-2019

In my code I am trying to use the passthrough to Teradata with SAS to automate a report. This automation i have defined dates. in my Proc SQL using the Teradata passthrough i refer to the CW_START and CW_END dates for a weekly report. However this doesnt work in the passthrough even though I formatted the dates as YYMMDD10. Not sure what I am doing incorrectly here so any pointers would help immensely. Thank you! Data DATES; Format CW_START CW_END REPORTDATE CURR_REPT_DATE YYMMDD10.; REPORTDATE = today()-1; CURR_REPT_DATE = today(); CW_START = intnx('Week.4',ReportDate,0,'B'); CW_END = intnx('Week.4',ReportDate,0,'E'); Call Symput('REPORTDATE',REPORTDATE); Call Symput('CW_START',CW_START); Call Symput('CW_END',CW_END); Call Symput('CURR_REPT_DATE',CURR_REPT_DATE); run;

Online Status	Offline
Date Last Visited	‎07-16-2019 04:50 PM

Proc SQL Update Multiple values

Re: Teradata Passthrough Code for Date formats

Teradata Passthrough Code for Date formats

Re: Teradata Passthrough Code for Date formats

Proc SQL Update Multiple values

Re: Teradata Passthrough Code for Date formats

Teradata Passthrough Code for Date formats