jerry898969 Tracker

ODS PDF knowing how many rows before page break

jerry898969 — Thu, 13 May 2021 14:59:28 GMT

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

Re: Proc GINSIDE Optimization

jerry898969 — Thu, 13 May 2021 14:27:19 GMT

HI @RealePrimavera,

We ended up moving everything to Linux and running it from there. It did speed it up.

Re: Two-way freq doesn't show the variable names when displayed

jerry898969 — Mon, 11 Feb 2019 15:27:00 GMT

Hi ballardw,

I ran this code and this is what it said in the log: NOTE: Path 'Base.Freq.Crosstabfreqs' is in: SASUSER.TEMPLAT.

proc template;
  source base.freq.crosstabfreqs;
run;

1. I went to SAS and right-clicked on the word results in the result window and selected templates.

2. I clicked the "+" of Sasuser.Templat

3. I clicked the "+" of Base

4. Selected "Freq" and it had "CrossTabFreqs" so I renamed it to "_CrossTabFreqs" .

5. I re-ran my freq and now it shows the column names.

Thank you all for your help.

Re: Two-way freq doesn't show the variable names when displayed

jerry898969 — Thu, 07 Feb 2019 20:09:37 GMT

I apologize for not posting the code.

This is the code :


proc freq data= _chk ;
tables Old*New / missing nocol norow nopercent ; 
run ;

Thank you

Two-way freq doesn't show the variable names when displayed

jerry898969 — Thu, 07 Feb 2019 16:56:03 GMT

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

Re: Use different select value in proc sql based on variable

jerry898969 — Thu, 20 Dec 2018 13:59:55 GMT

Thank you everyone for your replies.

novinosrin,

This worked exactly like i needed it too. Thank you.

Use different select value in proc sql based on variable

jerry898969 — Wed, 19 Dec 2018 21:25:44 GMT

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 ;

Re: Right arrow character causes problems only when logging with proc printto

jerry898969 — Fri, 22 Jun 2018 13:58:05 GMT

I was able to figure it out by adding the encoding option to the include statement

proc printto log="C:\temp\test.log" new ;
run ;

%inc "C:\temp\test.sas" /encoding="utf-8" source2 ;

proc printto ;
run ;

Right arrow character causes problems only when logging with proc printto

jerry898969 — Fri, 22 Jun 2018 12:56:02 GMT

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.

Re: Break up string using count function and how to loop through it

jerry898969 — Wed, 18 Apr 2018 14:07:38 GMT

Thank you everyone. Erik this helped a lot.

Re: Break up string using count function and how to loop through it

jerry898969 — Thu, 12 Apr 2018 15:36:27 GMT

I would love to do that, but I have to follow what my supervisor is requesting. I'm not sure his thinking on this. He may think that since it is an oracle DB that we should use Oracle export process to include everything. He may not think SAS can return everything we may need.

Thank you

Break up string using count function and how to loop through it

jerry898969 — Thu, 12 Apr 2018 13:32:59 GMT

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 ;

Re: seach text file based on obs in data table

jerry898969 — Fri, 08 Sep 2017 19:29:14 GMT

Hi Ballard,

Thank you so much. Your data steps returns the correct 17 variables. Sorry for any confusion.

I justed wanted to read in that file and get the list of tables which are listed under "FILES" and then using those table names search the reset of the document for each table.variable combination.

So tab1 would be first and I want it to return the n variables that are associated with tab1.

In this example it is these 3 like your code returns.

tab1.id
tab1.type
tab1.region

Thanks again this is a big help.

seach text file based on obs in data table

jerry898969 — Fri, 08 Sep 2017 17:54:26 GMT

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

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Mon, 03 Apr 2017 15:28:42 GMT

Thank you Robert for your suggestion. I'm going to look into that and see if I can reduce the time.

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Wed, 29 Mar 2017 13:12:35 GMT

So far I have ran almost 300 addresses that I have from 2015 through proc ginside using the latest census block shapefile data. When I compare them to the same 300 rows I have using proc ginside from 2016 shapefiles they are identical. Does this sound right? I was thinking that something might have changed over those 2 years in the shapefiles for tract or block.

I'm running this all on 9.4 TS1M2

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Mon, 27 Mar 2017 20:48:52 GMT

After I installed 9.4 TS1M2 I ran the same piece of code using my old address file and old maps and I geocoded them and did a compare to the file I created 2 years ago and they matched. So there is something going on with 9.4 TS1M3.

I was unable to speak with my supervisor today. I will try and come up with some addresses that show this issue.

Do you have any advice on speeding up proc ginside? Addresses that we get zip matches we take them and join to the sashelp.zipcode table to get the county and then we run those state by state using the latest census shape files. Even for one address the proc ginside has taken almost 30 minutes and it still isn't finished. We tried subsetting by county but there was an issue where the county in the sashelp.zipcode table didn't match the county in the shapefile so that row never got Tract or Block like we were trying to get.

Thank you

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Mon, 27 Mar 2017 18:26:12 GMT

Thank you Ed,

I am using the 2016 street data file from sas maps online for my latest attempt and it was 2015 when we did it 2 years ago.

Yes I did change the location of the maps when I was running my process. I actually used the exact code I did last time but this time it was on 9.4 TS1M3. I'm installing 9.4 TS1M2 now and then I'm going to try it again to see if that will give me the same information. Once I have that then I know I can use TS1M2. That is unless TS1M4 is more accurate.

Thank you

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Mon, 27 Mar 2017 17:07:53 GMT

The raw address file is a sas data set in a permanent library.

I uninstalled TS1M3 and I'm installing TS1M2 and re-running my process and it should be exact. If that happens then I will use TS1M2 to do this years addresses.

If that doesn't work then I will contact tech support.

Thank you again for all your help Ballardw. I will reply back with my results.

Re: Proc geocode giving different results after upgrading to new release version

jerry898969 — Mon, 27 Mar 2017 15:37:00 GMT

Hi ballardw,

The results are considerible different. I get different lat/lon and it's is not just feet apart it is much more. The _matched_ column shows different values as well. For instance one address from when I ran the process 2 years ago has _matched_ = 12345 S Skyview Cyn. The same address running with the same map files and the same raw address file gives me _matched_ = 78945 S Skyview Way.

My raw address file is saved from when I ran it last time. I bring it into my work directory to run the geocode process.

SAS is running on the same exact computer it was running on 2 years ago.

I wonder if updating to TS1M3 updated the zipcode, plfips and any other table that proc geocode uses.

Thank you