SAS

Safe way to test if a date is valid ?
I test this, and it seems to work: data _null_; a='25MAY2OO6'; d=input(a,date.); c=translate(a,'---------- ****************************************************','0123456789ABCDEFGHIJK LMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'); put a d date. ' ' c; if c in ('--***----','--***--') and ^missing(input(a,date.))... 19 Jan 2007 16:19

Which to use, SAS or SUDAAN?
Hello, SAS's survey procedures (proc surveyfreq and proc surveylogistic) can pretty much accomplish the same tasks that were used to be done by SUDAAN (proc crosstab and proc rlogist). When comparing the results, you may find they provide the same point estimates, but slightly different standard errors. SUDAAN ... 15 Jan 2007 03:40

clear the libref after calling a stored macro
use the code : libname dummy clear; thanks sai kumar Excimer_Gong wrote: Hi,=20 I'd like to clear the libref after calling a stored macro.=20 It always said the library is still in use. Can anyone know how to do? 1 libname Dummy "C:\SAS Library\Dummy" access=3Dreadonly; NOTE: Li... 8 Jan 2007 12:17

proc surveyselect problem
Jack, I may not have a clear understand of what you are asking or of what you are attempting to do, but it looks like SAS is working exactly as designed here. Looking at the code you submitted, you are requesting that SAS perform a stratified (on ClientID) simple random sample of size 1 without replacement fr... 4 Jan 2007 03:20

retaining
hi all , i want to retained FIRST non-missing values. e.g. ORIGINAL DATASET ID DATE 1 20051018 1 20051213 2 2 20060502 2 20060627 I want it like this: REQUIRED ID DATE NEW_DATE 1 20051018 20051018 1 20051213 20051018 2 20060502 2 20060502 20... 3 Jan 2007 00:17

SAS message Log: Generic critical error.
Dear All, =0D Whenever I am trying to run a particular macro it gets interrupted and displays a pop-up 'SAS Message Log' window with following message: =0D ERROR: Generic critical error. ERROR: Read Access Violation In Task ( DMS Process ] Exception occurred at (676A64FC) Task Traceback ERROR:... 1 Jan 2007 00:14

Hash Table Memory Usage
Hi, I've got a large dataset (350,000,000 records) containing transactions, from which I want to select a subset of around 250,000,000 records and then dedupe on id, place and date, which takes it down to around 15,000,000 records. It's (just, given memory constraints) possible to do this using a simple proc sort ... 29 Dec 2006 11:41

How to supply macro value to macro in proc sql
Guys I am doing something like this for my table, I was under the impression that all the macros generated nature is Character then why is this I am getting an error could anybody can explain it. 87 proc sql noprint; 88 select count(itt) into : total 89 from d_header ; 90 select '(N='!!&total!!'... 22 Dec 2006 13:11

installing SAS - MS runtime components error
HI, I'm trying to install SAS v9.1, however, I cannot update microsoft runtime components 7.0. I've checked whether some of the .dll files (see below) are read only, but none are, so that can't be the problem.Any suggestions? Thanks. Raoul Atl70.dll (Unicode) 7.0.9466.0 All versions Mfc70.dll 7.0.9466.0 Al... 27 Dec 2006 09:30

Error on Object Spawner:
Hi Guys, I am having problems with the object spawner service, It was configured to start automatically and it was working very fine, but with a small change on the configuration, set the METAAUTOINIT parameter on options in the logical workspace server.in order to this change to work the object spawner must be ... 20 Dec 2006 14:31