About Qvika

Sam_SAS · ‎10-13-2020

Hello, A calculated item that computes periodend - periodstart should yield the number of days between the two dates. Because the numeric minus operator expects a number, you need to use the TreatAs() operator to perform subtraction on the date variables. That will look like this: TreatAs(_Number_, 'periodend'n) - TreatAs(_Number_, 'periodstart'n) The Schedule Chart object might also be of interest here, if it is available in the version of VA that you have. Let us know if that helps, Sam

Qvika · ‎10-13-2020

Thank you so much Mark! that helped a lot. But now when I try to add additional data my IF-THEN statement refuses to work. This is my code: DATA newperiod; IF ID=200 then do periodID=1, 2, 3; output; end; else IF ID=200 AND periodID=1 then do; kidperiodstart=150; kidperiodend=350; end; else output; RUN; The AND statement is not highlighted, how do I get this to work?

Online Status	Offline
Date Last Visited	‎10-14-2020 11:27 AM

making bar chart from time intervals

Re: adding new data to existing variable

adding new data to existing variable

Re: adding new data to existing variable

Re: making bar chart from time intervals

Re: adding new data to existing variable