About Qvika

Qvika · ‎10-13-2020

Hi, I am having trouble making a bar chart from time intervals. I have a start date (periodstart) and an end date (periodend) per customerID and I would like to make a bar chart per month from this data. The problem is that I don't know how to create an interval and that an interval can contain multiple months. Can somebody help me with this? My dates look like this: ID periodstart periodend 200 10JAN2018 15MAR2018 201 21FEB2018 14DEC2018

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?

Qvika · ‎10-12-2020

Hi, I am trying to add new observations in my data set in an existing variable, but it does not seem to work. I have a variable called ID (identification number) and a variable called periodID (1-5), so I can add different periods per ID. Some ID's only have 1 periodID line where I would like to have 2 or 3, but I can't seem to add more lines (called periodID 2 and periodID 3). I am working from a pre-existing work.query. So I tried to make a new data set: DATA newperiod; SET oldperiod; IF ID=200 THEN periodID=1, 2, 3; RUN; This gives me an error. Does somebody know how to fix this problem?

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

making bar chart from time intervals

Re: adding new data to existing variable

adding new data to existing variable