Home

Puspita_1

Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value.

bhr-q

Hello, I want to create just Xbar chart for LOS(hours) quartely with 8 subgroups using SAS., I used XSCHART , it will give me both both X-bar and S charts together. Same for XR chart. but I only want to have X-bar chart. I also cannot use only xchart in my SAS code as xchart is used for individual data not for subgroup data. How can I adjust my SAS code to see only the X-bar chart in my output? proc shewhart data=MIS; xSchart LOS*AdmitYYQ / Markers outtable=outtable ; run; Attached is the output to see both are in the same frame. Thanks

Jeff_DOC

Good morning. I'm hoping some can help because I'm out of ideas. I'm attempting to use ODS Excel to place the page number and number of pages in the footer at a right justify. I've tried the three different methods in the example below. I've done some searching and found some information but can't seem to get it to work. I get warning messages such as: WARNING: Apparent symbolic reference R not resolved. WARNING: Apparent symbolic reference P not resolved. WARNING: Apparent symbolic reference N not resolved. Can anyone give me a hint as to what I may be doing wrong here? options(sheet_interval = 'none' sheet_name = 'Sheet Name' frozen_headers = '2' row_repeat = '1-2' suppress_bylines = 'yes' autofilter = 'all' pages_fitwidth = '1' pages_fitheight = '50' /* print_footer = '&R &P & of &N'*/ /* print_footer = 'Page &P & of &N'*/ print_footer = "Page &R &P of &N" /* print_footer = "&;LInstitutional Research and Assessment &R Page &P of &N &Z &F"*/ absolute_column_width = '12, 30, 30, 18, 10, 10, 12, 50');

CJJC

Good day everyone, New EG user here. I am working with a legacy program that looks for lab errors. The numeric errors are assigned a number that represents a letter code. Error #14 has been changed at the lab into 14A and 14B, which results in log notes stating "Invalid numeric data, "14A", at line 115 column 78. How can I edit the code to prevent this? ****import parameter files***; %macro newdata (outfile, filename,param,param_g,param_error, param_a); data first; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile &filename delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ; informat year best32. ; informat month best32. ; informat day best32. ; informat labid best32. ; informat &param_g $2. ; informat &param best32. ; informat &param_error best32. ; informat &param_a $2. ; *informat labsignoff $3. ; format year best12. ; format month best12. ; format day best12. ; format labid best12. ; format &param_g $2. ; format &param 7.3 ; format &param_error best12. ; format &param_a $2. ; *format labsignoff $3. ; input year month day labid &param_g $ &param &param_error &param_a $ ;*labsignoff $ ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; proc sort; by labid year month day; data &outfile; set first; if &param_error = 0 then do; &param_A = "";end; if &param_error = 23 then do; &param_A = "QQ";end; if &param_error = 1 then do; &param_A = "A"; &param = .; end; if &param_error = 22 then do; &param_A = "JJ";end; if &param_error = 18 then do; &param_A = "RR";end; if &param_error = 6 then do; &param_A = "RR";end; if &param_error = 9 then do; &param_A = "V";&param = .;end; if &param_error = '14A' then do; &param_A = "FF";end; if &param_error = '14B' then do; &param_A = "V"; end; *proc print; %mend; Thanks for considering this puzzle.

NewUsrStat

Hi guys, suppose to have the following dataset: data DB; input ID :$20.Admission:date9. Discharge:date9. Diagnosis :$20.; format Admission date9. Discharge date9.; cards; 0001 06DEC2014 14DEC2014 VIRUS_A 0001 08NOV2020 11NOV2020 FLU 0004 14MAY2014 02JUN2014 FLU 0004 30JUN2015 15AUG2015 FLU 0004 16FEB2019 18FEB2019 VIRUS_A 0005 10AUG2019 11SEPT2019 FLU .... ; I have to fit a time-series model to estimate the weekly number of hospitalizations for VIRUS_A. The dataset shown is just an example of the real dataset. I don't know how to set the "weekly" from the admission dates I have (I have also discharge dates). The study starts on 2014 but some patients are hospitalized after the start others at different months of the 2014. Moreover, does the week number start from the 01 January? If yes, what's happens if 01 Jan is in the middle of the week? Apart the practical SAS programming, I also have not clear the theory behind mapping dates to weeks. It's the first time I deal with this data and questions. Thank you in advance