About EEEY

EEEY · ‎05-01-2019

Just my vendor is very picky about it and need the cursor stops at the end of data. with the code below, If i open it in TextPad, the cursor ends at the last position when you click the blank area in the file. Thanks so much for your comments!!!

EEEY · ‎05-01-2019

This is working and exactly what i needed.. Really appreciate your help Ksharp!

EEEY · ‎05-01-2019

I need to rephrase the issue. the file looks fine, only except the cursor ends at the 1st position of next row of data if opening it in TextPad. . I wanted the cursor to end at the last position of last row of data, and not going to the next row. Any suggestions?

EEEY · ‎05-01-2019

Thanks Tom. Yes thanks for simplying my code. Basically I have 70+ fields in my original program.. After the simplified version, I still have the same problem.

EEEY · ‎04-30-2019

Hi, I am creating a Pipe delimited CSV file in SAS EG. Everything looks fine only except the end of the file, it created a empty row. Can anyone help me out. My program is like this: %MACRO OUTPUT_HEADER(COUNT=); %DO I = 1 %TO &COUNT; H&I +(-1) '|' %END; %MEND OUTPUT_HEADER; DATA _null_; SET test ; File "&OUT/test_20190429.CSV" dlm='|' dsd lrecl=800; If _N_=1 then Do; H1 = 'ClientID'; H2 = 'RegionID'; H3 = 'Name'; Put %OUTPUT_HEADER(COUNT=2) H3; End; Put ClientID +(-1) '|' RegionID +(-1) '|' Name; Run; For some reason, there is always one empty rows at the bottom of file. Any suggestion? Thanks, EEEY

EEEY · ‎04-11-2019

Thank you so much everyone for your reply on my questions. I was able to find the final solution. Basically the public key I provided should be the public key on the SAS server /.ssh/ir_rsa.pub file. Instead my IT ppl guided me to generate a public/private key in Windows. If they did the key pair correctly, I did not need to provide my private key to the target server and specify in my SAS program. The other issue we had was that the Port number at the target server is not standard one so I need to specify in my program. The syntax i finally use is like below. Hope someone in this community could be benefited from this: filename attn 'path of source file/test.csv'; filename outfile sftp 'path of source file//test.csv' cd ='directory' options="-oPort=1784" host="host_name" user="user_name" lrecl=800 DEBUG ; /**in case in need of private key - -options="oIdentityFile=location of private key on SAS server/.ssh/id_rsa -oPort=1784*/ data _null_; infile attn lrecl=800; file outfile lrecl=800 ; input; put _infile_; run; filename attn clear; filename outfile clear;

EEEY · ‎04-09-2019

Thanks Tom. I tried the X command but it did not really do anything. still got the same error about : ERROR: Directory or file /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv doesn't exist. I am sure that the file and the path of original file is absolutely correct. One question - do I need to ask my SAS admin to authorize the target server's public key?

EEEY · ‎04-08-2019

I removed the space in the Options. the log seems a little different than last time, saying my private key are too open.It is recommended that your private key files are NOT accessible by others.This private key will be ignored.bad permissions: ignore key: /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/private_key_a135929.ppkssh_askpass: exec(/opt/quest/libexec/ssh-askpass): No 2 The SAS System such file or directoryPermission denied, please try again.ssh_askpass: exec(/opt/quest/libexec/ssh-askpass): No such file or directoryPermission denied, please try again.ssh_askpass: exec(/opt/quest/libexec/ssh-askpass): No such file or directoryPermission denied (publickey,gssapi-keyex,gssapi-with-mic,password).Connection closed NOTE: cd /hrtoaxion ERROR: Directory or file /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv doesn't exist. NOTE: 0 records were read from the infile ATTN. NOTE: The SAS System stopped processing this step because of errors. I don't know what I should do about it. Regarding your 2nd recommendation - Since they don't support SSH, I can't really use command in Putty to connect to the target sever and test. Argh..

EEEY · ‎04-08-2019

Please see my response in Italic below. 1. Can you send files outside of SAS? What syntax and options do you use to connect outside of SAS? Can you use the same options in SAS? - Yes. I used WinSCP to test and was able to connect and send the file. But I create the file in SAS and need to automate the process including the file transfer. 2. Have you registered the keys? Something like this: https://www.jscape.com/blog/setting-up-sftp-public-key-authentication-command-line - We did the key pair and they added my public key and my private key. One thing I want to point out (but not sure if it caused the failure because of this) is that the target server does not support SSH connect. So I could only test the connect in WinSCP but not in Putty.

EEEY · ‎04-08-2019

am I supposed to this below? options="-oIdentityFile = /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/private_key_a135929.ppk" I got the same error.

EEEY · ‎04-08-2019

thanks ChrisNZ for your response. But I saw another thread using this option as a solution. How to check what options can i use in SAS, specifically using private key? The SAS document did not have that details. Thanks a lot!

EEEY · ‎04-08-2019

Hi, I am trying to transfer a file from my SAS server (SAS 9.4 on Unix) to a Linux(Hadoop) environment. We were able to test to connect and file transfer through WinSCP. But I needed to add my Private Key in order to connect to the Linux server when using WinSCP. I am wondering how to do this in the Filename SFTP syntax in SAS. I referenced another question in this community but it still did not work. Please help. My program: filename attn '/apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv'; filename outfile sftp '/apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv' CD ='/hrtoaxion' options="-p = 1000 -i = /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/private_key_a135929.ppk" host="host_name" user="username" lrecl=800 DEBUG ; data _null_; infile attn lrecl=800; file outfile lrecl=800 ; input; put _infile_; run; The error log as bellows: NOTE: The infile ATTN is: Filename=/apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv, Owner Name=a135929,Group Name=nawim, Access Permission=-rw-r--r--, Last Modified=29Mar2019:17:02:48, File Size (bytes)=787 NOTE: sftp: illegal option -- pusage: sftp [-1Cv] [-B buffer_size] [-b batchfile] [-F ssh_config] [-o ssh_option] [-P sftp_server_path] [-R num_requests] [-S program] [-s subsystem | sftp_server] host sftp [user@]host[:file ...] sftp [user@]host[:dir[/]] sftp -b batchfile [user@]host NOTE: cd /hrtoaxion ERROR: Directory or file /apps/sas/datasets/data30/NAWIM/Elaine/WO/EHS/Reports/test.csv doesn't exist. NOTE: 0 records were read from the infile ATTN. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 1.51 seconds cpu time 0.01 seconds

EEEY · ‎08-31-2017

I want to count July 4th as a work day.. so I am counting weekdays.

EEEY · ‎08-31-2017

No, Chris..Actually I don't want to consider any holidays even July 4th.. I just want to count every day Mon - Fri, except Sat and Sun

EEEY · ‎08-31-2017

Is there a better function I can using so that Sat and Sun can be considered two days and to get the result I wanted, eg, how to make intck('WEEKDAY', '02jul2016'd , '05jul2016'd ) =1?

Online Status	Offline
Date Last Visited	‎09-15-2022 05:23 PM

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

prevent creating a new empty row at the bottom of the file

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

Re: How to use Private Key in Filename SFTP

Re: How to output a dataset into Text file with multiple header and tr...

Re: How to output a dataset into Text file with multiple header and tr...

Re: How to use Private Key in Filename SFTP

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

Re: prevent creating a new empty row at the bottom of the file

prevent creating a new empty row at the bottom of the file

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

Re: How to use Private Key in Filename SFTP

How to use Private Key in Filename SFTP

Re: How does intck weekdays work?

Re: How does intck weekdays work?

Re: How does intck weekdays work?