topic Re: SAS Scan in SAS Programming

SAS Scan

jhh197 — Fri, 20 Oct 2017 03:45:40 GMT

Hi,

I have a macro &u = 6,22,5

1.) How do I detect from macro u where there is a comma %if scan(&x,',') > 0 will this work ?

2.) How do I count the number of words from the string u ( Answer should be )

3.) How do I extract 6 from string u and 22 from string u and assign that to macro variable and 5 from string u and assign it to macro variable

Please Can anyone help

Thanks

Re: SAS Scan

Reeza — Fri, 20 Oct 2017 03:57:46 GMT

1. It's not clear what you want here

2. COUNTW/COUNT

3. %SCAN or SCAN

Re: SAS Scan

jhh197 — Fri, 20 Oct 2017 04:03:11 GMT

I have macro variable

%let u = 6,22,5

I want a macro code to check whether comma exists in the macro u if yes then I want a syntax to count macro u ( Answer should be 3 in above case )

next I want syntax to extract 6 into one macro

22 into one macro

5 into one macro variable

Thank you

Re: SAS Scan

Reeza — Fri, 20 Oct 2017 04:08:43 GMT

I would use FIND or INDEX personally to see if there's a comma.

If you're having trouble with that feel free to post your code and log.

Re: SAS Scan

jhh197 — Fri, 20 Oct 2017 04:22:45 GMT

Yes
I used %let x = index(&u, ',');
% put &x but it's not resolved
Error :the quoted string currently being processed became more than 262 characters long . The string might have unbalanced quotation marks quotation

For count I tried
% let h = %sysfunc(countw(&x,','));
%put &h;

Re: SAS Scan

jhh197 — Fri, 20 Oct 2017 04:25:00 GMT

Sorry I used this macro for count

%let h= %sysfunc(countw(&u,','));
%put &h;

Re: SAS Scan

Reeza — Fri, 20 Oct 2017 04:38:13 GMT

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p1n2i0ewaj1zian1ria5579z1zjh.htm&docsetVersion=9.4&locale=en

Re: SAS Scan

RW9 — Fri, 20 Oct 2017 08:39:46 GMT

Why not, as a way out there thought, use Base SAS for processing your data?

data _null_;
  comma=ifc(index("&x.",",")>0,"Y","N");
  call symput('commayn',comma);
  call symput(countw("&x.",",");
  do i=1 to countw("&x.",",");
    call symput('newm'||strip(put(i,best.)),scan("&x.",i,","));
  end;
run;

To be honest its rarely a good idea to have lists of items in macro variables, or be processing these lists in such a way - your code will become overly complex and hard to maintain with no real benefit. Put data in datasets and use Base SAS to manipulate it - macro is for creating generically derived Base SAS code, not for data processing.

Re: SAS Scan

Shmuel — Fri, 20 Oct 2017 08:54:09 GMT

I did not find any way to use macro functions, to resolve your issue, that is - dealing with a list of values separated by comma.

You can either use a list of values separated by a blank/space and use method quoted by @Reeza

or you can use sas datastep to do it:

%let u = 6,22,5;

%macro test;
    data _NULL_;
        comma_position = index("&u",',');
        count = countw("&u");
        call symput('Comma_Position',left(comma_position));
        call symput('Count',strip(count));
   run;
   %put First Comma is in position &comma_position;
   %put The list {&u} contains &count Members;
%mend test;
%test;

Re: SAS Scan

data_null__ — Fri, 20 Oct 2017 14:37:18 GMT

@jhh197 wrote:

Hi,

I have a macro &u = 6,22,5

1.) How do I detect from macro u where there is a comma %if scan(&x,',') > 0 will this work ?

2.) How do I count the number of words from the string u ( Answer should be )

3.) How do I extract 6 from string u and 22 from string u and assign that to macro variable and 5 from string u and assign it to macro variable

Please Can anyone help

Thanks

You need to quote the commas in your string so they don't cause trouble.

32         %macro splitstring(arg);
33            %local i w;
34            %do i = 1 %to %sysfunc(countw(%superQ(u),%str(,)));
35               %local w&i;
36               %let w&i = %scan(%superq(u),&i);
37               %end;
38            %let i = %eval(&i-1);
39            %put _local_;
40            %mend;
41         %splitstring(%bquote(&u));
SPLITSTRING ARG 6225
SPLITSTRING I 3
SPLITSTRING W 
SPLITSTRING W1 6
SPLITSTRING W2 22
SPLITSTRING W3 5
42         %splitstring((&u));
SPLITSTRING ARG (6,22,5)
SPLITSTRING I 3
SPLITSTRING W 
SPLITSTRING W1 6
SPLITSTRING W2 22
SPLITSTRING W3 5

Re: SAS Scan

jhh197 — Fri, 20 Oct 2017 14:26:19 GMT

Hi ,

Thank you this worked for detecting comma position and counting the arguments

Thank you 🙂

Re: SAS Scan

jhh197 — Fri, 20 Oct 2017 14:33:38 GMT

This also helped Thank you so much for quick response

Thank you 🙂

Re: SAS Scan

data_null__ — Fri, 20 Oct 2017 14:36:21 GMT

@jhh197 wrote:

This also helped Thank you so much for quick response

Thank you 🙂

It also creates enumerated macro variables with values of each word.