topic Re: re: Scan function in SAS Programming

re: Scan function

twildone — Mon, 15 Jun 2015 14:07:13 GMT

Hi....I would like to be able to select a ID one at a time from a list. Each ID consist of 3 letters followed by a space and 4 digit number. I need to keep this ID in this form. I am assume if I used the scan function, it would consider each ID as 2 separate ID's because of the blank space in between them. Is there a way around this. Thanks,

CME 1199

DLS 1213

WRF 1155

RTY 1345

Re: re: Scan function

Jagadishkatam — Mon, 15 Jun 2015 14:33:09 GMT

Please try

data have;

input text &$ 20.;

cards;

CME 1199

DLS 1213

WRF 1155

RTY1345

;

data want;

set have;

if prxmatch('/\w\w\w\D\S\d+/',text) then flag=1;

run;

Thanks,

Jag

Re: re: Scan function

data_null__ — Mon, 15 Jun 2015 14:42:07 GMT

If your delimited list contains items that contain the delimiter the item must mask the delimiter in some way. Typically this is done by enclosing the item(s) that contain delimiters in quotes.

Re: re: Scan function

sbb — Mon, 15 Jun 2015 14:59:03 GMT

If your list originates from a vertical (separate records) as you have illustrated, then consider using a different item separator character (one that does not appear within any item). So if you are using PROC SQL to generate a macro-variable as your item-list, then choose a different SEPARATED BY data-string value to distinguish items in your list, then use that data-string as your SCAN argument when parsing.

Scott Barry

SBBWorks, Inc.

Re: re: Scan function

PaigeMiller — Mon, 15 Jun 2015 15:01:13 GMT

twildone wrote:

CME 1199

DLS 1213

WRF 1155

RTY 1345

I don't understand the reason why SCAN is suggested here. You don't need SCAN to select from the list. Could you explain further?

Re: re: Scan function

dsbihill — Mon, 15 Jun 2015 15:07:28 GMT

If i understand your question properly this is how i would do it. Im sure there are more elegant ways to do this.

Thanks

data have;

input id $50.;

datalines;

CME 1199 DLS 1213 WRF 1155 RTY 1345

;

run;

data want;

set have;

do i=1 to countw(id) by 2;

sep_id = catx(' ',scan(id,i), scan(id, i+1));

output;

end;

drop id i;

run;

Re: re: Scan function

twildone — Mon, 15 Jun 2015 16:11:42 GMT

Hi...I was using the scan function as part of a macro loop to check to see whether or not the list of ID's had records contained in a larger dataset when the ID was only numerical (example, 1199) Now the ID field has changed to include 3 letters followed by a blank space and now I need to do the same check but now with the 3 letters preceeding the 4 numbers....

PROC SQL NOPRINT;

SELECT DISTINCT ID

INTO :IDLIST1 SEPARATED BY ' '

FROM WORK.ID_LIST;

QUIT;

Re: re: Scan function

Jagadishkatam — Mon, 15 Jun 2015 16:32:09 GMT

since you are trying to search the id which have 3 letters followed by space and 4 digits. please try

PROC SQL NOPRINT;

SELECT DISTINCT ID

INTO :IDLIST1 SEPARATED BY ' '

FROM WORK.ID_LIST where prxmatch('/\w\w\w\D\S\d\d\d/',text)>0;

QUIT;

Thanks,

Jag

Re: re: Scan function

data_null__ — Mon, 15 Jun 2015 16:33:43 GMT

Why use macro at all?. Just get the distinct ID list and do the test using SQL or data step. Doing an operation on records from a SAS data set is much easier than fiddling with scan the values of a macro variable.

Re: re: Scan function

dsbihill — Mon, 15 Jun 2015 16:38:48 GMT

If you are trying to handle both situations of 3 letters and no letters why not change your above code to something like this

PROC SQL NOPRINT;

SELECT DISTINCT ID

INTO :IDLIST1 SEPARATED BY ','

FROM have;

QUIT;

and then use on the macro side

%scan(&idlist1, i, ',')

Re: re: Scan function

Tom — Mon, 15 Jun 2015 17:34:01 GMT

Use a delimiter that is not part of the data. For example |.

The third parameter to the SCAN() or %SCAN() function is the delimiter value.

.... separated by '|' ....

... %scan(&idlist,&i,|) ...