topic Re: run a whole bunch of codes fast and efficiently in SAS Procedures

run a whole bunch of codes fast and efficiently

deleted_user — Tue, 21 Apr 2009 17:51:38 GMT

Hi,

I need your help. I am running many codes for fields such as cpt1 and cpt2 all the way up to cpt6 and I have to run from where cpt1 - cpt6 = (390 - 434) and 436- 459 excluding 401 and 401. I don't want to write many conditional statements so how could I go about capturing all the data. The fields are character such that '390', '391', etc.

Please help.

Thanks.

Re: run a whole bunch of codes fast and efficiently

DanielSantos — Tue, 21 Apr 2009 19:58:46 GMT

Hello rab.

Could you be more specific about what your trying to do, so we could point you the right direction?...

Are you extracting, merging or transforming this data?

Greetings from Portugal.

Daniel Santos at www.cgd.pt.

Re: run a whole bunch of codes fast and efficiently

sbb — Tue, 21 Apr 2009 21:44:03 GMT

Also, it may help to convey "brief" INPUT and OUTPUT data examples and how you would like them to appear. You will want to use COPY/PASTE directly into your forum post reply to explain the objectives and data considerations further.

Scott Barry
SBBWorks, Inc.

Re: run a whole bunch of codes fast and efficiently

Doc_Duke — Wed, 22 Apr 2009 01:17:54 GMT

See Scott Barry's response in

http://support.sas.com/forums/thread.jspa?threadID=5596&tstart=0

The FORMAT approach works very well here.

Doc Muhlbaier
Duke

Re: run a whole bunch of codes fast and efficiently

deleted_user — Thu, 23 Apr 2009 02:01:38 GMT

Data is such that:

cpt1` cpt2 cpt3 cpt4 cpt5 cpt6
390 391 392 396 900 397

but many many codes in each column. I just want to flag once if the any of the cpt1-6 are within the range of (390 - 434) and 436- 459.

I would like frequencies or the number of people having atleast one cpt code within the range.

Thank you.

Re: run a whole bunch of codes fast and efficiently

LinusH — Thu, 23 Apr 2009 06:19:54 GMT

To avoid writing multiple conditional statement, you could use an array approach, and accordingly within a do loop.

/Linus

Re: run a whole bunch of codes fast and efficiently

deleted_user — Thu, 23 Apr 2009 17:32:40 GMT

your right linus,
but I am not good at creating the arrays or do loops, could please provide an example using the variables and fields I have.
Rabiya

Re: run a whole bunch of codes fast and efficiently

sbb — Thu, 23 Apr 2009 18:16:52 GMT

As was mentioned, did you take time to review SAS PROC FORMAT (documentation) in order to code your range values for identifying candidates?

Scott Barry
SBBWorks, Inc.