About NJGIRL

NJGIRL · ‎08-11-2020

oh gosh, I should not have included the infile macro file name in the post as it has nothing to do with the issue.. just to clarify, we don't have the file name ending in a dot 🙂 Just for clarification, the preceding code is /* Bring in External Data */ %let file = xxxx_Current.csv; sorry for the confusion. Anyway, back to the issue -- Var10 has a . (dot) as a valid value in the csv file and I need to retain the . (. means a lab value is in normal range)

NJGIRL · ‎08-11-2020

Thank you, however, I know that &file. is a macro variable. ( I should not have included the macro variable in the example) I am referring to the infile statement itself -- it is converting var10 value in to a blank when the value = . and I need to retain the . (dot) because . is a valid value. I

NJGIRL · ‎08-11-2020

Hello, I am looking or a sample infile statement that will read in a csv file and preserve a value of . (dot) NOT convert the . to a blank. Thanks! data raw; infile "\\dfs\data\SAS\data\import\XXX\&file." dlm=';' dsd lrecl=32767 encoding=any missover; informat var1-var14 $200. var15 $500. var16-var19 $200.; input var1-var19 $; run;

NJGIRL · ‎06-08-2020

Great thanks! One last question: my footnotes are not displaying on the report with this code-- any ideas?? thanks!

NJGIRL · ‎06-08-2020

can you provide the syntax for 'startpage=no' ?? I am getting an error with this " options formdlim= '' startpage=no ;" I don't think 'startpage' is an option for sas EG (?)thank you!

NJGIRL · ‎06-08-2020

Hi all! Can anyone provide an option to eliminate the 'page break' text in between proc freq in the EG output window? Thanks! ps(I am unable to copy in an example)

NJGIRL · ‎08-12-2019

super cool! thanks!

NJGIRL · ‎08-12-2019

Yes, that's the issue: I can not find a default datetime format to accomplish this. I did look in recent posts but I can not find another similar, however, I will search again. Do you happen to remember the tittle of the post as I have seen several date/time issues discussed but none that specifically address formatting with slashes (and include time). I do have solution in mind but curious to see if there was some other creative ideas! thanks, take care!

NJGIRL · ‎08-12-2019

correct. It needs to be a datetime. thanks!

NJGIRL · ‎08-12-2019

Hi All! May I have suggestions on how to format a SAS date to this 12-05-2018 15:56. I need dashes not slashes 🙂 THANKS!

NJGIRL · ‎08-01-2019

Hello All! I am trying to read in an excel spreadsheet -- I am getting these 'funny' characters , which I believe is caused by ENTER key (?) . I have tried using the option ENCODING=Yes and SAS server UTF8 , which usually works, however this time I am stumped! I have attached an example of my results. Thank you.

NJGIRL · ‎11-16-2017

Hello, I need to change &sysencoding from 'wlatin1' to 'UTF-8' so that sas will keep Japanese characters 'as is ' and not change to question marks (ie ???) Caveat : I only want to do it for one program not the entire system. Can anyone help me out with the code to accomplish this? thanks!

NJGIRL · ‎09-14-2017

Hello, my log is returning this error: Delete files from "previous" directory and move files from "current" to "previous" directory. Delete any and all pre-existing input data sets, autogenerated SAS programs, and discrepancy reports. Execute SAS to generate *.sas7bdat data sets. ***SERIOUS ERROR DETECTED*** ERRORLEVEL = 2 any idea what this means?? thanks...

NJGIRL · ‎07-31-2017

thank you!

NJGIRL · ‎07-28-2017

PATIENT SKREAD CURRENT VISIT REMOVED PRIOR VISIT APPLIED OOW 0101 16 16APR2017:09:00 15APR2017:10:30:00 22 0101 20 20APR2017:09:00 19APR2017:10:30:00 22 HELLO, I am trying to expand the above output across the page. I would like it to 'spread out' more. here is my code: (thank you) ODS RTF FILE="&OUTFILE" STYLE=STYLES.TEST HEADERY=720 FOOTERY=720; ODS LISTING CLOSE; options linesize = 200 pagesize = 200; TITLE1 "&CLIENT"; TITLE2 "&PROJECT"; TITLE3 "Generated on &sysdate. for OOW Listing"; PROC PRINT DATA=OOW_1 NOOBS label; var pat skread removed lagapplied hours ; format lagapplied datetime20.; label pat = "PATIENT" skread = "SKREAD" lagapplied = "PRIOR VISIT APPLIED" removed = "CURRENT VISIT REMOVED" hours = "OOW" ; RUN; ODS RTF CLOSE; ODS LISTING;

Online Status	Offline
Date Last Visited	‎10-28-2021 07:40 PM

Re: Proc format to create a format from a dataset

Re: Proc format to create a format from a dataset

Proc format to create a format from a dataset

converting dataset to format

Re: proc import --excel worksheet

Re: proc import --excel worksheet

proc import --excel worksheet

Re: Macro -- resolve to blank

Re: Macro -- resolve to blank

Macro -- resolve to blank

Re: Using datetime variable in proc report

Re: Proc format to create a format from a dataset

How do I change the default Selected Server

Spot the non-consecutive values and update accordingly a different col...

Re: color code excel tabs

Re: how do I bold a column header in proc report? example?

Re: how do I bold a column header in proc report? example?

Re: Adding a Degree special character

Re: Infile statement is converting . (dot) to a blank and I need to p...

Re: Infile statement is converting . (dot) to a blank and I need to p...

Infile statement is converting . (dot) to a blank and I need to prese...

Re: Proc Freq output 'Page Break' text

Re: Proc Freq output 'Page Break' text

Proc Freq output 'Page Break' text

Re: Datetime conversion

Re: Datetime conversion

Re: Datetime conversion

Datetime conversion

Reading in ASCII help

Sysencoding

'SERIOUS ERROR DETECTED" ERRORLEVEL=2

Re: expanding linesize

expanding linesize