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: 
Paul_NYS
‎10-05-2016
  • 216 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Exporting files from SAS and importing them into Access error

by Obsidian | Level 7 in SAS Enterprise Guide
‎12-11-2012 01:37 PM
‎12-11-2012 01:37 PM
Hi In the Enterprise Guide GUI area, I have exported a data set in various formats (i.e. txt, csv, xlsx.) and have tried to import the same file into an Access 2010 database. When I try to import the file, I am getting this error: "Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt." Has anyone gotten this before? Paul ... View more

Re: Merge statement-not including all records

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 03:05 PM
‎11-29-2012 03:05 PM
It didn't work that way either. What is happening is that one set of records is overwriting the 'missing' ones. I don't understand why though, but I am trying a merge after the merge. Paul ... View more

Re: Merge statement-not including all records

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 02:27 PM
‎11-29-2012 02:27 PM
I ran the below code with the 'in' statements and the missing records were were still not in the final record set: data s1AgeCleanOutALLAGEALL; merge s1AgeCleanSortALLAGEALL (in=clean) s1ageOutSortALLAGEALL (in=all); by cnty_name startyear; if clean; if all; run; ... View more

Re: Merge statement-not including all records

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 02:19 PM
‎11-29-2012 02:19 PM
If there was no match, there would be other records missing also. Its just this one group. ... View more

Re: Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-29-2012 12:50 PM
‎11-29-2012 12:50 PM
The below transpose may work with some modifications, thank you. While it did not come out the way I was envisioning, I'll report back on the result. Paul proc transpose data=have out=want ;   by cnty_name startyear agecat4 exitMonth cohortyeartotal cohortyeartotalage ; id exit; var OutOfHomeCare; run; ... View more

Merge statement-not including all records

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 12:47 PM
‎11-29-2012 12:47 PM
Hi Everyone I have the below very simple proc sort and one merge statement. In the second proc statement, there is a group of records that is not being included in the final merge data step. I used this code elsewhere with different data sets and it worked fine. I know I did not include the data sets to review, but is there something here syntax-wise that would eliminate certain records? Paul proc sort data=s1ageOutALLAGEALL out=s1ageOutSortALLAGEALL; by cnty_name startyear; run; proc sort data=s1AgeCleanALLAGEALL out=s1AgeCleanSortALLAGEALL; by cnty_name startyear; run; data s1AgeCleanOutALLAGEALL; merge s1AgeCleanSortALLAGEALL s1ageOutSortALLAGEALL; by cnty_name startyear; run; ... View more

Re: Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-27-2012 03:18 PM
‎11-27-2012 03:18 PM
Hi Art This behaves the same way as Tom's transpose--it creates new columns in addition to moving the outofhomecare column to records. I need to take a closer look to determine if the new columns created contain the correct values for the new outofhomecare records. Paul ... View more

Re: Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-27-2012 03:14 PM
‎11-27-2012 03:14 PM
Hi Manu, can you post that spreadsheet so I can take a closer look at it? Paul ... View more

Re: Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-27-2012 03:13 PM
‎11-27-2012 03:13 PM
Thanks Tom. I ran the above transform. It definitely put the outofhomecare column into rows under the _NAME_ column. However it also moved all the rows that were previously under Exit into columns, with each value being a different column. Is there a way to keep the existing values under the Exit column? ... View more

Re: Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-26-2012 06:30 PM
‎11-26-2012 06:30 PM
No, what I need to do is to create one outofhomecare record for each unique instance of cnty_name, startyear, agecat4 exitmonthcategory. To make it easier to see, I changed the below example file to include only one county's worth of data. So there are 2040 records in the amended file (for only one county). There are 6 different values of startyear, 5 different values of agecat4 and 17 different value of exitmonthcategory. This would be 510 total records of outofhomecare for this one county. 'Exit' would equal the actual word 'outofhomecare', 'cnty_name' would be county-ABC, 'startyear' would be each of the start years (2006-2011), agecat4 would be each of the categories (0, 1 to 5, 6 to 12, etc.) and cumulativenumber would be the current value under the outofhomecare column. The other categories are blank for now. That is what I am trying to do. http://www.nycourts.gov/surveys/cwcip/transpose-issue.zip Paul ... View more

Proc Transpose

by Obsidian | Level 7 in SAS Procedures
‎11-26-2012 05:38 PM
‎11-26-2012 05:38 PM
Hi Everyone I have a data set where I would like to make one column into a row. I understand that transpose moves a row into a column, but I am having trouble wrapping my head around how to transpose a column into a record. Below is a link to a data set that has the following columns: cnty_name startyear exit agecat4 exitMonth cohortyeartotal cohortyeartotalage distributionnumber distributionpercent cumulativenumber cumulativepercent outofhomecare http://www.nycourts.gov/surveys/cwcip/transpose-issue.zip What I would like to do is to make the outofhomecare column into a record. The current value that is in the outofhomecare column would be the cumulativenumber value and the value for the exit column would be "outofhomecare". The values for most of the other columns would be as they are.or blank (for calculations). Does transpose correctly work for mapping a column to a record? Paul ... View more

Re: Subtraction function

by Obsidian | Level 7 in SAS Programming
‎11-26-2012 05:27 PM
‎11-26-2012 05:27 PM
Thats all I need in this particular situation actually: current - previous. Paul ... View more

Re: Subtraction function

by Obsidian | Level 7 in SAS Programming
‎11-26-2012 05:00 PM
‎11-26-2012 05:00 PM
Yes, I did the sum() above and that worked for me, but I think the DIF would work as well. Thank you both. Paul ... View more

Subtraction function

by Obsidian | Level 7 in SAS Programming
‎11-26-2012 03:14 PM
‎11-26-2012 03:14 PM
Hi I have used the sum function in a data step to add the value of a previous row to a current one. I was wondering if there is something similar for subtracting a value in a previous row from a value in the current data set? I did not see anything for 'subtract' and tried adding a negative value using the sum function but that did not work either: data s1AgeCleanCare1; set s1AgeCleanSort1; by cnty_name startyear agecat4 exitMonthCategory; if first.agecat4 then CumulativeNumber=OutOfHomeCare; OutOfHomeCare + (-CumulativeNumber); run; Paul ... View more

Re: SAS Proc and sorting options

by Obsidian | Level 7 in SAS Procedures
‎11-23-2012 01:56 PM
‎11-23-2012 01:56 PM
Thanks a lot again Art. That works fine. Paul ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-05-2016 02:57 PM
Likes from
Quick links