ACCESS SQL program into SAS code I am working on rewriting the Access SQL code into a SAS program and having difficulty. (The dataset is too large for Access.) I was thinking the SAS code needed to be written from inside out. My joins are not working properly though. Any help would be much appreciated. Thank you, June Below is the Access SQ... 8 Mar 2010 11:55
new joinee welcome and have a look at our sas community wiki http://www.sascommunity.org/wiki/Category:SAS-L -----Original Message----- From: owner-sas-l(a)listserv.uga.edu [mailto:owner-sas- l(a)listserv.uga.edu] On Behalf Of sasbond1981 sasbond1981 Sent: Saturday, March 06, 2010 7:30 PM To: SAS-L(a)LISTSERV.UGA.ED... 9 Mar 2010 11:10
Pass a variable as a macro parameter. Hi there, I was wondering if anyone could help me with the following. Imagine I have a simple macro that does some text manipulation e.g. %macro myMacro(strInput); %let strInput2 = &strInput &strInput; &strInput2 %mend; Now, I'd like to use this macro in a data _null_ step and pass a string vari... 8 Mar 2010 09:40
Pass a variable as a macro parameter. Hi JS, If you goal is to double a string value using a macro it might be: %macro myMacro(strInput); TRIM(&strInput) || TRIM(&strInput) /* no semicolon */ %mend; data _null_; LENGTH myString2 $ 32; * reserve enough value space in advance; myString='This is a string'; myString2=%myMacro(mySt... 8 Mar 2010 23:08
Annotated Graph Problem Richard D, Just a quick note. I've been absent from the SAS-L list for a long time. = I still only scan the list in Digest Mode in a hit-or-miss nature. But, I = do tend to focus on a posts from a few folks from whom I know I'll always l= earn a few things. I saw your quick recent post and said to myself: "Hmm... 8 Mar 2010 09:40
Can I make some block of my program in SAS 9.2 editor using Lee, Is there a chance that you are bringing up the editor rather than the enhanced editor? I just looked at the 9.2 documentation and the keyboard shortcuts appear to be the same as 9.1.3. See, e.g.,: http://support.sas.com/documentation/cdl/en/hostwin/61924/HTML/default/awskeys.htm http://support.sas.com/d... 8 Mar 2010 13:02
Can I make some block of my program in SAS 9.2 editor using keyboard? Hello, I remerber that I can select some part of codes in SAS 9.1.3 editor using keyboard(SHIFT+direction key or PGUP PGDN etc.) But I can not do same thing in SAS 9.2 editor(esp. windows7 ultimate). Now I have to use draggin mouse instead of using keyboard. Do anybody know the solution for my problem? Regard... 8 Mar 2010 06:24
Monte Carlo simulation in SAS - extreme outliers Hi, I am running Monte Carlo simulation in SAS within the procedure proc model. While the simulations look reasonable overall, I see some extreme outliers in the tails of the distributions, more extreme than I would have expected in the tail. Is this a problem that is that is more often seen with SAS? If so, ho... 8 Mar 2010 10:48
Work at Home - Earn 20,000 Weekly Without Investment Its Not A Fake, 100% Earning Guarantee Work at Home - Earn 20,000 Weekly Without Investment Its Not A Fake, 100% Earning Guarantee for start earning click here http://www.tkqlhce.com/click-3823529-10751048 http://www.tkqlhce.com/click-3823529-10751048 http://www.tkqlhce.com/click-3823529-10751048 http://www.tkqlhce.com/click-3823529-10751048 ... 8 Mar 2010 02:06
removing more than two variables from regression model Hello , Could you please suggest me the syntax for the " WHERE ne " if I need to remove more than two varaibles. The code :- where Review ne 50 ,Review ne 40 AND Review ne 5; for example doenot work.The problem is how do i remove three observations with different ranges. kind regards, markc ... 8 Mar 2010 15:16 |