BookmarkSubscribeRSS Feed
mariamon0
Fluorite | Level 6

I want to be able to have an output where it shows all the goal values. Every day a person had a goal. I want to show the daily goals after my randomization_date variable for each individual person (study_id) for up to 1 year. The randomization_date is a date. goal is numeric.

data web.webfinaldataset

set web.webfinal

day=intnx('day', randomization_date,1);

run;

proc print web.webfinaldataset;

var goal date

by study_id;

run;

1 REPLY 1
PaigeMiller
Diamond | Level 26

Show us a portion of the input data set.

 

Show us the desired output that corresponds to the portion of the input data set you showed.

--
Paige Miller
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 522 views
  • 0 likes
  • 2 in conversation