About Paul_NYS

Paul_NYS · ‎01-24-2014

Hi Quentin You got the result I am looking for. I cannot replicate it apparently. And, outside of the last statement indicated above, there are no differences. Paul

Paul_NYS · ‎01-24-2014

Yes, I tried it exactly as you have it and tried with quotes as well. Neither worked. The only item I don't have is your statement below: put (_all_)(=); Paul

Paul_NYS · ‎01-24-2014

Hi Quentin You have the logic right and that is what I have done. However the resulting data set just adds a negative to the DistributiveNumber value and does not subtract it from the CohortYearTotalAge value: County Year ExitMonthCategory CohortYearTotalAge DistributiveNumber CNumber 1 - New York State 2006 0.5 4632 0 4632 1 - New York State 2006 1 4632 2 -2 1 - New York State 2006 2 4632 0 0 1 - New York State 2006 3 4632 0 0 1 - New York State 2006 4 4632 0 0 1 - New York State 2006 5 4632 0 0 1 - New York State 2006 6 4632 2 -2 1 - New York State 2006 12 4632 2 -2 1 - New York State 2006 18 4632 6 -6 1 - New York State 2006 24 4632 4 -4 1 - New York State 2006 30 4632 2 -2 1 - New York State 2006 36 4632 7 -7 1 - New York State 2006 42 4632 0 0 1 - New York State 2006 48 4632 0 0 1 - New York State 2006 54 4632 3 -3 1 - New York State 2006 60 4632 0 0 1 - New York State 2006 66 4632 0 0 1 - New York State 2006 72 4632 0 0 1 - New York State 2006 78 4632 0 0 1 - New York State 2006 84 4632 0 0 1 - New York State 2006 87 4632 0 0 1 - New York State 2006 0.5 4632 0 4632 1 - New York State 2006 1 4632 0 0 1 - New York State 2006 2 4632 0 0 1 - New York State 2006 3 4632 0 0 1 - New York State 2006 4 4632 1 -1 1 - New York State 2006 5 4632 1 -1 1 - New York State 2006 6 4632 3 -3 1 - New York State 2006 12 4632 7 -7 1 - New York State 2006 18 4632 26 -26 1 - New York State 2006 24 4632 23 -23 1 - New York State 2006 30 4632 22 -22 1 - New York State 2006 36 4632 18 -18 1 - New York State 2006 42 4632 15 -15 1 - New York State 2006 48 4632 8 -8

Paul_NYS · ‎01-23-2014

Nothing prints for CNumber after the initial value in the 'first' statement (if first.&a7 then CNumber=CohortYearTotalAge;). Paul

Paul_NYS · ‎01-23-2014

It is simply this (the only difference is the CNumber column): Input: County Year ExitMonthCategory CohortYearTotalAge DistributiveNumber CNumber 1 - New York State 2006 0.5 4632 0 1 - New York State 2006 1 4632 2 1 - New York State 2006 2 4632 0 1 - New York State 2006 3 4632 0 1 - New York State 2006 4 4632 0 1 - New York State 2006 5 4632 0 1 - New York State 2006 6 4632 2 1 - New York State 2006 12 4632 2 1 - New York State 2006 18 4632 6 1 - New York State 2006 24 4632 4 1 - New York State 2006 30 4632 2 1 - New York State 2006 36 4632 7 1 - New York State 2006 0.5 2350 0 1 - New York State 2006 1 2350 2 1 - New York State 2006 2 2350 0 1 - New York State 2006 3 2350 0 1 - New York State 2006 4 2350 0 1 - New York State 2006 5 2350 0 1 - New York State 2006 6 2350 2 1 - New York State 2006 12 2350 2 1 - New York State 2006 18 2350 6 1 - New York State 2006 24 2350 4 1 - New York State 2006 30 2350 2 1 - New York State 2006 36 2350 7 End: County Year ExitMonthCategory CohortYearTotalAge DistributiveNumber CNumber 1 - New York State 2006 0.5 4632 0 4632 1 - New York State 2006 1 4632 2 4630 1 - New York State 2006 2 4632 0 4630 1 - New York State 2006 3 4632 0 4630 1 - New York State 2006 4 4632 0 4630 1 - New York State 2006 5 4632 0 4630 1 - New York State 2006 6 4632 2 4628 1 - New York State 2006 12 4632 2 4626 1 - New York State 2006 18 4632 6 4620 1 - New York State 2006 24 4632 4 4616 1 - New York State 2006 30 4632 2 4614 1 - New York State 2006 36 4632 7 4607 1 - New York State 2006 0.5 2350 0 2350 1 - New York State 2006 1 2350 2 2348 1 - New York State 2006 2 2350 0 2348 1 - New York State 2006 3 2350 0 2348 1 - New York State 2006 4 2350 0 2348 1 - New York State 2006 5 2350 0 2348 1 - New York State 2006 6 2350 2 2346 1 - New York State 2006 12 2350 2 2344 1 - New York State 2006 18 2350 6 2338 1 - New York State 2006 24 2350 4 2334 1 - New York State 2006 30 2350 2 2332 1 - New York State 2006 36 2350 7 2325

