Date:18.05.2016, 11:28 Houses; 5 6 put style sqfeet; CONDO 900 You can use the TRIMMED option to remove leading and trailing blanks from values that are stored in a single macro variable. proc sql noprint; select distinct style, sqfeet into :s1. The following example illustrates the concept: Let us create a table named CUSTOMERS : ( For SQL statements please look at the SQL tutorial ) CREATE TABLE CUSTOMERS ( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE. Houses; 8 9 put style1 sqfeet; CONDO 900, 1000, 1200, 1400, 1600, 1800, 2100, 3000, 1940, 1860 10 put style2 sqfeet; CONDO 900, 1000, 1200, 1400, 1600, 1800, 2100, 3000, 1940, 1860 11 put style3 sqfeet; RANCH 900, 1000. SEPARATED BY 'character' specifies a character that separates the values of the rows. TRIMMED trims the leading and trailing blanks from values that are stored in a single macro variable. Details Use the INTO clause only in the outer. Put_line Value of c: ' c f : ; dbms_output. put_line Value of f: ' f END; / When the above code is executed, it produces the following result: Value of c: 30 Value of f: 23.
InSync runs as a convenient System Tray icon. You can set set daily, weekly, monthly, or yearly alarms, which can optionally be set to be recurring. License: Shareware Platform: Windows File Size: 975.0 KB Publisher: Red Point Web: p Download Blank.