cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PrakashBashyam
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Issue in using CALCULATED VARIABLE in proc update SET statement

by Calcite | Level 5 in SAS Programming
‎04-30-2015 02:32 PM
‎04-30-2015 02:32 PM
it perfectly works. But would like to understand whats wrong in using CALCUALTED variable like that ... View more

Re: Issue in using CALCULATED VARIABLE in proc update SET statement

by Calcite | Level 5 in SAS Programming
‎04-30-2015 01:30 PM
‎04-30-2015 01:30 PM
Sorry, I am not getting your questions L_* are columns of the table Work.Sim_re_BERM. Setting L9BE_C based on calculation max(0,L9_C*(L9BE/L9)) And L9RM_C based difference between L9_C on CALCUALTED L9BE_C. ... View more

Issue in using CALCULATED VARIABLE in proc update SET statement

by Calcite | Level 5 in SAS Programming
‎04-30-2015 12:29 PM
‎04-30-2015 12:29 PM
Hi I m using below query proc sql; update Work.Sim_re_BERM set L9BE_C=max(0,L9_C*(L9BE/L9)), L9RM_C=L9_C - calculated L9BE_C; Quit; This is throwing an ERROR: The illegal use of a CALCULATED variable has been detected in an UPDATE statement. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Quick links