Home

Shailesh_R_T

DATA TRAILING; INPUT @6 TYPE$ 1. @; IF TYPE= '1' THEN INPUT AGE$= 1-2; ELSE IF TYPE='2' THEN INPUT AGE$= 4-5; DROP TYPE; ; DATALINES; 23 1 44 2 ; PROC PRINT DATA=TRAILING; RUN;

Moksha

I have the following input data by checking the CMENDTC and if it is missing the ENDT is the latest date of CMENDTC for that subject.: SUBJECT CMENDTC ENDT 101 2011-09-08 08SEP2011 101 2011-09-08 08SEP2011 101 2011-09-08 08SEP2011 102 2011-11-21 21NOV2011 103 103 103 103 2011-10-29 29OCT2011 105 106 2012-01-09 29OCT2012 107 2011-09-23 23SEP2011 107 2011-09-25 25SEP2011 107 2011-10-15 15OCT2011 107 2011-09-26 26SEP2011 108 2011-10-15 15OCT2011 108 2011-11-14 14NOV2011 109 109 2011-09-20 20SEP2011 109 2011-09-25 25SEP2011 109 2011-09-13 13SEP2011 109 109 2011-09-25 25SEP2011 109 2011-09-25 25SEP2011 109 110 110 2011-10-12 12OCT2011 110 2011-10-23 23OCT2011 111 2011-10-21 21OCT2011 112 113 113 114 2011-10-05 05OCT2011 114 2011-10-02 02OCT2011 114 2011-10-02 02OCT2011 CMENDTC is character datatype and ENDT is numeric. Need the following output: SUBJECT CMENDTC ENDT 101 2011-09-08 08SEP2011 101 2011-09-08 08SEP2011 101 2011-09-08 08SEP2011 102 2011-11-21 21NOV2011 103 29OCT2011 103 29OCT2011 103 29OCT2011 103 2011-10-29 29OCT2011 105 106 2012-01-09 29OCT2012 107 2011-09-23 23SEP2011 107 2011-09-25 25SEP2011 107 2011-10-15 15OCT2011 107 2011-09-26 26SEP2011 108 2011-10-15 15OCT2011 108 2011-11-14 14NOV2011 109 25SEP2011 109 2011-09-20 20SEP2011 109 2011-09-25 25SEP2011 109 2011-09-13 13SEP2011 109 25SEP2011 109 2011-09-25 25SEP2011 109 2011-09-25 25SEP2011 109 25SEP2011 110 23OCT2011 110 2011-10-12 12OCT2011 110 2011-10-23 23OCT2011 111 2011-10-21 21OCT2011 112 113 113 114 2011-10-05 05OCT2011 114 2011-10-02 02OCT2011 114 2011-10-02 02OCT2011 115 2011-08 31AUG2011 115 2011-06 30JUN2011 115 31DEC2011 115 2011 31DEC2011 115 31DEC2011 Please, help.

RichardAD

Add the dictionary table FONTS to surface as a table the registry information that is output via proc registry export=regcheck startat='CORE\PRINTING\FREETYPE\FONTS' ; run ;

sasgorilla

Hi. I recently asked a question about standardizing a proc genmod model to the total population distribution of a number of covariates (age, sex, status), regardless of variable distributions of these within each individual group. In the course of @StatDave advising me how to query the coefficient weight by using the "e" option in an lsmeans statement to produce a "coef" output , I discovered that the weights I expected for the population when using the "om" option were not being produced by my model. They were weighting to something but I couldn't figure out what exactly. After some proc freq testing, I realized the dataset I am using is a summarized data set, where each row has a variable representing the number of outcomes in those that meet that distribution of characteristics (numcount), and a variable representing those at risk for the outcome with those same characteristics (denomcount). proc genmod data=imputed_data; by _imputation_; CLASS group (ref='A') age (ref='<25') status (ref='Jr') sex (ref='Male'); MODEL numcount = group age status sex /dist=poisson link=log offset=logdenomcount; lsmeans group/ exp diff cl om e; ods output ParameterEstimates=gm_fcs1 estimates=model_est lsmeans=allestimates diffs=relrisk; run; Since my poisson model had an offset for the denomcount (logdenomcount), I hadn't thought that weighting was necessary. However, when I looked at the "coef" output produced by e, I couldn't get the true population weights unless I added a weight=denomcount statement. Once added this produced the coefficient weight I would expect given the distribution of my sample (e.g., male =.8, female=.2, etc.). I just want to confirm that this is appropriate (necessary) when data is summarized as described. Can someone please confirm? This is my first time working with both imputed data and summarized data in this type of model so I appreciate your help! (Below is a snippet of how the dataset is laid out: ) Obs sex age status group _Imputation_ _TYPE_ _FREQ_ numcount denomcount num denom logdenomcount 1 Male <25 years old Jr A 1 255 26 1 26 1 1 3.25810 2 Male <25 years old Jr B 1 255 13 1 13 1 1 2.56495 3 Male <25 years old Jr C 1 255 250 12 320 1 1 2.56495

acordes

Hi @XavierBizoux, yesterday I came across once again your fantastic quiz blog series. https://communities.sas.com/t5/SAS-Communities-Library/Data-Entry-in-SAS-Visual-Analytics-8-3-Part-3-Integrate-SAS-Viya/ta-p/582397 Back again in 2021 I could re-built this solution to my needs in my SAS Viya environment. Now some years and releases later, meanwhile I'm working on Viya 4, the need arises to let the report user interact with the report, mainly giving him the functionality to add comments and save them to the underlying sashdat files. Would you still recommend using the tools and techniques described in the quiz blog series?

Recent Solutions

Featured Article

Featured Webinar

Recent Activity

I AM NOT ABLE TO SEE AGE'S OBSERVATION IN MY OUTPUT WINDOW. THE INPUT STATEMENT IS NOT WORKING.

Need help for retaining dates as per below requirement

Add DICTIONARY.FONTS to SQL and SASHELP.FONTS to SASHELP

Is a weight statement necessary in proc genmod when the dataset being used is summarized?

Best approach Viya 4 regarding Data entry through report user activity in Visual Analytics

Unanswered topics

SAS Content Assessment 2025.05 Released!

Escape the Legacy Trap: An Interactive Webinar Experience

PDF Dokument mittels URI in einem Bericht bereitstellen

How use tnsnames in SAS Viya LTS 2024.09 when accessing Oracle data?

SAS Customer Journeys is now live and generally available as of May 7,...

Annual Forecast Total (Combining Actual & Predicted Data)

Where to find practice datasets for "Machine Learning with SAS Viya"?

validating connect and grid server from SMC and failing due to Oracle...

Returning _webout from JES API

Warning: Update to Azure Lustre CSI driver may result in group ownersh...

Recent Solutions

Featured Article

Featured Webinar

Recent Activity

Unanswered topics

Missed SAS Innovate in Orlando?

Check out the winners!