About Balli

Balli · ‎09-04-2023

Hi All, We are running SAS Viya on Unix and every time I create a file on SAS Studio, I need to manually download the file into windows. I am somehow trying to automate this. Any idea what code runs in the background when you right click on a folder in SAS Viya and chose Download File ? Or if anyone knows an alternate solution to automate the download of files from SAS Studio to Windows directory ? Kind Regards and Thanks in Advance 🙂

Balli · ‎07-20-2023

Thank Ksharp for your reply. It works 🙂

Balli · ‎07-20-2023

Thanks Tom for the detailed explanation.

Balli · ‎07-20-2023

Hi, I am trying to export some data into a TAB delimited file and it inserts space into every empty cell. How can we get rid of that space? Code: proc sql; create table test as select AccountID ,'P' as STATUS ,'' as AMOUNT ,'' as REASON_TO_REPORT from XYZ quit; data _null_; set test; file "&Out_File_Location./abc.txt" dlm=' '; if _n_=1 then put 'A B C D X'; put ACCOUNTID STATUS AMOUNT REASON_TO_REPORT; run; Results(Notepad++)

Balli · ‎05-09-2023

Thanks @HarrySnart , works like a charm 🙂

Balli · ‎05-09-2023

Hello Team, I am writing this python script to upload the files to SFTP and I want to dynamically pass the file name as a macro variable. Unfortunately we can not use the submit block inside a macro function. Can someone please help me with a solution ? or an alternative way to SFTP the files?

Balli · ‎03-01-2023

Thanks Rick 🙂

Balli · ‎03-01-2023

Thanks Chris. It helps 🙂

Balli · ‎02-27-2023

Hi, I am using GIT_COMMIT_GET function to get the commit date from Github history log. Unfortunately it is giving me a wrong date (10 years old) and when I look at the documentation, this function returns a time starting from 1970: Time – the number of seconds since January 1st, 1970 As the SAS dates start from 01 Jan 1960, this is giving me a wrong date. Any idea how this can be fixed ? %let GITBranch=Your_Local_Repository; data work.x; format time1 datetime.; LENGTH COMMIT_ID AUTHOR_NAME AUTHOR_EMAIL MESSAGE PARENT_IDS TIME $ 1024; N = GIT_COMMIT_LOG("&GITBranch."); DO I=1 TO N; RC = GIT_COMMIT_GET(I,"&GITBranch.", "id", COMMIT_ID); RC = GIT_COMMIT_GET(I,"&GITBranch.", "author", AUTHOR_NAME); RC = GIT_COMMIT_GET(I,"&GITBranch.", "email", AUTHOR_EMAIL); RC = GIT_COMMIT_GET(I,"&GITBranch.", "message", MESSAGE); RC = GIT_COMMIT_GET(I,"&GITBranch.", "parent_ids", PARENT_IDS); RC = GIT_COMMIT_GET(I,"&GITBranch.", "time", TIME); Time1=TIME; output; END; RC = GIT_COMMIT_FREE("&GITBranch."); drop N I RC; run;

Balli · ‎10-17-2022

