SAS

how can i translate subquery(SQL) to Datastep
HI all.. i'm kinda newbie to use data step and really i'm not used to using it.. so i always use SQL but i think it's not good at all.. I have simple SQL below create table have as select * from [data_set_name] where trln_nm in (select dmdp_c from [data_set_name]... 11 Aug 2010 22:28

Data input format help
Dear all: I have this data from an different program in a weird format I am trying to input into SAS with not much headway. They are residuals for a model for a single ID (for 17 longitudinal data points). RESIDUALS -0.78481435 -0.24617084 -0.60821292 -1.60354228 -0.22145727 1.1... 10 Aug 2010 22:26

PROC REPORT / Highlighting not working ? :-(
correction... I meant to say I want to change the background of the entire row and not a cell. Thanks lee ... 11 Aug 2010 14:44

PROC REPORT / how can I move a table down a few lines and not move the others?
Sorry.. another question... How can I move a table down a few lines. If I use the title command it affects the other reports and I only want the one report (1 of 3) to move down. Thanks Lee ... 10 Aug 2010 11:21

proc report / my image in on top of my table?
Hi Lee.. Try this..hope this helps... ods escapechar ="^"; title j=left "^S={PREIMAGE='path\logo.jpg'}" Thanks shiva ... 10 Aug 2010 09:05

datetime informat
Simple question. String: 14/9/2007 11:25:59 What's the correct informat for such a string? I just can't get it to work right, and end up scanning off the date and time to do separately. But I'm well aware that there is an informat for pretty much everything... Thanks. ... 11 Aug 2010 19:08

Need help--Cross Table
I have a problem about cross table. The following is a data example. Type($) original_data(8.) modified_data(8.) A 0.32 0.45 B 0.62 0.70 .... .... There are 3 columns, and original_data and modified_data are between 0~1. I want to produce the fo... 10 Aug 2010 11:21

How to get contional observation?
data example: obs type date id time number index 1 B11 20030303 1301 900 1 2 B12 20030303 1301 900 2 3 B12 20030303 1301 902 1 4 B12 20030303 1301 904 1 5 B11 20030303 1301 ... 9 Aug 2010 16:48

Estimating the value for the functional form of the variance
Hi all, I am trying to run a ARMA+GARCH model for modeling the wind speed and my code is follows; - - -------------------------------------------------------------------------------------------------------------------------------------------------- proc model data = Erman; parms ar1 ar2 ma1 ma2 ma3 mu ... 9 Aug 2010 00:21

Struggling to resolve an important data problem in SAS....please help.
On Sun, 8 Aug 2010 06:56:54 -0700 (PDT), Tom Abernathy <tom.abernathy(a)gmail.com> wrote: If you have want to get the last one as another character variable then use the SCAN function. last_date = scan(date,-1,'>'); You probably want scan(date, -1, '->'). If you want to convert it to an actual date ... 8 Aug 2010 18:55