Macro values with new line characters

forumsguy — Wed, 29 May 2013 11:41:33 GMT

Hi all, i am reading values from excel sheet. Which has 2-3 merged cells, so when I amusing proc import I get 2-3 new lines in my dataset. I want to get rid of that since I want to create macro variable in next step of this value.

Dataset

THe code that I am using to create new macro variable is as below:

%let TYPE_CODE=%sysfunc(getvarc(&tab_name,

%sysfunc(varnum(&tab_name,TYPE_CODE))));

Now, values of TYPE_CODE is original table are as follows :

CODE=1, TYPE_CODE="HL" "PL" "CC", TYPE_CODE=_ALL_

Please note that there are 3 lines above CODE=1 and this itself is one single observation in my dataset. Any help is really appreciated

Re: Macro values with new line characters

forumsguy — Thu, 30 May 2013 04:59:06 GMT

I got it corrected. Solution is as below : if at all anyone is interested. Use compress to remove extra lines.

DATA NEW;

SET NEW;

MACRO_PARAMETERS = COMPRESS(MACRO_PARAMETERS,'','KW');

RUN;

@MODS : Please close the thread as answered

topic Re: Macro values with new line characters in SAS Programming

Macro values with new line characters

Re: Macro values with new line characters