Hello,   I'm trying to generate a ods pdf file and it is generating and the first row displays correctly.  The issue I'm having is the follow up rows are off by 1 space from lining up.   I tried changing the indent and it didn't fix it.   *Create pdf ; ods listing ; title ; footnote ; options orientation=portrait topmargin=.75in bottommargin=.75in rightmargin=.75in leftmargin=.75in pageno=1 nodate nonumber nocenter ; ods listing close ; ods escapechar='^' ; ods pdf file = "c:\temp.pdf" notoc ; footnote j=c height=8pt font='Courier New' 'Page ^{thispage} of ^{lastpage}' ; ods pdf startpage=now ; ods pdf text="^S={font_size=16pt font_face='Times New Roman' fontweight=bold just=center}&title.^S={}" ; ods pdf text="^2n" ; data _null_ ; set temp end=lastObs ; by id ; declare odsout obj() ; obj.table_start(overrides: 'frame=void rules=none cellpadding=0in cellspacing=.06in ' ) ; obj.body_start() ; if id=1 then do ; obj.row_start() ; obj.format_cell(text: "&heading.", overrides: "height=.06in backgroundcolor=white just=left font_face='Courier New' fontweight=bold") ; obj.row_end() ; obj.row_start() ; obj.format_cell(text: 'Varnum', overrides: "indent=40 height=.06in backgroundcolor=white just=left font_face='Courier New' fontweight=bold") ; obj.format_cell(text: 'Name', overrides: "indent=40 height=.06in backgroundcolor=white just=left font_face='Courier New' fontweight=bold") ; obj.format_cell(text: 'Label', overrides: "indent=40 height=.06in backgroundcolor=white just=left font_face='Courier New' fontweight=bold") ; obj.row_end() ; end ; obj.row_start() ; obj.format_cell(text: varid, overrides: "indent=40 height=.06in cellwidth=1in backgroundcolor=white just=left font_face='Courier New' font_size=9pt ") ; obj.format_cell(text: varname, overrides: "indent=40 height=.06in cellwidth=1in backgroundcolor=white just=left font_face='Courier New' font_size=9pt ") ; obj.format_cell(text: varlabel, overrides: "indent=40 height=.06in backgroundcolor=white just=left font_face='Courier New' font_size=9pt ") ; obj.row_end() ; if last.id then do ; obj.body_end() ; obj.table_end() ; end ; run ; ods pdf close ; ods listing ; ... View more

Hello,   I'm tasked with creating a process that will import many csv files with state addresses.  For example the Iowa directory has 4 csv files.  All the tables have the same columns, but different data types and length.   I created a macro to import the csv files, but now when I try and stack them I get the types doesn't match error.   I created a empty table and using char(32767) so it will fit all rows, but now the table is very large.   What would be the best approach for this situation?   Thank you ... View more

Hello,   I'm making back up copies of directories on a SAS Share sever from a production SAS Share server.  I am able to create a macro to get a list of "DATA" tables and then create a copy of them in a new location.  My issue is that some of the locations I'm copying from have views (*.sas7bvew) and index (*.sas7bndx) files and I'm not sure how to make a copy in the new location.  In my code I'm looping through a list of libnames and taking the data tables and making a work copy then copying the table to my backup location.   data lib_list ; length lib $10 ; input lib $ ; cards; Lib1 Lib2 Lib3 Lib4 ; run; data _null_ ; set lib_list end = last ; call symput('libname'||trim(left((_n_))), trim(left(lib)) ) ; call symput('nlibs', trim(left(_n_))) ; run ; %macro Get ; %do i = 1 %to &nlibs. ; %let x=Share1 ; options comamid=tcp ; libname &&libname&i. server=x.Shr1 access=readonly ; proc sql ; create table tabs as select * from dictionary.tables where libname = "&&libname&i." and memtype = 'DATA' ; quit ; data _null_ ; set tabs end = last ; call symput('tabname'||trim(left((_n_))), trim(left(memname)) ) ; call symput('ntabs', trim(left(_n_))) ; run ; %do j = 1 %to &ntabs. ; data &&tabname&j. ; set &&libname&i...&&tabname&j. ; run ; %end ; %let w=Share2 ; options comamid=tcp ; libname &&libname&i. server=w.Shr2 ; %do y = 1 %to &ntabs. ; data &&libname&i...&&tabname&y. ; set &&tabname&y. ; run ; %end ; proc datasets lib=work nolist memtype=data ; save lib_list ; quit ; %end ; %mend Get ; options mprint ; %Get ; Any help would be greatly appreciated.       ... View more

Hello,   I'm installing SAS 9.3 TS1M0 Server on my test server.  I'm basing my installation on a different servers sas setup.  I'm at the point in the install where it asks about Reginal Settings and there is a check box that says "Configure as a Unicode server".    How can I check the other SAS installation on the other server to see if it is setup as a Unicode server? ... View more

Hello,   I have a data table that I need to create based off another table.  My original table looks like this: TEXT LCNT ABC 5 DEF 2 GHI 12 I need to turn that into ABC_1 ABC_2 ABC_3 ABC_4 ABC_5 DEF_1 DEF_2 GHI_1 GHI_2 GHI_3 GHI_4 GHI_5 GHI_6 GHI_7 GHI_8 GHI_9 GHI_10 GHI_11 GHI_12   What would be the best approach to loop using a variable value?  I thought of doing a do loop inside a data step but how can I set the variable value to loop through?   ... View more