BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SAS_inquisitive
Lapis Lazuli | Level 10

Hello,

 

I wonder why this does not add double quotes to name string.

 

data _null_;
  set sashelp.class;
  put name;
run;

data _null_;
  set sashelp.class;
  put "||name||";
run;
1 ACCEPTED SOLUTION

Accepted Solutions
mkeintz
PROC Star

You surround the expression

  || name ||

by quotes, which means sas willl treat it as a literal to be written by your put statemet.

 

Try

 put name $quote10. ;

 

which applies the $quote format  to name. Since name is 8  bytes, I  use 10 as the size attribute of the $quote format.

 

Mark

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

3 REPLIES 3
mkeintz
PROC Star

You surround the expression

  || name ||

by quotes, which means sas willl treat it as a literal to be written by your put statemet.

 

Try

 put name $quote10. ;

 

which applies the $quote format  to name. Since name is 8  bytes, I  use 10 as the size attribute of the $quote format.

 

Mark

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
SAS_inquisitive
Lapis Lazuli | Level 10

@mkeintz Thank you. I was asking this question in reference to use of variable in CALL EXECUTE routine. In example below, memname is not treated as literal.

data _null_;
	set _dsets_;
	call execute
		(
		'proc print data=sugi30.' ||
		trim(memname) ||
		'(obs=50); title ''First 50 observations of data set ' ||
		trim(memname) || '''; run;'
			);
run;
mkeintz
PROC Star

If you're trying to put quotes around the memname when it appears in the title, then use the put function, with $quote as 2nd argument, in the place where the variable memname appears in the title statement:

 

 

data _null_;

  set _dsets_;

  call execute

               (

       'proc print data=sugi30.' ||

                trim(memname) ||

       '(obs=50); title ''First 50 observations of data set ' ||

       put(memname,$quote10.) || '''; run;'

              ) ;

run;

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
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
  • 3 replies
  • 1496 views
  • 1 like
  • 2 in conversation