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: 
sekarpc
‎03-22-2023
  • 6 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Address cleaning

by Calcite | Level 5 in SAS Procedures
‎03-18-2021 08:27 AM
‎03-18-2021 08:27 AM
This does not quite answer my problem. I have addresses like these 3235 Cambridge Avenue, #6H, Bronx, New York 10463 2 Harrison Street, PH, Poughkeepsie, New York 12601 130 Schroeders Avenue, Apt. 12G, Brooklyn, New York 11239 220 Wadsworth Avenue, Apt. 307, New York, New York 10033 I want to break them apart. For the first one, I want 3235 in one variable, Cambridge Avenue in the second variable, #6H in the third variable, Bronx in the fourth variable, New York in the fifth variable and 10463 in the sixth variable. ... View more

Breaking apart addresses

by Calcite | Level 5 in SAS Programming
‎03-17-2021 02:49 PM
‎03-17-2021 02:49 PM
I have addresses in one field. I want to break it apart as door number, street, city and zip. The addresses are not uniform; some have just spaces between the various parts and some have commas. Can somebody give me an idea of how to go about it efficiently? ... View more

Re: Import from Excel Regedit

by Calcite | Level 5 in SAS Programming
‎09-18-2019 09:09 AM
‎09-18-2019 09:09 AM
Actually, I have solved the problem-SAS technical support helped me. Interestingly, it was Office\15.0\Access Connectivity Engine\engines\Excel that worked. There is no 19.0 (I looked for it before all this). There is no logic behind this. I am glad I got it to work, but I would not have guessed for the world. Thanks to you all. ... View more

Re: Import from Excel Regedit

by Calcite | Level 5 in SAS Programming
‎09-17-2019 01:16 PM
‎09-17-2019 01:16 PM
I do not think that I updated my SAS. It was 9.4 before and it is 9.4 now. However, in the previous machine, it was SAS 9.4 TS Level 1M4 and in the new one it is SAS 9.4 TS Level 1M6. I don't know if that makes a difference. Padmini ... View more

Re: Import from Excel Regedit

by Calcite | Level 5 in SAS Programming
‎09-17-2019 01:09 PM
‎09-17-2019 01:09 PM
In answer to what does the "import does not work right" mean:   For instance, a particular variable named "Date_Interview_Received" has certain texts-some of them are dates, but there are some that are not. For instance I know and I see in the original excel file that one entry says "Family declined Interview". By setting the typeguessrows to 0, the whole column (in my previous computer) would import as text and then I will deal with it all later. But I see that the import has decided that the column is all dates and it has not imported as text. That particular person has missing under date interview received rather than that text.   Do I make sense? ... View more

Import from Excel Regedit

by Calcite | Level 5 in SAS Programming
‎09-17-2019 12:45 PM
‎09-17-2019 12:45 PM
I got a new computer with Windows 10 and Office 19. I have to import from Excel all the time and in my previous computer with Windows 10 and Office 16, I had set the typeguessrows to 0, in order that the import worked properly (sometimes the first few rows are empty for some variables). I thought that I figured where the typeguessrows was in the new one and set it to 0. Yet, the import is not working properly. I wanted to attach a screen shot, but I am unable to do so. It was at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Access Connectivity Engine\Engines\Excel I set the TypeGuessRows to 0 there, yet the import does not work right.   Anyone can help me solve this problem? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-22-2023 05:52 PM
Likes given to
View All
Quick links