I have a table of multiple variables that I wish to split up to export to different excel workbooks. Period Name Country City Miles 201701 Peter England London 45 201701 Peter England Birmingham 60 201701 Francois France Paris 15 201701 Francois France Marseille 55 201701 Edouard France Lyon 90   For each unique combination of Period/Name/Country I wish to make a table to export to excel, that will be named "Period - Name - Country".xlsx   I've tried doing it with a macro, but haven't really gotten anywhere. Help is much appreciated! ... View more

Hi,   (I'm using SAS Enterprise Guide 7.1)   I'm trying to make a txt-file that can be read by a program on my computer. In order for the program to read the file, all values need to be placed on an exact position within the file.   I have a dataset consisting of a number of character variables, some that have leading blanks and some that have trailing blanks.   proc sql; create table name as select 'BI' as inter, '4F' as type, '25300 ' as account, put(round(compress(sum(payment,tax),0.01)*100,z19.)) as amount, put(intnx('Month' , &now. , 0 , 's'),YYMMDDN8.) as trans_date from source;   When exporting the dataset to txt-file I need the length of the variables to remain the same, i.e. the txt-file needs to include leading and trailing blanks.   I've tried using proc export, but the blanks are removed. proc export data=name outfile="c:\name.txt" dbms=dlm replace; putnames=NO; delimiter=''; run;   Any idea on how to do that?   Thanks!     ... View more