SAS
in [Software]
|
Proc IML: how to delete a row in a matrix depending on values in the first column? Hi, I have seen a lot of examples for deleting or removing within proc IML, but I doesn't work for my specific case. Say there is a m x n matrix named "temp". I want to remove (in a loop) a row i of the matrix when the cell temp[i,1] complies to some statement. For example: do i=1 to m; if temp[i,1]<0 th... 23 Mar 2010 04:31
how to filter observations Hi All, I am having difficulty in figuring out how to filter observations in sas. I need to look at observations while excluding others in the same row...As such, I cannot delete the row...Is there any command for filtering. I used to do this in spss. Here is an example of how the dataset looks: ID event1 ... 24 Mar 2010 09:59
Multilevel Analysis SAS code..HELP needed Hi there, This is the first time am trying to use sas and need some help doing my Multi level analysis. I usually use SPSS and other statistics software to do my analysis. It will be great if i can get some help doing some coding. The problem is defined below. My boss is being a pain and wants me to use SAS. ... 24 Mar 2010 09:59
An unsuccessful attempt to parse the SAS logfile for a WARNING-message Hi, I am a bit confused why I get an empty dataset of SASLOG_EXTRACT below. The code can be pasted into the editor and submitted. data _null_; %global mvar_timestamp; day = date(); time = time(); sasdt = dhms(day, 0, 0, time); length chardate $10.; chardate = put(day, yymmdd10.); ... 23 Mar 2010 07:50
univariate default tables hi everyone, i'm just wondering if there's a way to turn off the univariate default tables. right now i'm only interested in using the output from the proc. cheers, dave ... 23 Mar 2010 07:50
Web Report Studio Using OLAP Year over Year calculation I currently have a calculated member in an OLAP cube to calculate Year over Year differences (code below). (([CUBE].[Revenue],[Fiscal_Year].CurrentMember) - ([CUBE].[Revenue],[Fiscal_Year].CurrentMember.PrevMember)), FORMAT_STRING="DOLLAR15." When I display this calculated member in WRS, I get unexpected res... 22 Mar 2010 13:04
Date Conversion All: I have a variable aestdt with these values and the they are in character format .. I want to convert them to date9. Format to perform some days calculation .. how can it be achieved ?? I have tried x = input(aestdt,date9.) Aestdt 26 JAN 2009 1 FEB 2009 UN JAN 2010 UN DEC 09 11 MAR 2010 Thanks ... 22 Mar 2010 13:04
Masking special characters in text string Hi, I want to assign a variable a text string, which contains a %. Then use call execute to call the macro. When doing it like this : runmac = compress("%tst(" || svar || ")"); call execute(runmac); the macro is invoked before the call execute statement. The only way how to get around this, that I ... 22 Mar 2010 14:13
Unable to sort dataset with 6.7 Million records. ERROR: Utility file write failed. Probable disk full condition. Hi Amar, If it's not because of your disk space, try to place temporary the OPTION NOTHREADS ; line before your sort proc. Reactivate this option after. Regards. Jerome. On Mar 22, 6:29 am, Amar Mundankar <amarmundan...(a)gmail.com> wrote: Hi all, Below is the code, I am trying to run. proc s... 22 Mar 2010 09:22
PLEASE HELP...........problem in Merge ... On Mar 22, 4:49 am, Amar Mundankar <amarmundan...(a)gmail.com> wrote: Hi all, The input dataset is as follows: data sample; input id a b c; cards; 2 11 . . 2 . 44 . 2 . . 66 1 55 . . 1 . . 99 1 . 22 . ; I want the output as id a b c 2 11 44 66 1 55 22 99 ... 24 Mar 2010 04:23 |