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 !!!
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.