LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2005, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 3 Feb 2005 15:39:35 -0500
Reply-To:   "Worlund, Max" <ZQY3@CDC.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Worlund, Max" <ZQY3@CDC.GOV>
Subject:   Assignment Statement (variable and value creation) with SQL?
Content-Type:   text/plain; charset="us-ascii"

Is there anyway in SQL to do an assignment statement to create a variable and its value on the fly, like there is in SAS? Specifically, I need to query 3 tables and create a column in a 4th table that I am creating where the column in the 4th will be: Table_Source_Name = 'Name of table where data originated' The 4th table will contain rows of data from the other 3 source tables. Of course this is way too easy in SAS, but my hands are tied here and I can only use SQL. Thanks!

Max A. Worlund

CDC Information Technology Support Contract (CITS)

Software Engineer III

NCHSTP/SDMB

Phone: 404.639.4802

Fax: 404.639.8642

email: zqy3@cdc.gov

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu