BookmarkSubscribeRSS Feed
stataq
Quartz | Level 8

Hello,

 

I have silly question: what does following code try to get?

 

%scan (&_indata,1,%str( %())

it looks like it try to get the 1st segment  of &_indata.. I feel confused on the part of "%str( %()". Could anyone interpretate that for me, especially the part with % and (.

 

Thanks.

 

 

4 REPLIES 4
yabwon
Onyx | Level 15

Maxim#1: Read the documentation

 

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0pnc7p9n4h6g5n16g6js048nhfl.htm

 

yabwon_0-1730215911742.png

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



ballardw
Super User

The third position of the scan and %scan is the list of characters used as delimiters. So someone wanted to set the list characters to include the % sign as well as space and the parentheses as delimiters. Because the macro language uses % as a special character they needed to use the %str() to prevent using that % in the list as a macro trigger.

 

By default %scan would use any of the following as delimiters:blank ! $ % & ( ) * + , - . / ; < ^¦

So one suspects that one or more of those characters were expected to appear in the values and they did not want those others to be treated as delimiters.

Kurt_Bremser
Super User
#STR is used for masking characters which would otherwise be discarded (the blank) or have special meaning in macro language.
Since the opening parenthesis is also needed as a delimiter for %SCAN, it is also put in as an argument for %STR. But the function would treat the two consecutive opening/closing brackets as a pair, which is not wanted; therefore the bracket is masked with % to prevent this. You can find this in https://documentation.sas.com/doc/de/pgmsascdc/9.4_3.5/mcrolref/n09tblrxldh8k0n1kt6dkj3xlxug.htm (the documentation of %STR).
Tom
Super User Tom
Super User

It extracts the dataset name from a macro variable that might hold a dataset name with dataset options.

 

Example:

%let inds=sashelp.class(drop=age);
%let ds_only = %scan(&inds,1,%str( %());

Results

1    %let inds=sashelp.class(drop=age);
2    %let ds_only = %scan(&inds,1,%str( %());
3    %let libname = %upcase(%scan(work.&ds_only,-2,.));
4    %let memname = %upcase(%scan(&ds_only,-1,.));
5    %put &=inds &=ds_only &=libname &=memname;
INDS=sashelp.class(drop=age) DS_ONLY=sashelp.class LIBNAME=SASHELP MEMNAME=CLASS
6
7    %let inds=class;
8    %let ds_only = %scan(&inds,1,%str( %());
9    %let libname = %upcase(%scan(work.&ds_only,-2,.));
10   %let memname = %upcase(%scan(&ds_only,-1,.));
11   %put &=inds &=ds_only &=libname &=memname;
INDS=class DS_ONLY=class LIBNAME=WORK MEMNAME=CLASS

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 738 views
  • 4 likes
  • 5 in conversation