Macro values with new line characters

[forumsguy]

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

[forumsguy · Accepted solution]

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