I have this dataset and I want to produce a bar chart like this      Can you please help me with this my first time doing a bar chart   Obs Site_Initiated Site_Approved1 Date_Supplied4 site_contracted 1 39 6 7 34     ... View more

Hi,  I'm trying to rotate my data and this is my first time doing this.  Please edit my code if you can  this is the data set that I have                        Obs case_assigned Time_points_read Time_points_complete Readable_Time_Points Time_Points_Pending off_study off_study_Total 1 5 53 1360 15 15 0 0   and this is the result that I got  Obs case_assigned Time_points_read Time_points_complete Readable_Time_Points Time_Points_Pending off_study off_study_Total i vv vs 1 5 53 1360 15 15 0 0 1 5 Cases Assigned 2 5 53 1360 15 15 0 0 2 53 Cases Assigned 3 5 53 1360 15 15 0 0 3 1360 Cases Assigned 4 5 53 1360 15 15 0 0 4 15 Cases Assigned 5 5 53 1360 15 15 0 0 5 15 Cases Assigned 6 5 53 1360 15 15 0 0 6 0 Cases Assigned 7 5 53 1360 15 15 0 0 7 0 Cases Assigned   and this is the aim    vv vs 5 Cases Assigned 53 Time_points_read 1360 Time_points_complete 15 Readable_Time_Points 15 Time_Points_Pending 0 off_study 0 off_study_Total and this is my code  data rotate; set table4; array var{7} case_assigned Time_points_read Time_points_complete Readable_Time_Points Time_Points_Pending off_study off_study_total; do i=1 to 7; if var{7} ne . then do; vv=var{i}; vs= ("Cases Assigned" ); output; end; end; run;   ... View more

I'm experiencing problem using first. and if statement    this is the code that I'm using  proc sort data=&Queries.2; by status category; run; data &Queries.5; set &Queries.2; by status category; retain numcat 0; if first.category and status="Open" then do; numcat+1; if last.category and status="Open"; end; else cat=0; cat=numcat; keep status category cat numcat; run;   and I'm not getting the result that I want I want to count the number of distinct category only when status="Open" but  what I'm getting here it the code start to count every thing after  status="Open"   which I don't desire to have. I want unreasonable to be 0 in both cat and numcat       Obs Status Category numcat cat 38 Closed Unblinded Data 0 0 39 Closed Unblinded Data 0 0 40 Closed Unblinded Data 0 0 41 Open Missing Images 1 1 42 Open Other 2 2 43 Unresolvable Missing Images 2 2 44 Unresolvable Missing Images 2 2 45 Unresolvable Missing Images 2 2 46 Unresolvable Missing Images 2 2 47 Unresolvable Missing Images 2 2 48 Unresolvable Missing Images 2 2 49 Unresolvable Scan Region 2 2         ... View more

I want a way to create sas7bdat files which are compatible with version 9.0  I'm using SAS 9.4 version  ... View more