SAS
in [Software]
|
WITH (NOLOCK) in Proc SQL Hi, is there a Proc SQL version of WITH (NOLOCK)? I.e., I was given this T-SQL query (which, strange enough, seems to work only when using WITH (NOLOCK) ): SELECT T1.*, T2.*, T3.* FROM T1 WITH (NOLOCK) INNER JOIN T2 WITH (NOLOCK) ON T1.x = T2.x INNER JOIN T3 WITH (NOLOCK) ... 21 May 2010 12:48
Reading a high value from a series of variables I am creating a new variable in a sas dataset and I want to populate that field with the highest value from 9 other variables within the same record. What would be the best way to approach this problem? An array, a macro? Any suggestions/code examples would be greatly appreciated. Thanks. ... 20 May 2010 17:12
Read formats into Dataset Hi- I'm trying to create a data dictionary for my dataset and willing to read all the values for each format from the library into a dataset so that I can export the same into Excel. Any help is greatly appreciated. Eddie/ ... 20 May 2010 21:35
Issues with power analysis using PROC MIXED (long) Greetings! (Sorr this is long...) We are designing a longitudinal study, and have the luxury of some pilot data available to us for planning purposes. The pilot data suggest that there is an important effect of the predictor (x) on the outcome (y). I decided to use some of the methodology described in chapte... 22 May 2010 07:16
Siebel Business Analyst -- Michigan - 10 Months Contract (Please note: If you are interested in this position and you have all skills experience which mentioned in requirement, so please update your resume as per the requirement and reply me at matt(a)netprologic.com/ matt at netprologic dot com) Hi, Hope you are doing well, Please find this Requirement of our Dire... 20 May 2010 12:46
SAS on iMAC/MacPro Hi everyone. May I please ask what are the minimum requirement to be able to run SAS on iMac/MacPro? Thanks in advance! Have a great day! ... 20 May 2010 11:39
Data Structure Using Proc Transpose Hi All: This is the problem I am running in to when I try flipping the data using Proc transpose data work.have; infile datalines truncover; input pat vis res; datalines; 1 1 12 1 1.1 13 1 1.2 12 1 2 11 1 11.2 23 2 1 09 2 2 14 2 ... 19 May 2010 20:30
Calculate Percent using proc report proc sql; create table new_file as select code, A , B1, B2 from myfile; quit;run; I have the following dataset and need to create a report with a percentage to be calculated in. For some reason, the calcualted field new_field all showed up as missing value, can someone tell me what may cause this? Tha... 19 May 2010 13:47
PAY PER CLICK PAY PER CLICK --------------------- http://sites.google.com/site/payperclickaffiliatesearn/ *** http://sites.google.com/site/medicalmalpracticelawmichigan/ *** http://sites.google.com/site/onlineinsurancequotesapply/ *** http://sites.google.com/site/laptopdatarecoverysoftware/ *** http://sites.google.com/site... 19 May 2010 02:50
Retain statement code wont work for variable name containing an underscore? Hello: I've just noticed something which to me is puzzling.Since the underscore character is a legal character for variables names, I use it often. I've never had any issues before this week when some code I was using stopped working for no explainable reason. /*This code works. The variables are updated appro... 20 May 2010 12:46 |