cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sasjoker
‎09-01-2015
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: proc export to Excel error

by Calcite | Level 5 in SAS Programming
‎09-08-2013 07:02 PM
‎09-08-2013 07:02 PM
Hi, Rich: Is there a way to just get rid of those company names with unconventional characteristics?  The thing is that I'm mainly concerned about the companies in the U.S., so those names are not really essential for me; I'm okay with throwing them away.  Thank you - ... View more

best SAS tools to explorer panel data

by Calcite | Level 5 in SAS Programming
‎09-08-2013 07:01 PM
‎09-08-2013 07:01 PM
Hi, you lovely people I have a panel data to explorer.  Basically, hope to get some intuition about the structure of the data, etc.  Mostly, I just use proc contents, proc freq, and proc means. Could you please suggest some other ways to explorer data.  It seems that the proc insights have been discontinued.  Is there a way to produce interactively?  Is there a better way to visualize the data?  Thanks - ... View more

Re: proc export to Excel error

by Calcite | Level 5 in SAS Programming
‎09-07-2013 02:51 PM
‎09-07-2013 02:51 PM
Hi, Rich: Thank you so much for helping out - Mine is 64 bit win and office.  It is likely that the company names contains some non standard characters.  but I tried the unicode mode, and it is still the same.  When I open the repair log, it says: <?xml version="1.0" encoding="UTF-8" standalone="true"?> -<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error034800_01.xml</logFileName><summary>Errors were detected in file 'E:\temp\connected_company.xlsx'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 1, column 203.</removedPart></removedParts>-<removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Cell information from /xl/worksheets/sheet1.xml part</removedRecord></removedRecords></recoveryLog> I don't know how to move forward.... ... View more

proc export to Excel error

by Calcite | Level 5 in SAS Programming
‎09-07-2013 02:49 AM
‎09-07-2013 02:49 AM
Hi, Ladies and Gentlemen: After I export a SAS data with a lot of text strings to Excel 2010.  The Excel reports: Excel found unreadable content in ... do you want to recover the contents of this workbook? After I click okay, the Excel fail to repair the contents, and everything is blank (see below) My SAS code is : proc export data=bx.xxx outfile='e:\temp\xxx .xlsx' dbms = xlsx replace; run; The SAS I'm running is PC SAS for Windows 7 64 bit. What did I do wrong?  Thanks ! ... View more

Re: How to standardize U.S. cities variable in SAS

by Calcite | Level 5 in SAS Programming
‎06-06-2013 02:56 PM
‎06-06-2013 02:56 PM
That is a good method also, thanks! ... View more

Re: How to standardize U.S. cities variable in SAS

by Calcite | Level 5 in SAS Programming
‎06-06-2013 02:54 PM
‎06-06-2013 02:54 PM
Thank you for your help - ... View more

Re: How to standardize U.S. cities variable in SAS

by Calcite | Level 5 in SAS Programming
‎06-05-2013 05:11 PM
‎06-05-2013 05:11 PM
Unfortunately, the zip code variable is not available.  But I also have state variable I can use to triangulate.  Could I ask in this case, what would be a better solution?  Thank you, guys - ... View more

How to standardize U.S. cities variable in SAS

by Calcite | Level 5 in SAS Programming
‎06-05-2013 02:06 PM
‎06-05-2013 02:06 PM
I have a list of city names in the U.S.  They are typed in by end-users.  A lot of them contains minor typos.  See below  Is there an internal list of U.S. city names in the SAS that I can compare my city name list to the correct list (maybe by using COMPLEV???) in order to minimize distance and then standardize city names.  Alternatively, is there a function that transform the first column into code or standard city names so that I can do proc geocode on them?  I tried to manually correct these, almost killed myself...  Thanks a lot, guys! Chicago, Chicago Chicao Chicago Chichago Chicago Cincinatti CINCINNATI Cincinnati CINCINNATI Cincinnatti CINCINNATI Cinncinati CINCINNATI ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links