Hi, I am trying to write my first SAS Viya job with task prompts. I have added three elements : Combobox, datepicker and a fileselector. I can correctly read the values for combobox and datepicker, however fileselector is somehow not giving me the expected results. Have pasted below code and Task prompt tabs from my job. Log: %put &COMBOREAL.; ANZ %put &DATEEXAMPLE; 03Oct2022 %put &FILESELECTOR.; [object Object] Code: %put &COMBOREAL.; %put &DATEEXAMPLE; %put &FILESELECTOR.; Task Prompt: <?xml version="1.0" encoding="UTF-16"?> <Task schemaVersion="7.2"> <Registration> <Name>DS</Name> <Description>Select the Client file to run default transfers</Description> <Version>5.2</Version> </Registration> <Metadata> <Options> <Option inputType="string" name="GroupCombo">Client</Option> <Option inputType="string" name="LabelCombo">Select the client name:</Option> <Option inputType="combobox" name="Comboreal" defaultvalue="Latitude" required="true"></Option> <Option inputType="string" name="Latitude">Latitude</Option> <Option inputType="string" name="ANZ">ANZ</Option> <Option name="GROUPDATE" inputType="string">Sale Date</Option> <Option name="dateEXAMPLE" inputType="datepicker" required="true" format="monyy7.">Choose a date:</Option> <Option name="GROUPFile" inputType="string">Select a file :</Option> <Option name="fileSelector" inputType="sasserverpath" pathType="file" required="true" > Choose the file to run through the default transfers.</Option> </Options> </Metadata> <UI> <Group open="true" option="GroupCombo"> <OptionItem option="LabelCombo"/> <OptionChoice option="Comboreal"> <OptionItem option="Latitude"/> <OptionItem option="ANZ"/> </OptionChoice> </Group> <Group open="true" option="GROUPDATE"> <OptionItem option="dateEXAMPLE"/> </Group> <Group open="true" option="GROUPFile"> <OptionItem option="fileSelector"/> </Group> </UI> </Task>

Balli · ‎06-23-2019

Thanks Kurt, this works using redirection of stderr to stdout and conditional processing. filename adv pipe "&cmd &inputFile. &location 2>&1"; data _null_; infile adv truncover; input; if index(lowcase(_infile_),'exception:') then do; error ' Process Failed with an Exception'; abort; end; run;

Balli · ‎06-19-2019

"The last line in your input will now contain the return code from your command." Does that mean I need to look for the return code in my input text file ?

Balli · ‎06-19-2019

Here my input is a text file and the pipe command creates an output file with same name as input but with different extension. I did not get the return code anywhere after adding echo.

Balli · ‎06-19-2019

One of our stored processes is using unnamed PIPE to run an exe file to parse addresses. Whenever it fails it logs a stderr output similar to the one below in the log and the process continues. We can not find out it failed until we look at the output or the log. How can we get our process to abort as soon as it finds stderr output from PIPE command ? filename adv pipe "&cmd &inputFile. &location"; Stderr output: Unhandled Exception: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Error 96: ERR_STAN_DLL_CALL_EXCEPTION. iPaf32.dll:FixLastLine

Balli · ‎02-19-2019

Hi Saslearner3, I know this is a very old thread but just wondering if you got it working somehow ? I am in a similar situation where we are getting a csv file password protected in a zip. Thanks

Online Status	Offline
Date Last Visited	‎09-13-2023 01:17 AM

Code to Download a File from SAS Studio (Viya)

Re: TAB delimited file Inserts Spaces in Empty Cells

Re: TAB delimited file Inserts Spaces in Empty Cells

TAB delimited file Inserts Spaces in Empty Cells

Re: Passing Parameters from SAS to Python Script

Passing Parameters from SAS to Python Script

Re: SAS Git function Provides a wrong date

Re: SAS Git function Provides a wrong date

SAS Git function Provides a wrong date

SAS Viya Job with Task Prompt - Unable to read serverpath

Re: TAB delimited file Inserts Spaces in Empty Cells

Re: TAB delimited file Inserts Spaces in Empty Cells

Re: SAS Git function Provides a wrong date

Re: SAS Git function Provides a wrong date

Re: Handling STDERR output from PIPE utility

Re: Passing Parameters from SAS to Python Script

Code to Download a File from SAS Studio (Viya)

Re: TAB delimited file Inserts Spaces in Empty Cells

Re: TAB delimited file Inserts Spaces in Empty Cells

TAB delimited file Inserts Spaces in Empty Cells

Re: Passing Parameters from SAS to Python Script

Passing Parameters from SAS to Python Script

Re: SAS Git function Provides a wrong date

Re: SAS Git function Provides a wrong date

SAS Git function Provides a wrong date

SAS Viya Job with Task Prompt - Unable to read serverpath

Re: Handling STDERR output from PIPE utility

Re: Handling STDERR output from PIPE utility

Re: Handling STDERR output from PIPE utility

Handling STDERR output from PIPE utility

Re: Import CSV Directly from Password Protected Zip FIle