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: 
Msilverio
‎09-01-2015
  • 6 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Help on creating a first and last observation for a report due tom...

by Calcite | Level 5 in SAS Programming
‎04-15-2015 02:33 PM
‎04-15-2015 02:33 PM
Thanks Hai.Kou this worked flawlessly, you saved the day. I'm assuming the similar process will work on a large data set. ... View more

Re: Help on creating a first and last observation for a report due tom...

by Calcite | Level 5 in SAS Programming
‎04-15-2015 01:24 PM
‎04-15-2015 01:24 PM
unfortunatelly this is not producing similar reports to the end result of the "WANT" data set i posted above? Any ideas? ... View more

Re: Help on creating a first and last observation for a report due tom...

by Calcite | Level 5 in SAS Programming
‎04-15-2015 02:46 AM
‎04-15-2015 02:46 AM
Kurt, This is what I want the expected results to look like SITE SA_ID CA_ID REVN_MO_DESC1 RSD_CU_CNT FIRST LAST 938680287 250286 352846288 2009-01 1 1 0 938680287 250286 352846288 2009-02 1 0 0 938680287 250286 352846288 2009-03 1 0 0 938680287 250286 352846288 2009-03 0 0 1 938680287 250286 496956287 2009-04 0 1 1 938680287 250286 504744282 2009-04 0 1 1 938680287 250286 496956287 2009-05 1 1 0 938680287 250286 496956287 2009-06 1 0 0 938680287 250286 496956287 2009-07 1 0 0 938680287 250286 496956287 2009-08 1 0 0 938680287 250286 496956287 2009-09 1 0 0 938680287 250286 496956287 2009-10 1 0 0 938680287 250286 496956287 2009-11 1 0 0 938680287 250286 496956287 2009-12 1 0 0 938680287 250286 496956287 2010-01 0 0 0 938680287 250286 496956287 2010-01 1 0 0 938680287 250286 496956287 2010-02 1 0 0 938680287 250286 496956287 2010-03 1 0 0 938680287 250286 496956287 2010-04 1 0 0 938680287 250286 496956287 2010-05 1 0 0 938680287 250286 496956287 2010-06 1 0 0 938680287 250286 496956287 2010-07 1 0 0 938680287 250286 496956287 2010-08 1 0 0 938680287 250286 496956287 2010-09 1 0 0 938680287 250286 496956287 2010-10 0 0 1 938680287 250286 504744282 2010-10 0 1 1 938680287 250286 902427289 2011-09 0 1 0 938680287 250286 902427289 2011-10 1 0 0 938680287 250286 902427289 2011-11 1 0 0 938680287 250286 902427289 2011-12 1 0 1 938680287 250286 504744282 2012-01 0 1 1 938680287 250286 902427289 2012-01 0 1 0 938680287 250286 902427289 2012-01 1 0 0 938680287 250286 902427289 2012-01 0 0 1 938680287 250286 504744282 2012-02 0 1 1 938680287 250286 761347288 2012-02 0 1 1 938680287 250286 504744282 2012-03 0 1 1 938680287 250286 761347288 2012-03 0 1 1 938680287 250286 504744282 2012-04 1 1 0 938680287 250286 504744282 2012-05 1 0 0 938680287 250286 504744282 2012-06 1 0 0 938680287 250286 504744282 2012-07 1 0 0 938680287 250286 504744282 2012-07 0 0 0 938680287 250286 504744282 2012-08 1 0 0 938680287 250286 504744282 2012-08 0 0 1 938680287 250286 536837281 2012-09 0 1 1 938680287 250286 697657288 2012-09 0 1 1 938680287 250286 697657288 2012-09 0 0 0 938680287 250286 5147280 2012-10 0 1 1 938680287 250286 504744282 2012-10 0 1 1 938680287 250286 504744282 2012-10 0 0 0 938680287 250286 618567285 2012-10 0 1 1 938680287 250286 504744282 2012-11 1 1 0 938680287 250286 504744282 2012-12 1 0 0 938680287 250286 504744282 2013-01 1 0 0 938680287 250286 504744282 2013-02 1 0 0 938680287 250286 504744282 2013-02 0 0 1 938680287 250286 916365281 2013-02 0 1 1 938680287 250286 504744282 2013-03 1 1 0 938680287 250286 504744282 2013-03 0 0 1 938680287 250286 762877286 2013-03 0 1 1 938680287 250286 504744282 2013-04 0 1 0 938680287 250286 504744282 2013-04 1 0 1 938680287 250286 296087287 2013-05 1 1 0 938680287 250286 296087287 2013-06 1 0 0 938680287 250286 296087287 2013-07 1 0 0 938680287 250286 296087287 2013-08 0 0 1 938680287 250286 226497280 2013-09 0 1 0 938680287 250286 226497280 2013-10 0 0 1 938680287 250286 504744282 2013-10 0 1 0 938680287 250286 504744282 2013-11 1 0 0 938680287 250286 504744282 2013-12 1 0 0 938680287 250286 504744282 2014-01 1 0 0 938680287 250286 504744282 2014-02 1 0 0 938680287 250286 504744282 2014-03 0 0 1 938680287 250286 828908283 2014-03 0 1 0 938680287 250286 828908283 2014-04 1 0 0 938680287 250286 828908283 2014-05 0 0 1 938680287 250286 504744282 2014-09 0 1 1 938680287 250286 993747286 2014-09 0 1 1 938680287 250286 504744282 2014-10 1 1 0 938680287 250286 504744282 2014-11 1 0 0 938680287 250286 504744282 2014-12 1 0 0 938680287 250286 504744282 2015-01 1 0 0 938680287 250286 504744282 2015-02 1 0 0 938680287 250286 504744282 2015-03 0 0 0 938680287 250286 504744282 2015-03 1 0 1 ... View more

