I have a task to create a pdf report.  I have the report generating but I have some table headings on the last line of one page and the data on the next page. Is there a way to check how many lines are left on a page and if it's not enough add a new page at that point?   Thank you ... View more

Hello,   When I do a two-way proc freq it doesn't show the two variable names above the freq table.  I never changed any of the setting on my SAS.  Is there a way to bring them back?   EX.   The SAS System The FREQ Procedure Two-Way Table Output Count |0-YES |1-NO | Total --------+---------+---------+ 0-YES | 6 | 2 | 8 --------+---------+---------+ 1-NO | 2 | 56 | 58 --------+---------+---------+ Total 8 58 66 Under " Two-Way Table Output " shouldn't I see the 2 variables names used?   Thank you ... View more

Hello,   I have a program that I run manually for different years.  The sas data table for almost all are in one directory structure and then I have another directory structure for some of the other years.   Ex. 2000-2005 C:\Data\Checking\SAS\Proj1 2006-2009 C:\Data\Checking\SAS\Proj2   The table I want is in that path for that specific year.  The issue I have is that one column is different between the two locations. I have State in the first path and ST in the tables in the second path. This is what I have tried: %let year=2009 ; %macro path ; %if &year. < 2006 %then %let vName = state ; %else %let vName = st ; %mend path ; %path ; %put &vName. ;   I don't want to manually change these field names in my selects statements.  What would be the best way to define a macro variable that will hold either State or ST and use that in my select statements throughout my program?   My example above is giving me  "WARNING: Apparent symbolic reference VNAME not resolved." on %put &vName. ;   proc sql ; select &vname. from tblTest quit ;       ... View more

Hello,   I have a program that has a label that is using a small right arrow.  When I run the program through sas manually it runs fine with no errors.  I check the properties on the table and look for the variable and label shows the small right arrow.    When I run the following code it gets to the the variable with the right arrow and stops.  It says that the "DATA STEP running" but nothing is happening.   proc printto log="C:\temp\test.log" new ; run ; %inc "C:\temp\test.sas" /source2 ; proc printto ; run ; When I cancel submitted statement and go to the log file it is stopped at that variable and the label go to the character right before the right arrow.   My question is why it works if I just run the program, but doesn't when the program is included and proc printto is wrapped around it?   I think it is an encoding issue but I'm not sure how to correct this without having to do it manually and I can't do that because there could be many files to update.       ... View more

Hello,   I'm trying to take this sql script string and break it up into column rows to start.  We are scripting out the sql from oracle but we want to create scripts that are formatted a specific way.   CREATE TABLE "TEMP" ("TEMPID" NUMBER(7,0), "TESTID" NUMBER(6,0), "TYPE" VARCHAR2(5), "STARTDT" DATE, "SOURCE" VARCHAR2(5), "TITLE" VARCHAR2(6), CONSTRAINT "TEMP_PK" PRIMARY KEY ("TEMPID") ENABLE,  CONSTRAINT "TEMP_FK" FOREIGN KEY ("KEYID") REFERENCES "KEY" ("ID") ENABLE) ;   Output: TABNm COLNm COLType TEMP TEMPID NUMBER(7,0) TEMP TESTID NUMBER(6,0) TEMP TYPE VARCHAR2(5) TEMP STARTDT DATE TEMP SOURCE VARCHAR2(5) TEMP TITLE VARCHAR2(6)   This is what I have so far.  I try to isolate just the variables and then take a count of double quotes and divide it by 2 to get the number of variables, but I'm not sure how to move each variable into a separate row.   data x ; set raw ; if f1=1 then do ; tabname=scan(line,2,'"') ; ParenPos=find(line,'(') ; x=substr(line,ParenPos) ; EndPos=find(x,'CONSTRAINT') ; if EndPos = 0 then EndPos=find(x,';') ; y=substr(x,1,EndPos-1) ; VarCnt=count(y,'"')/2 ; end ; run ;   ... View more

Hello,   I have a word document that is given to me that is a mock up of a project I'm going to work on.  What I want to do is take the list of tables at the start of the document and then scan the document and pull out and instance where the table.variable combination is listed so I can then create a process to check that these table.variable combinations exist before we start the project.    The reason is that the department we work with gives us mocks that don't match the meta data of their tables and we want to resolve it before we start.   Attached is a test version of how the document will look.   data mock ; length text $400 ; infile '[path]\temp.txt' length = l ; input @1 text $varying400. l ; run ; data tables (drop=flag) ; set mock ; retain flag ; if text = 'FILES:' then flag=1 ; if text = ' ' then flag=0 ; if text ne 'FILES:' and flag=1 then output ; run ; data tables_ (keep=tabname) ; set tables ; tabname = scan(strip(text),1) ; run ; This code will give me a table with a list of tables to search.  I need to have this list in the final table so I can loop through the dictionary.columns table making sure these variables exist in those tables.   tab1.id tab1.type tab1.region tab2.ph1 tab2.Fore1 tab2.Ext1 tab3.ph2 tab3.Fore2 tab3.Ext2 tab4.ph3 tab4.Fore3 tab4.Ext3 tab5.name tab5.co tab5.addr tab5.city tab5.email Thank you   ... View more