About MarcTC

MarcTC · ‎12-21-2010

I am wondering if there is a simple statement which can do the following conversion. If a string begins with X's, then get rid of all initial X's. Some examples here: XDANO => DANO XXQRX => QRX XMKR => MKR XXXDMZ => DMZ CANE => CANE

MarcTC · ‎12-21-2010

Thanks, Art. The paper works for me!

MarcTC · ‎12-21-2010

Does SAS offer any product which allows users to interact with ESRI ArcGIS within SAS such as making a call to ArcGIS to run geocoding and bringing the results back to SAS?

MarcTC · ‎12-21-2010

I don;t know where to put this question, so I put it in this section. I want to know how to write SAS code to interact with internet such as Amazon web service, Google Map web service.... I know JAVA can do it. Just wonder how to do it in SAS.

MarcTC · ‎12-20-2010

Is SAS Bridge for ESRI a component embedded in ESRI and used in ESRI environment? Or it is a component embedded in SAS and used in SAS environment?

MarcTC · ‎12-20-2010

You are right. Thanks!

MarcTC · ‎12-20-2010

I wonder why geodist function returns a missing value for some distances. Here is an example: data _null_; a = geodist(-115.27384, 43.61225, -116.27364, 48.61210); put a; a = geodist( -89.95127, 42.23679, -87.94728, 42.23613); put a; run;

MarcTC · ‎12-17-2010

I want to know how to replace special characters with a blank character. In the following example, all special characters ; - / * ^ ) in String1 are replaced by a blank character and output as String2 String1 = YT;-/*ADD^)M String2 = YT____ADD__M I used _ in String2 to represent a blank character.

MarcTC · ‎12-16-2010

Most of US Map examples generated by SAS/GRAPH look like this: http://robslink.com/SAS/democd44/ex_11.htm I want to know if it is possible to add Canada and Mexico into the map like this: http://www.mapsofnewmexico.com/AccordianTabs/USAMapsandGuides/USApop.php

MarcTC · ‎12-10-2010

Just check online articles. It seems PROC GEOCODE's street level address geocoding only produce X/Y coordinateness and no normalized address. Can I use X/Y coordinates to match the data?

MarcTC · ‎12-09-2010

Can Proc Geocode do such address standardization/correction/normalization? I don't have SAS 9.2. TS2M3, so can't test it out. According to some internet posts, Google MAP API can do this task. SAS has a product called SAS Google Map Generator. I wonder if this generator allows users to access Google MAP's address normalization function.

MarcTC · ‎12-09-2010

Here are two address: 128 W. Main Street, Noland, NW 128 West Main St., Noland, NW There are the same address. I want to know if SAS has any tool to tell me they are the same. The addresses can be a lot more complicated than the above. It is hard to come up the rules and put into a program to match them all.

MarcTC · ‎12-08-2010

Tim's answer is not what I am looking for. Suppose I have an external html file, I want to know if it is possible to read it into SAS and convert and output to a pdf file.

MarcTC · ‎12-06-2010

Thank again for the great answer! Another tricky question: Is it possible to use SAS to produce the report in HTML format and then convert it to PDF format(all of these are done by SAS)?

MarcTC · ‎12-06-2010

Cynthia- Thank for the pointers. Here is another simpler question. If I just want to place two tables side by side in a pdf(i.e a pdf only contains two tables and these two tables are next to each other horizontally), how to do it?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Join Table on Two Variables

a SQL question

replicate an array

Re: SQL join question

Re: SQL join question

SQL join question

Re: macro quote question

periodic regression model

macro quote question

Re: Record execution time into a dataset

Get a list of dataset names in a directory/library

How to check user privilege for a store process

statistical analysis cheat sheet

Better way to create indicator variable in PROC SQL

Get rid of initial string

Re: SAS connect to internet

Re: SAS Bridge for ESRI

SAS connect to internet

SAS Bridge for ESRI

Re: Geodist returns missing values

Geodist returns missing values

replace special characters with a blank character.

US Map

Re: Address Matching

Re: Address Matching

Address Matching

Re: ODS PDF

Re: ODS PDF

Re: ODS PDF