About rcwright

Tom · ‎03-09-2015

When you select into a macro variable without specifying that it concatenate the results by using the SEPARATED BY clause then PROC SQL will only return the first record. 266 proc sql noprint ; 267 select name into :name trimmed 268 from sashelp.class 269 order by name desc 270 ; 271 %put &=sqlobs &=name ; SQLOBS=1 NAME=William 272 quit;

rcwright · ‎02-19-2015

At the risk of appearing vain, here's a sample I submitted a few years ago - https://communities.sas.com/thread/71369

RCW · ‎09-20-2014

Ahh ... but I did - that's what makes these communities so handy. Learn something new every day. And I've been doing this about 30 years.

EricCai · ‎09-25-2014

Thank you, Ksharp! This was a very useful and fast script! To anybody else who wants to use it, be sure to use category names that are different from any of the indices that Ksharp uses in the arrays. Most notably, don't use i, j or k as category names - he uses them in the arrays, and then he deletes them. Also, thanks to everyone else who pitched in with solutions!

khollid · ‎09-26-2014

I changed my mind. I thought more about what you said about changing the definition. I think it does make sense to include any point that is part of a potential run, but just not double counting the overlap points. So all I need to do is expand the dataset produced by this code to the minute level and then delete the duplicates to yield any point that is part of a run that meets the definition, which I know how to do. Thanks!

jakarman · ‎07-04-2014

Do not focus on the batch processing of excel with via as that is an interactive environment. Interactive is meaning somebody is needing to watch that screen all the time. You are needing a message notification when the job is done? Use a message mail or so. When you can connect authorized to a mail provider this is a normal way being present in lsf and to be coded scripted including the cc (completion code).

rcwright · ‎07-03-2014

Looks like you're trying to redefine a character array to numeric. Try if var=' ' then var='.'; notice the quotes around the period.

rcwright · ‎07-03-2014

Trouble with using the round function is that it can lead to incorrect results, as the following example demonstrates. A better(?) solution for what you want to do is to use the Int() or Intz() function. data r ; input x ; y = round(x,1); z1 = Int(x); z2 = Intz(x); datalines; 5.05 5.50 5.55 ;;;;

rcwright · ‎11-27-2012

Nick and chris: I was somewhat expecting something along these lines - hoping it wasn't so, but knowing deep, deep in my SAS heart I was going to have to get into .net. Not that I haven't done this kind of stuff before - had to simulate a sas and web server onetime using vb and outlook and javascript. Except for having to OK every email that went out to something like 60 managers once a week, it actually worked pretty well. Survived a half dozen federal audits before being contracted out to a team of 12. Don't know that I'm allowed to compile .net stuff or not - we're tied down pretty tight here. Let me look it over, see what's what. Thanks for the lead, RCW

Online Status	Offline
Date Last Visited	‎06-02-2016 01:09 PM

Re: ERROR: Invalid or non-supported file specified.

Re: Assign macro variable value by extracting date from dataset name

Re: Assign macro variable value by extracting date from dataset name

Re: Assign macro variable value by extracting date from dataset name

Re: Create Folders in SAS

Re: how to start the calculation on a column having datetime to identi...

Re: Calculating Epoch end date

Re: Format Catalog 32 bit to 64 bit - any help in SAS 9.4?

Re: How to scan a binary variable for density

Re: How to scan a binary variable for density

Re: Vertical addition

Re: output file

Re: Assign macro variable value by extracting date from dataset name

Re: Create Folders in SAS

Re: output file

Re: Checking whether the value of one variable in a data set exists in...

Re: How to scan a binary variable for density

Re: Message Box like Excel VBA in SAS

Re: Setting variable values to missing for multiple variables

Re: How to remove number after decimal.

Re: Where are the prompts located?