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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.