Paul_NYS · ‎01-23-2014

Thanks Reeza, but no, it is the same result actually. Paul

Paul_NYS · ‎01-23-2014

Hi Everyone Using the lag function, I am trying to create a declining balance in a numeric column based on the value from the previous record, assuming it meets one criteria. Below is the code for this. However, the result is actually accumulating rather than declining. I have tried various iterations of this and it does not work. However, I have lag in the past without issue. Does anyone know if this is logically wrong or a syntax issue? Attached is part of the result also. Paul data test2; set &a3; by &a6; if first.&a7 then CNumber=CohortYearTotalAge; if ExitMonthCategory > .5 then do; CNumber=lag(CNumber)-DistributiveNumber; end; run;

Paul_NYS · ‎01-21-2014

Thanks Art. I am giving this a shot and will let you know. Paul

Paul_NYS · ‎01-21-2014

Hi I used macros all the time and always come across an issue--is it possible to use certain steps in a macro situationally? That is, depending on the value of one of the incoming parameters, process certain parts of the overall macro? For example, if the second parameter = "flag", then the "newValue" data step will be processed, otherwise it will be bypassed? Paul

Paul_NYS · ‎12-05-2013

Hi EJ Your example with a 'macro' variable does not use a macro though. Do you need to use a macro variable only in a marco? Paul

Paul_NYS · ‎12-05-2013

Hi I would to determine if there is a record in a data set that contains a specific value for one of the variables in the data set. In other programming languages you can set a global variable (meaning it is available outside of the given function) to equal something when processing records indicates one of the records contains what you are looking for. You can use this variable in other programming steps. In SAS, is there a way to do this? Paul

Paul_NYS · ‎12-04-2013

Thanks Reeza. I will try this and re-try the classdata method. It does make sense to create the combinations that do not exist in the data set. Paul

Paul_NYS · ‎12-04-2013

I tried variations of the below proc summary statement using both 'completetypes' and 'classadata; and neither are producing a row when ExitMonthCategory4 = 78. Is there something I am missing? Paul proc summary classdata=s6AgeRangesRos completetypes; class cnty_name startyear ExitMonthCategory4; output out=s6AgeRangesRosF; run;

Paul_NYS · ‎12-04-2013

I just want to force a frequency for each combination regardless of whether is a value or not. I will take a look at MEANS or SUMMARY. Paul

Paul_NYS · ‎12-04-2013

No, it doesn't show up in this specific data set actually. Paul

Online Status	Offline
Date Last Visited	‎10-05-2016 02:57 PM

Re: ERROR: Windows error code: 1117 in hc_disk_normal_read for..........

ERROR: Windows error code: 1117 in hc_disk_normal_read for....... err...

Re: MEMSIZE and FULLSTIMER options for memory issues

Re: Create a data set by grabbing the first <insert number> records fr...

MEMSIZE and FULLSTIMER options for memory issues

Re: Create a data set by grabbing the first <insert number> records fr...

Create a data set by grabbing the first <insert number> records from a...

Re: Merging two data sets and ensuring additional records are not crea...

Merging two data sets and ensuring additional records are not created.

Re: Collapse multiple records into one and combine column values

"NOTE 49-169: The meaning of an identifier after a quoted string....."...

Exporting a SAS data set in SAS format

Re: Lag statement

Re: Lag statement

Re: Lag statement

Re: Lag statement

Re: Lag statement

Re: Lag statement

Lag statement

Re: Optional/situational steps in a macro

Optional/situational steps in a macro

Re: SAS variable for tracking data step processing

SAS variable for tracking data step processing

Re: Proc freq using SPARSE

Re: Proc freq using SPARSE

Re: Proc freq using SPARSE

Re: Proc freq using SPARSE