DATA Step, Macro, Functions and more

Macro values with new line characters

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 85
Accepted Solution

Macro values with new line characters

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


Accepted Solutions
Solution
‎05-30-2013 12:59 AM
Frequent Contributor
Posts: 85

Re: Macro values with new line characters

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

View solution in original post


All Replies
Solution
‎05-30-2013 12:59 AM
Frequent Contributor
Posts: 85

Re: Macro values with new line characters

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 861 views
  • 0 likes
  • 1 in conversation