Help on creating a first and last observation for a report due tomorow

by Calcite | Level 5 in SAS Programming
‎04-15-2015 02:21 AM
‎04-15-2015 02:21 AM
Hello, I'm in the process of  trying to correctly label first and last observations by a specific sorting criteria (Service account, Month and Customer Account ). In this process I need to correctly assignt first and last observations to customer accounts to identify turn ove by  moth.. Can anyone point me in the right direction to fix this issue? I can't seem to get this to work properly without having to resort the data. The sorting criteria must stay as; 1. SA_ID 2. Month    (REVN_MO_DESC1) 3. Customer Account  (CA_ID) Thoughs on how to get this work? DATA: SA_ID CA_ID REVN_MO_DESC1 RSD_CU_CNT 250286 352846288 2009-01 1 250286 352846288 2009-02 1 250286 352846288 2009-03 1 250286 352846288 2009-03 0 250286 496956287 2009-04 0 250286 504744282 2009-04 0 250286 496956287 2009-05 1 250286 496956287 2009-06 1 250286 496956287 2009-07 1 250286 496956287 2009-08 1 250286 496956287 2009-09 1 250286 496956287 2009-10 1 250286 496956287 2009-11 1 250286 496956287 2009-12 1 250286 496956287 2010-01 0 250286 496956287 2010-01 1 250286 496956287 2010-02 1 250286 496956287 2010-03 1 250286 496956287 2010-04 1 250286 496956287 2010-05 1 250286 496956287 2010-06 1 250286 496956287 2010-07 1 250286 496956287 2010-08 1 250286 496956287 2010-09 1 250286 496956287 2010-10 0 250286 504744282 2010-10 0 250286 902427289 2011-09 0 250286 902427289 2011-10 1 250286 902427289 2011-11 1 250286 902427289 2011-12 1 250286 504744282 2012-01 0 250286 902427289 2012-01 0 250286 902427289 2012-01 1 250286 902427289 2012-01 0 250286 504744282 2012-02 0 250286 761347288 2012-02 0 250286 504744282 2012-03 0 250286 761347288 2012-03 0 250286 504744282 2012-04 1 250286 504744282 2012-05 1 250286 504744282 2012-06 1 250286 504744282 2012-07 1 250286 504744282 2012-07 0 250286 504744282 2012-08 1 250286 504744282 2012-08 0 250286 536837281 2012-09 0 250286 697657288 2012-09 0 250286 697657288 2012-09 0 250286 5147280 2012-10 0 250286 504744282 2012-10 0 250286 504744282 2012-10 0 250286 618567285 2012-10 0 250286 504744282 2012-11 1 250286 504744282 2012-12 1 250286 504744282 2013-01 1 250286 504744282 2013-02 1 250286 504744282 2013-02 0 250286 916365281 2013-02 0 250286 504744282 2013-03 1 250286 504744282 2013-03 0 250286 762877286 2013-03 0 250286 504744282 2013-04 0 250286 504744282 2013-04 1 250286 296087287 2013-05 1 250286 296087287 2013-06 1 250286 296087287 2013-07 1 250286 296087287 2013-08 0 250286 226497280 2013-09 0 250286 226497280 2013-10 0 250286 504744282 2013-10 0 250286 504744282 2013-11 1 250286 504744282 2013-12 1 250286 504744282 2014-01 1 250286 504744282 2014-02 1 250286 504744282 2014-03 0 250286 828908283 2014-03 0 250286 828908283 2014-04 1 250286 828908283 2014-05 0 250286 504744282 2014-09 0 250286 993747286 2014-09 0 250286 504744282 2014-10 1 250286 504744282 2014-11 1 250286 504744282 2014-12 1 250286 504744282 2015-01 1 250286 504744282 2015-02 1 250286 504744282 2015-03 0 250286 504744282 2015-03 1 ... View more

