I have an input in excel like this
Symbol |
KO:SGL |
KO:KAW |
KO:HDR |
KO:NHN |
KO:CLZ |
KO:HYI |
KO:HAC |
KO:AMN |
KO:SFC |
KO:PIS |
KO:KAM |
KO:SHB |
I want to have an output like this.
Symbol
KO:SGL, KO:KAW, KO:HDR, KO:NHN, KO:CLZ, KO:HYI, KO:HAC, KO:AMN, KO:SFC, KO:PIS, KO:KAM, KO:SHB
Do you know any way to do so?
Thank you,
Depends on wha t you mean by output. You can easily write that to the log or a flat file.
libname myxls xlsx 'sample.xlsx';
data _null_;
set myxls.sheet1 ;
file log dsd ;
put symbol @ ;
run;
Or to a macro variable.
proc sql noprint;
select symbol into :mylist separated by ','
from myxls.sheet1
;
quit;
Or even a trival one observation dataset.
data want ;
length symbols $500 ;
set myxls.sheet1 end=eof;
symbols=catx(',',symbols,symbol);
if eof then output;
retain symbols;
keep symbols;
run;
Depends on wha t you mean by output. You can easily write that to the log or a flat file.
libname myxls xlsx 'sample.xlsx';
data _null_;
set myxls.sheet1 ;
file log dsd ;
put symbol @ ;
run;
Or to a macro variable.
proc sql noprint;
select symbol into :mylist separated by ','
from myxls.sheet1
;
quit;
Or even a trival one observation dataset.
data want ;
length symbols $500 ;
set myxls.sheet1 end=eof;
symbols=catx(',',symbols,symbol);
if eof then output;
retain symbols;
keep symbols;
run;
Hi Cynthia.
Thank you for your sugguestion,
Best,
Hi Tom,
Thank you so much for your detailed response !!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.