topic Re: change all time variables to character with array in New SAS User

change all time variables to character with array

jenim514 — Fri, 30 Nov 2018 22:07:16 GMT

Hi,

I have a dataset with multiple timepoints in each observation (eg. lbtim1 lbtim2 lbtim3...). They are all in time5. numeric format.

How can I change all of these to character format (TOD5.)?

All of the time variables have the same prefix 'lbtim' with the timepoint. Here is what I started with:

data prsupp;
set db.lbi;

array timn (*) lbitim:;
array timc (*) lbtimc:;
do i= 1 to dim (timn);
if ~missing (timn(i)) then timc(i)=put(timn(i),tod5.);
end;
run;

I guess it's something with the new character variables I'm trying to create. Or can I just overwrite the numeric variables to character somehow?

Help is appreciated!

Re: change all time variables to character with array

novinosrin — Fri, 30 Nov 2018 22:13:07 GMT

array timc (*) lbtimc:; This is a new assignment, so if i am right, you can't use var lists

rather array timc (count of lbtimb)

Re: change all time variables to character with array

SASKiwi — Fri, 30 Nov 2018 23:26:44 GMT

Why do you need to convert your time variables to character? You can assign the TOD5. format to them without converting.