thank you ... View more

If you are going to report this data, you dont't really need to combining manually. Based on dataset of @Ksharp , you can use across usage in proc report: proc sort data=have; by id rating; run; data want; set have; by id rating; aseq+1; if first.id then aseq=1; run; proc report data=want; column id aseq,(rating color n); define id /group; define aseq /across; define rating /display; define color /display; define n /noprint; run; ... View more

Thanks Suryakiran. Your code works perfectly fine for me. ... View more

Here is the full program if anyone needs it:   data want (drop=word i); set have; length newlist $300 word $100 ; do i=1 to countw(have_,','); word=scan(have_,i,','); if not findw(newlist,have_,',','t') then newlist=catx(',',newlist,word); end; run; data want1; set want; newstring=scan(newlist, 1, ','); do i=2 to countw(newlist,','); word=scan(newlist, i, ','); found=find(newstring, word, 'it'); if found=0 then newstring=catx(', ', newstring, word); end; run; ... View more

thank you! ... View more

that's good to know, thank you ... View more

Thank you! ... View more

thank you so much! ... View more

%let n=4; data have; set sashelp.class end=last; if mod(_n_,&n.)=1 then _id_+1; if last then call symputx('_id_',_id_); run; %macro export_csv(dsn=,path=); %do i=1 %to &_id_.; data temp(drop=_id_); set &dsn.(where=(_id_=&i.)); run; proc export data=temp outfile="&path.\export_&i..csv" dbms=csv replace; run; %end; %mend; %export_csv(dsn=have,path=c:\temp) ... View more

data have; infile datalines truncover dsd; input (Title Column1-Column9) ($); datalines; Colors1,Red,Blue,Black,,Yellow,Green,,, Colors2,Red,,,Purple,Yellow,,,Orange,Violet Colors3,Red,,Black,,Yellow,,White,Orange,Violet Colors4,Red,,,Purple,Yellow,,,Orange,Violet ; data want; set have(rename=(column1-column9=_c1-_c9)); array _cols {*} $ _c1-_c9 ; array x {*} $ 80 column1-column9 ; n=0; do i=1 to dim(_cols); if not missing(_cols{i}) then do;n+1;x{n}=_cols{i};end; end; keep Title Column1-Column9; run; ... View more

Assuming these are SAS datasets use the SASHELP.VCOLUMNS table instead.   libname myFiles 'path to my SAS files'; proc sql; create table date_vars as select * from sashelp.vcolumn where upcase(libname)='MYFILES' and upcase(name) like '%DATE%'; quit; @arde wrote: Hi,   I have a folder with a 30-40 datasets.  I have created a macro to look for dates within those datasets but keep getting errors for datasets that don't have dates in them.      How can I create a macro for fields that only have "Date" in the variable name and will check all datasets within a folder?     For example,   data path.dates; FirstName $ LastName $ StartDate EndDate ; datalines; Bill Smith 201902 20190301 Ben Junior 2019 20190131 ; run;   data path.nondates; FirstName $ LastName$  City $; datalines; Linda Davis NY Sue Smith LA ; run;     want to add dashes to all fields within the folder that have "Date" in the variable name:   proc sql; create table path.? as select *, case when length(strip(Date?)) = 8 then catx("-", substr(strip(Date?), 1,4) ,substr(strip(Date?),5,2), substr(strip(Date?),7, 2)) when length(strip(Date?)) = 6 then catx("-", substr(Date?, 1,4),substr(Date?,5,2)) else Date? end as Date? from path.? ; Quit;       Thanks for your help     ... View more