About ojaro

SASKiwi · ‎11-20-2022

@Gordhan - Have you looked at the links provided in this post?

Reeza · ‎05-10-2022

data _null_; set work.base64 end=eof; file payload mod; *quote for start of line; if _n_=1 then put('"'); *data written to file; put trim(text)+(-1)@; *write end quotes; if eof then put('"'); run; Something like this, roughly?

ojaro · ‎02-23-2022

Thanks @Kurt_Bremser . Using the include worked perfectly.

ojaro · ‎12-02-2021

Thank you so much! This works perfectly.

ojaro · ‎11-20-2021

Big thanks for the pointers. I figured the last part out. This is the code that does what I am after: data work.is_fmt(keep=start label fmtname); set work.is_fmt; fmtname='$IS_FTM'; run; proc format library=work cntlin=work.is_fmt; run; data work.incident; set vidata.Incident; incident_subject=put(incident_subject, $IS_FTM.); run;

Tom · ‎05-21-2021

Typically you do not need (or want) to add macro quoting to the parameter values also. Just the macro call. Also using the CATS() function to help generate the string to pass to CALL EXECUTE() will automatically trim the trailing spaces from the values of FILENAME variable. If nothing else it will make the SAS log easier to read. data _null_; set mcdtemp.mc_files; call execute(cats('%nrstr(%parse_datafiles)(',filename,');')); run;

ojaro · ‎05-18-2021

Hi Tom, Thanks for these suggestions. Good to know regarding the truncation. I did manage to trace the issue all the way back to the source in the end, so I have gone back to the API owners highligting the issue. It must be that the Python CSV reader is just extra sensitive, since all earlier steps (including reading JSON in Python as a text file) worked without any errors. Cheers, Olli

ojaro · ‎07-16-2020

Looks like this macro was what I was after: %dqputloc(enusa);

PaigeMiller · ‎07-01-2020

You're welcome, @ojaro. Please consider my comment earlier about how the average computed this way is biased because officers with zero complaints are not included in the denominator.

ojaro · ‎06-26-2020

Thanks so much for explaining how SAS data step executes. I can confirm that by changing my code to use CALL EXECUTE, I can see the desired effect. Thanks again, Olli

ojaro · ‎10-23-2019

Hi Alexal, I have the same issue with sas-cleanutils. If I do: ls -ld /sas_repos/repos/shipped/va/110/va-110-x64_redhat_linux_6-yum/repodata/repomd.xml it returns: -rw-rw-r--. 1 sas sas 2162 Oct 22 02:09 /sas_repos/repos/shipped/va/110/va-110-x64_redhat_linux_6-yum/repodata/repomd.xml So the files seem to be there. I also redownloaded esm-110-x64_redhat_linux_6-yum, in case the download had got corrupted, but still the same issue. Any ideas what I could try next? Best regards, Olli

joeFurbee · ‎05-13-2019

Hi Olli, I was able to reproduce your error using both Python and REST. At this point, I'd recommend opening a ticket with SAS Technical Support.

Online Status	Offline
Date Last Visited	‎11-22-2022 01:19 PM

Re: Reading a whole text file in a single row in SAS dataset

Re: Reading a whole text file in a single row in SAS dataset

Re: Reading a whole text file in a single row in SAS dataset

Re: Reading a whole text file in a single row in SAS dataset

Reading a whole text file in a single row in SAS dataset

Re: Reading macro variable value in proc fcmp

Reading macro variable value in proc fcmp

Re: Replacing all line breaks in CSV export

Replacing all line breaks in CSV export

Re: Assigment of macro attribute when macro as return value

Re: Reading a whole text file in a single row in SAS dataset

Re: Reading a whole text file in a single row in SAS dataset

Re: SAS Viya 3.5 Deployment fails - Unable to determine the address of...

Re: Reading a whole text file in a single row in SAS dataset

Re: Reading macro variable value in proc fcmp

Re: Replacing all line breaks in CSV export

Re: Assigment of macro attribute when macro as return value

Re: Using macro variable for partial dataset name does not work with b...

Re: UTF-8 encoding issue when writing REST API content to CSV

Re: List available standardization definitions for a SAS Quality Knowl...

Re: Proc SQL count and missing values

Re: Wait for macro to finish

Re: installation problem with viya 3.4

Re: extractDetectedObjects _nObjects_ is missing or object detection c...