Hi guys, I have a problem when running this code to generate SQL data into report text format because it has a spacing problem in which sentences or words are being separated onto separate lines instead of flowing smoothly across (sample attached). I know it is a concatenation issue and have tried the options ls (linespace) and options ps (pagesize) but they have not helped. Does anyone have any suggestions? Many thanks, *Bringing in SQL tables into SAS format; **Set DBMAX to longest character length in data field; libname testsql oledb init_string="Provider=SQLOLEDB.1; Integrated Security=SSPI; Persist Security Info=True; Initial Catalog = 201107014D; Data Source=vhacdwrb01.vha.med.va.gov" Schema= dflt DBMAX_Text= 10000; *Getting sample into SAS dataset; data batch3; set testsql.TIU_Batch3_wText; keep Source Sta3n DocumentIEN ReportText; run; *Exporting SAS dataset to txt files; data _null_; set batch3; _filename= cats("\\vhacdwfpcfs02\Projects\201107014D\Annotation\TIU Reports\Batch 3\",Source,"_",Sta3n, "_",DocumentIEN)||'.txt'; file dummy filevar= _filename; put Source= ; put; put Sta3n= ; put; put DocumentIEN= ; put; put ReportText= ; run;
... View more
