About Simba

Simba · ‎06-18-2018

Thank you PraneethSrinivas. This works perfectly! Appreciate all your help.

Simba · ‎06-17-2018

Thank you!

Simba · ‎06-17-2018

Thank you PaigeMiller. This code gives me a report table with the values correctly tabulated. The code by KentaMURANKA gives me the same response but as a SAS dataset that can be further analyzed.

Simba · ‎06-17-2018

Thank you for your help. Appreciate it. This code counts the obs per ID but reports it as individual tables per ID.

Simba · ‎06-17-2018

Thank you KentaMURANKA. This works great!

Simba · ‎06-17-2018

Hi, I have dataset below ID Destination aa 1 aa 1 aa 1 aa 2 aa 1 bb 1 bb 3 bb 3 bb 4 bb 4 cc 1 cc 2 cc 3 cc 1 cc 1 cc 1 dd 4 dd 4 dd 4 dd 1 From this I want to create a new SAS table like the one below counting each destination per ID: ID Dest_Count1 Dest_Count2 Dest_Count3 Dest_Count4 aa 4 1 bb 1 2 2 cc 4 1 1 dd 1 3 I am sure there is a way to use Proc sql. I just cant get it to work Thanks!

Online Status	Offline
Date Last Visited	‎06-18-2018 07:31 PM

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Re: Create new SAS table with count number of observations per subject

Create new SAS table with count number of observations per subject