Re: Import a flat file of long string of BLS data into SAS

by Calcite | Level 5 in SAS Procedures
‎07-23-2014 12:56 PM
‎07-23-2014 12:56 PM
Thanks for Kurt, This seems to work great when pulling a single data series ID. Unfortunately, I'm required to pull at least 25 Series ID from BLS on a single run.  Would you guys know of a more efficient way to extract this data and successfully read it into SAS with multiple SeriesID's (up to 25)? I'm using the following code to extract data from BLS: %let url=http://api.bls.gov/publicAPI/v1/timeseries/data/; filename in  "C:\SAS BLS\SeriesIn.txt"; filename out "C:\SAS BLS\SeriesDataOut.txt" recfm=v lrecl=32000;proc http in=in out=out url="&url" method="post" ct="application/json";run; _______________________________________________________________________________________________________ Sample SeriesIn.txt        ( A text file that indicates the Seriesid's to be extracted) {"seriesid":["CEU0800000003","CFU0000008000","LEU0254555900","APU0000701111"], "startyear":"2002", "endyear":"2012"} run; ... View more

Import a flat file of long string of BLS data into SAS

by Calcite | Level 5 in SAS Procedures
‎07-23-2014 02:54 AM
‎07-23-2014 02:54 AM
Hello all, I have a flat file consisting of  Series ID, Data, Year, Period, Period Name and Value. It is of the form: [{"seriesID":"CES1000000001","data":[{"year":"2014","period":"M06","periodName":"June","value":"907","footnotes":[{"code":"P","text":"preliminary"}]},{"year":"2014","period":"M05","periodName":"May","value":"903","footnotes":[{"code":"P","text":"preliminary"}]},{"year":"2014","period":"M04","periodName":"April","value":"901","footnotes":[{}]}, and so forth, This file contains 6 possible variables I'd like to read this file into a data set, such that each variable  gets its own entry (ideally without the quotation mark or other delimters). Please help as I seem unable to properly read it into sas. Kind regards ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Likes given to
View All
Quick links