; do i = 1 to countw(source,","); word = scan(source,i,","); put word $hex50.; * increase format width if needed; * later, add use of COMPRESS to get rid of unwanted special characters; target = catx("~",target,quote(compress(word,'0D0A'x))); end; call symputx('...
Use compress: data find2; set find; where lengthn(compress(name,," ","ad"))>0; run; This will remove all alphanumeric characters from the string, then if the length left is greater than zero you have special characters. 0 Likes Abraham Obsidian | Level 7 Re: How to ...
COMPRESS Function Returns a character string with specified characters removed from the original string. COUNT Function Counts the number of times that a specified substring appears within a character string. COUNTC Function Counts the number of characters in a string that appear or do not appear in...
COMPRESS Function Returns a character string with specified characters removed from the original string. COUNT Function Counts the number of times that a specified substring appears within a character string. COUNTC Function Counts the number of characters in a string that appear or do not appear...
If it's in the original data (and it wouldn't surprise me if it is) you should be able to remove them using the COMPRESS function ie Code: field = compress(field,'0D'x '0A'x); If it's the output step, there might be options that you can set if you're using say Proc Repo...
; /* data &dictlib.._astdtab(index=(libname memname) */ data &dictlib.._astdtab(label="ASSIST Dictionary tables: Table info"); set _astdtab; run; /*data &dictlib.._astdcol(index=(libname memname name f_lib f_mem) compress=NO */ data &dictlib.._astdcol(compress=NO label="...
Some special arguments are available depending on the function. write_sav can take also notes as string, wheter to compress or not as zsav or apply row compression, variable display widths and variable measures. write_dta can take a stata version. write_xport a name for the dataset. User ...
Chapter 23: Customizing the Kaplan-Meier Survival Plot set colors; call symputx(compress(type || put(i, 2.)), color); run; proc sgplot noautolegend data=display; %macro reg; title 'Line and Fill Colors, Respectively'; %do i = 1 %to 12; reg y=y%eval(13-&i) x=x / lineattrs...
Some special arguments are available depending on the function. write_sav can take also notes as string, wheter to compress or not as zsav or apply row compression, variable display widths and variable measures. write_dta can take a stata version. write_xport a name for the dataset. User ...
The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.