Hi, I'm getting a NOTE: Invalid numeric data, Disposition='TREATED TRANSPORTED', at line 353 column 8.   I have the following code:   data new; set test; if Disposition= 'Canceled, No Patient Contact' then Disposition= 'Canceled'; if Disposition= 'Unresponsive– Pronounced' or Disposition eq 'dead' then Disposition='Dead'; if Disposition= 'Treated Transported' or Disposition= 'Treated and transported' then Disposition='TREATED TRANSPORTED'; if Disposition= 'Treated and Released (per protocol)' then Disposition='Treated and Released'; run;     NOTE: Invalid numeric data, Disposition='TREATED TRANSPORTED' , at line 353 column 8.   I looked at other previous responses to Invalid numeric data errors, but I didn't get the answer for this. I tried all the suggestions but they didn't work for my code.   Can anybody help me with this.   Thank you M ... View more

Hi, I have a dataset with county and complaint variables. I want to get the top 5 complaints by county.   E.g.   County       Complaint                         Count           ABC          sick                                     100           DEF          Sick                                   200           ABC          Chest Pain                          200           DEF          Chest Pain                          300           ABC         Heart problem                    500   I want to get 10 5 complaints for each county  E.g for County ABC SICK, CHESTPAIN, HEARTPROBLEM, BREATHING PROBLEM and EYE PROBLEM are top 5 then I want the list of the county name with top 5 complaints and the count of it.   Can I get any help. I did proc freq and got the list of all complaint by County but not sure how to get the top 5 only for each county.   Thank you M ... View more

Hi, I'm using Proc Univariate to calculate 90th percentiles for the response time (hh:mm:ss). I'm getting the 90th percentiles in minutes only, I want it in seconds as well in mm:ss format. How can I get the percentiles in mm:ss format. Also can anyone explain me the math behind calculating 90th percentile using proc univariate. My code is   proc univariate data=new; by county; var response; output out=test pctlpre=P_ pctlpts=50,90 pctlname=P50 P90 Mean=MEAN std=STDDEV ; run;   thank you M ... View more

Hi, I need help on SAS datetimes. I always struggle with datetimes in SAS. I need to find a difference of two datetimes and then delete times that are <0 and >60 minutes.   I know how to find the difference, here's ,my sample code. I have two Time variables with datetime1=01OCT17:16:11:30  and datetime2=01OCT17:16:16:50.   Date new;                 Set have;                 Time1=timepart(datetime1);                 Time2=timepart(datetime2);                 Format time1 time2 time.;                 Diff=time2-time;                 Format diff time8.;                 If diff <=0 and diff >60 then delete; (I’m having problem here, as it has seconds and the diff variable is not a whole number.) Run;   How can I get the output in 00:30:05 format and delete <0 and >60 minutes and get the 90th percentiles in 00:30:05 format (include minutes and seconds).   Thank you M ... View more

Hi, I tried using the code in this thread for xml conversion, I got the following error. 7 filename xx temp; 8 libname xx xmlv2 'C:\Users\mgs\Desktop\ems1.xml' automap=replace 8 ! xmlmap=xx; ERROR: The creation of the XML Mapper file failed. ERROR: Error in the LIBNAME statement. 9 proc copy in=xx out=work; 10 run; ERROR: Libref XX is not assigned. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.00 seconds   can you suggest, what went wrong in the code.   Thank you M cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. NOTE: Parsing with high validation. WARNING: XMLMap parser encountered XML issue Exception class: org.xml.sax.SAXParseException ID: <null> Message: schema_reference.4: Failed to read schema document 'http://nemsis.org/media/XSD_v3/_nemsis_v3.3.4/3.3.4.140328/XSDs/NEMSIS_XSDs_v3.3.4.140328/EMSDataSet_ v3.xsd', because 1) could not find the document; 2) the document could not be read; 3) the root element of the document is not <xsd:schema>. Line: 2 Column: 248 ... View more