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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.