Problem accessing SYBASE data017 (8/24/2009 4:00:29 PM) comp.soft-sys.sas Hi everyone, We have a SYBASE database with extension .db. We do not know the table names. We used a libname statement with SYBASE as engine, but we get an error message sayng: "The SAS/ACCESSS Interface to... foa2
Re: Title break026 (11/11/2008 4:03:17 PM) comp.soft-sys.sas One alternative is to use Title2 statement. Here's an illustration. Title1 "This is the first half"; Title2 "this is the second half";; At 10:55 AM 11/11/2008, Ran S wrote: >How can I break title so that it... foa2
Re: figuring out repeated data #2124 (10/14/2008 7:38:18 PM) comp.soft-sys.sas how about transposing the merged data. like this one (or something similar). data temp; set a1 a2 a3; run; proc sort data = temp out = need; by n; run; proc transpose data = need out = need1; by n;... foa2
Re: problem with sysdate and today()016 (10/14/2008 4:30:35 PM) comp.soft-sys.sas I was able to recreate your problem. Check the date of your computer. When I reset the year to 1993, I got the same result as yours. Maybe your calendar date was somehow reset to year 1993. 1 %Put &sysd... foa2
Re: help with macro!024 (9/18/2008 4:11:16 AM) comp.soft-sys.sas you need to invoke this macro inside a data step. you probably just need a %let varname = lbw statement here rather than a macro definition At 11:19 PM 9/17/2008, tyralynn Frazier wrote: >I for the life of m... foa2
Re: Creating one response from check all apply variables #3025 (4/6/2008 9:25:47 PM) comp.soft-sys.sas Not sure whether your variables are numeric or string. so here's a sample using both types. data have; infile cards; input hypertension pain tightness hypertension_str $ pain_str $ tightness_str $; response =... foa2
Re: How to print today's date in a SAS title #2119 (3/25/2008 6:29:34 PM) comp.soft-sys.sas This one. Title "The date today is %sysfunc(today(), mmddyy10.)"; HTH, Florio At 02:12 PM 3/25/2008, A.B. wrote: >Is there a easy way to do that? > >Thanks! >-- >A.B. ... foa2
Re: sas #10029 (3/20/2008 8:18:07 PM) comp.soft-sys.sas Sasanka, just add a KEEP option in your output dataset and specify the variables that you want to keep in there. you need to run the procedure without the KEEP option first so that you'll know which variables... foa2
Re: SAS Day-Time Conversion Question015 (11/7/2007 5:43:25 PM) comp.soft-sys.sas Hi data_null_; Thanks for confirming my suspicion. And Thank You for the DHMS and the TIME10 format combo. The result of this combination is exactly what I wanted in the end. Best regards, Florio At 12:... foa2
SAS Day-Time Conversion Question014 (11/7/2007 4:42:03 PM) comp.soft-sys.sas Hi Everyone, Do you know of a way to convert a time value that is in the following format: 2d 06:30:20 03:02:35 36d 20:34:26 to a SAS time value? I've been combing the documentation and I've found lo... foa2
A scan function question317 (1/22/2009 9:21:37 PM) comp.soft-sys.sas I have the following variable (date) as below: Date ----- 25Dec2006 02Jan2009 15Feb2009 18Nov2004 Now if I want to get only the day fom the above values and want those values to a new varibale (Day) as below:... need_sas_help(102)
changing regressors113 (10/2/2007 2:49:46 PM) comp.soft-sys.sas My data set is a panel data set with variables including u1, u2, u3, u4 etc. and some extra non-dummies. I am using a macro and want to create a loop where it will run the regression multiple times as: proc r... Jsprite
set question430 (8/16/2007 12:54:54 PM) comp.soft-sys.sas hi everyone, here is my problem. I have several datasets having the same name's beginning. In my case, it's final_app. As those data sets have been created with loops, their name are : final_app11 final_app1... kid20100(13)
to_char in SAS6258 (8/7/2007 1:53:47 PM) comp.soft-sys.sas Hi Fellow SAS users, I'm trying to get the week number from a transaction date which has the dd-mm-yyy format. In SQL I would have used the code below: to_char(transaction_date,'ww') as week but this code w... qotsa79(21)
Cumulative sum with resets?333 (6/2/2007 12:17:50 AM) comp.soft-sys.sas Hi everyone, I'm trying to create a cumulative sum, though one that resets itself after a particular value of another variable is met. To be more specific, I have one column of values, that, when sorted appro... ajahansouz(4)
Help please-Lag function636 (5/21/2007 2:21:52 PM) comp.soft-sys.sas I have a panel dataset (firm-years) and want to create the first, second, third and fourth lags of variable x.However, there are two problems. First there are missing years in between and therefore the second, ... free562james(19)
SAS and 64 bit Win118 (5/16/2007 5:00:01 PM) comp.soft-sys.sas SAS-L, My company is considering an upgrade of our SAS server. Could someone explain to me the pros and cons of moving to a 64 bit Win OS instead of 32 bit? Does SAS 9 have a 64 bit version for Win? Thanks!... ACavallo1(18)
dealing with library name?1628 (5/14/2007 6:00:47 AM) comp.soft-sys.sas Hi, When I use dataset variables in sql, how can I avoid the library name problem shown below? 173 %let out_ds = test; 174 %let in_ds = final; 175 176 proc sql; 177 create table &out_ds as 178 select... celiacai(28)
Simple Output & Summarizing424 (5/7/2007 2:06:59 PM) comp.soft-sys.sas My summarizing skills in SAS are atrocious. I need to go from this: STCOU LOC_CODES 01011 A90 01011 A4H 01011 AP9 01011 Z90 02011 Z78 02011 ZA7 02011 Z99 03011 A09 03011 A0J 03011 Z45 030... junkdalejreyes(17)