About acemanhattan

acemanhattan · ‎09-27-2019

Thanks @Patrick this worked perfectly.

Tom · ‎09-25-2019

@Kurt_Bremser wrote: Make it a point to always write dataset options in this order: keep/drop rename where because that is the sequence in which they are applied by SAS, irrespective of the order in which you write them. That helps to make the code easier to understand and maintain. Note you can remember the order easily because it is alphabetical. Drop,Keep,Rename,Where.

ballardw · ‎09-25-2019

I would suggest dropping the commas in the list as well. The IN operator no longer requires comma separated values and there are places where commas in a macro variable, such as passing as a parameter in macro code, will cause things to break. Also I would suggest that since IN requires the parentheses that code attempting to use the macro list should look like: where= (hcpcs in ( &hcpc. ) ) instead of placing the () in the macro value.

PGStats · ‎03-14-2019

Just add keyword = lowcase(keyword); or whatever. Then sort with NODUPKEY option to eliminate duplicates.

Reeza · ‎10-16-2017

You can use the approach here, adding in the metric for percentiles as I demonstrated earlier. You’ll have to adjust the WHERE to filter for periods less than the current rather than a window. If you want a percentile not listed in the PROC MEANS statistics you’ll need to use PROC UNIVARIATE. where period < = &i. And the do loop is from minimum to maximum period, no window. I can’t see a data step approach for a running percentile - this is what you’re doing - and PROC EXPAND doesn’t support percentiles that I saw. https://gist.github.com/statgeek/e5e43ff45a4ba1f64d0873ff3bc35974

acemanhattan · ‎08-30-2017

Ah, too easy! Thanks.

Ron_MacroMaven · ‎08-21-2017

I agree with Kurt Bremser about rotating your horizontal lists to vertical (data set rows). I wonder if you can extract your pairs into a data set with proc sql? Art Carpenter and I wrote a paper about List Processing, a while back. http://www.sascommunity.org/wiki/List_Processing_Basics_Creating_and_Using_Lists_of_Macro_Variables Here is a generic tool to read a list and call a macro http://www.sascommunity.org/wiki/Macro_CallMacr Ron Fehd

Ksharp · ‎08-16-2017

When generating the DUMMY table, change it into DATE type variable. and your INFORCE and PDMO is numeric variable. data DUMMY; set personal.all_states_data_201707_A01; INFORCE = mdy(mod(INFORCE,100),1,int(INFORCE/100)); PDMO = mdy(mod(PDMO,100),1,int(PDMO/100)); run; After that , run my code .

SuryaKiran · ‎08-14-2017

@acemanhattan have you looked my solution. You can transpose the original data and then use a loop to calculate the rolling average from the point where you need using simple do loop.

ballardw · ‎03-23-2017

BTW, the zip code tabulation files can create very crazy looking maps in the western states in areas of low population density. In fact there will "holes" with no ZCTA area. I had done basically what this paper guides you through for Idaho and the result was very ugly. So looking into the definition of ZCTA you find out that they do NOT work well when you have areas that do not get postal mail delivered and hence are not assigned Zip codes (national wilderness areas and Air Force bombing ranges for example).

Reeza · ‎08-04-2016

Look into Transpose, in EG I believe it's a task. If your coding it's proc transpose. If you want to get better answers including code, it helps to post data as a data step. https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 At aminimum paste it in as text rather than an image.

Ksharp · ‎01-27-2016

It is hard to say something , it is all depend on what you want. And There looks like some problem in his code : data have; input id $ flag $ have ; cards; a y 8437 a y 4533 a n 6814 b n 9322 b y 8031 b y 8031 ; proc sort data=have; by ID flag have; run; data want; set have; by ID flag have; if Flag = 'n' then want=have; else if flag ='y' and last.flag then want=have; else want =.5*have; run;

Doc_Duke · ‎08-21-2015

Saving the code, as submitted, partly depends on the user-interface you are working from. Saving the log is much easier and may be better for documentation purposes. PROC PRINTTO can redirect the log to a file.

acemanhattan · ‎08-13-2015

So I think the issue is that when I tried to compare the two datasets in Excel, the first dataset is small enough for Excel but the second one isn't. When I compare them in SAS they end up being the same.

Reeza · ‎08-01-2015

Yes, if it's a character it needs to be quoted, single or double.

Online Status	Offline
Date Last Visited	‎09-28-2019 01:22 AM

Re: Selecting Observations from One Table Only When They Match Criteri...

Re: Selecting Observations from One Table Only When They Match Criteri...

Selecting Observations from One Table Only When They Match Criteria in...

Variable is not on file error, even though Proc Contents shows variabl...

Can't Pass Macro List Into Where Clause

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Selecting Observations from One Table Only When They Match Criteri...

Re: Variable is not on file error, even though Proc Contents shows var...

Re: Variable is not on file error, even though Proc Contents shows var...

Re: Variable is not on file error, even though Proc Contents shows var...

Re: Can't Pass Macro List Into Where Clause

Re: 3 largest values per category output in three different rows. How...

Re: Selecting Observations from One Table Only When They Match Criteri...

Re: Variable is not on file error, even though Proc Contents shows var...

Re: Can't Pass Macro List Into Where Clause

Re: Reading In Obscure Data, Only Keep Data That Follows Specific Char...

Re: Calculate Kth Percentile of Sorted Group Based on Previous Observa...

Re: How to Return Each Value in Temporary Array

Re: Calling 2 Macro Variables in Ordered Pairs from 2 Lists

Re: Fill In Missing Dates for Each Possible Combination

Re: Rolling 5 Month Average of Central 3 Values By Group

Re: Working Through Paper 214-2013 "Creating ZIP Code-Level Maps with ...

Re: Create a Column Heading from Each Distinct Value & then Transpose ...

Re: Keeping Max Value and Changing Other Values in Subgroup Contingent...

Re: Automatically Saving Program to Designated Folder

Re: Aggregate sum of all observations decreases when I add variables t...

Re: Proc Sql in operator: what am I doing wrong?