About JHE

art297 · ‎02-09-2018

Interesting! I'd have thought, from your example, that you wanted: proc transpose data=WORK.Table1 out=WORK.Table2 ; var Month ENROLLMENT MAJOR_MEDICAL PBM Pharmacy LB DENTAL; run; Art, CEO, AnalystFinder.com

RW9 · ‎02-09-2018

Due to the fact you don't want to use communication I will guess that your post means that there is no observations, hence update has nothing to update. If I was you I would start by learning Base SAS: http://video.sas.com/#category/videos/how-to-tutorials These will guide you on how to do all the various things in Base SAS - this is the language you are using so its good to have a thorough knowledge of it before adding additional sub components like SQL. Several of the early videos will show multiple ways of getting data into SAS datasets to work on.

JHE · ‎12-08-2017

Thank you, INTCK('DTDAY',CLCL_RECD_DT,CLCL_PAID_DT) works.

ballardw · ‎12-04-2017

Doesn't work is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of a dataset, the actual results and the expected results. Data should be in the form of a data step. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

JHE · ‎10-30-2017

I want Grant total monthly and YTD

JHE · ‎10-30-2017

this works. Thank you

JHE · ‎10-22-2017

Thank you! This is working.

error_prone · ‎10-19-2017

Back in the old days column-width could be specified in the ods-statement, not sure if ods excel still has that option. I can't test your code, because you have not provided test-data and the complete proc report code.

JHE · ‎09-10-2017

Thank you, that works.

ballardw · ‎09-06-2017

A common side effect of macro errors is a very hard to find unbalanced quote or parantheses such that a %mend is never found for a macro during compilation. The symptom is code text in the log but no messages such as data set read, macro compilied and such. You may want to 1) save code 2) close the SAS session and restart, 3) run the code with the options mprint symbolgen mlogic. That may give you a better chance to find where some error lies.

JHE · ‎08-24-2017

I resolved myself. Paid_Fina&lobname.TRANS ---- name too long , change to Paid&lobname.TRANS it works. Thank you all !

ballardw · ‎08-22-2017

You may want to edit your orginial post where it says: LOB =0100, but when ods to excel output , LOB = 0100,

JHE · ‎08-21-2017

works now... thank you

Cynthia_sas · ‎08-16-2017

Hi: Without any data or seeing the code you've tried, it's hard to make much of a suggestion, but I would be tempted to use PROC REPORT and something like the program below. cynthia

Online Status	Offline
Date Last Visited	‎01-18-2024 01:58 AM

Calculation of member enrollment by month -- member month MM

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Member enrollment month

Re: Count monthly disenrollment

Count monthly disenrollment

Re: Date format

Re: Date format

Re: integrate rows

Re: Dollar format

Re: Merge or cancandinate the row with same ID

Re: Dynamic Varible in the table

Re: how to check if a variable not exists in a dataset first then proc...

Re: Dynamic Varible in the table

Re: transpose

Re: Proc SQL Update

Re: Calculate Days between tow dates

Re: merge

Re: PROC REPORT OR PROC TRANSPOSE

Re: PROC REPORT WITH CONDITION

Re: PROC REPORT Define format and style

Re: PROC REPORT Compute/Display

Re: how to check if a variable not exists in a dataset first then proc...

Re: Project stop running

Re: %macro?

Re: ods excel proc report output

Re: Macro

Re: ods excel report