BookmarkSubscribeRSS Feed
PhanS
Obsidian | Level 7

Dear Everyone,

I am delighted to engage with the SAS support communities. I found the supports, thus far, are very helpful to me with respect to my data manipulations that I am working at this moment.   

For this project, I am going to finish my exercises soon, although I would like to post two challenges that I cannot answer myself. These challenges are:

1) Identifying continuity in longitudinal data.

This issue I am looking for a syntax that allows me to calculate changes over time in viral load tests that can be ranged form 1 to over 300 tests in 10 years.  

2) When I calculate changes in the first year of VL, I have observed that my data was no longer in longitudinal. I observe that I have one record for each subject study.

My question here how can I keep my data to be longitudinal format.

     

I look forward to hearing everyone's assistance.

Phan S.

4 REPLIES 4
PhanS
Obsidian | Level 7

Hello everyone,

I hope someone can help me with solutions for my inquires. Please let me know if you have concerns.

Thanks,

Phan S.

ballardw
Super User

Do you need a running cumulative change for each patient?

How do you calculate change in viral load, change in a count or a percent or some other rate?       

PhanS
Obsidian | Level 7

Hello,

I will use log10 as well as actual values. I do not use percentage.

Re. cumulative changes, I will look for each subject as well as for the cohort.

Thanks,

Phan S.

ballardw
Super User

Might be time to post some dummy input data and the desired output(s) and what you did that you didn't like.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 504 views
  • 0 likes
  • 2 in conversation