SAS
in [Software]
|
between-and operator I know for numeric values, you can specify condition like, between 100 and 1000; in SQL , you can use character , such as between '120.0' and '120.9'; Is there any way to do that in SAS which will be very useful? I am asking this, because for ICD9 code, some diseases are defined as 560.3-560.9, there are also some... 29 Mar 2010 12:28
Answer Needed 1. HOW TO INCREASE FONT IN REPORT WINDOW? 2. DIFFERENCE BETWEEN @ AND @@; 3. DATA P; INPUT X Y Z; CARDS ; 1 7 8 7 5 2 5 2 7 HOW TO REPLACE 7 WITH 999 WITHOUT IF CONDITION? 4. DIF BETWEEN COMPRESS FUNCTION IN BASESAS AND SQL; 5. HOW TO DO COLUMN WISE SUM USING DATA ... 29 Mar 2010 09:07
How to loop the argument of a macro Hi, How do I run a loop say %calculatetemperature(argument=), on a list of 100 arguments: 1975 1988 1930 1999 ..... So that in essence I invoke the macro 100 times ,each time with a different input argument. --- news://freenews.netfront.net/ - complaints: news(a)netfront.net --- ... 29 Mar 2010 02:35
What is the option in Macro to display ERROR message if macro variable is not Resolved Hi all, The code is : options sgen; %let one = two; %let two = three; %let three = four; %let four = last; %put &&&&&last; Output is : 357 %put &&&&&last; SYMBOLGEN: && resolves to &. SYMBOLGEN: && resolves to &. SYMBOLGEN: && resolves to &. SYMBOLGEN: && resolves to &. WARNING: Apparent symbo... 1 Apr 2010 01:26
PROC EXPAND Does anyone know how to use PROC EXPAND without it dropping an observation when there is only 1 "usable input observation" per by group? I'm using PROC EXPAND to lag fields and want it to function similar to a left join. Thanks. ... 30 Mar 2010 07:13
SGF 2010 Proceedings Available Just in time for your weekend coffee...enjoy! http://support.sas.com/resources/papers/proceedings10/TOC.html ... 30 Mar 2010 08:18
Current title Hi all -- Does anyone know if there is any way to save the current title in a macro variable? eg. to allow smth like this: %macro printsomething(x); %let oldtitle=¤ttitle; title "&x"; * ... print something... ; title "&oldtitle"; %mend; Thanks!! ... 27 Mar 2010 16:31
Getting the outcome of a system command into SAS macro variable? I know that in Unix I can use FILENAME PIPE command then use DATA STEP to read in results of a system command. For example, filename abc PIPE "ls -al"; data work.xyz; infile abc; input ...; call symput...; ; However, is there an elegant way to assign an one-line outcome of an Unix command into ... 29 Mar 2010 06:56
PROC COMPARE checking unique records irrespective of position If I have two datasets, each having one variable and all observations being unique. only that one has more observations than the other. one two var1 var2 ABC ABC AAA AAA CCC CCC ACX XYZ XYZ ZZZ ZZZ Because of t... 26 Mar 2010 19:11
Scatterplot matrix from ODS in PROC CORR Hi there, I'm trying to generate a scatterplot matrix using ODS in Proc Corr. Works fine except that not all the variables appear in the matrix. It seems capped at 5X5 when it should appear as a 9X9 matrix. From the code below the scatterplot matrix that is generated by ODS includes only (a_GLUCOSE_0, c_AMYLOID,... 26 Mar 2010 13:09 |