Hello to all, In order to send files to external systems I have to do signons on some sas servers that communicate with external systems. In particular my problem lies in the fact that during the signons with which I copy files from one server to another I can not solve the variable macro with the file name. Attached is the sample code. The resolution function in the first signon in the second no Will someone please help me? %macro invio; proc sql; create table INSPECTION_FOR_SPM as select * from dati.HSEQ4A_KPI_X_SPM where Event_Date='202310'; quit; data _null_; date_=put(intnx('month',today(),-1),monyy7.); put date_; data_comp=compress(('SPM_KPI_HSEQALL_'||date_||'.csv')); put data_comp; call symput('file',data_comp); run; %let nome_file=&file.; %put nome file--------------->&file.; proc export data=INSPECTION_FOR_SPM outfile="/sasgrid/hseq/1_0/KPI_HSEQ4ALL_X_SPM/&nome_file." dbms=dlm replace label; delimiter='|'; run; /********************invio tramite sftp***************************/ filename locref "/sasgrid/hseq/1_0/KPI_HSEQ4ALL_X_SPM/&nome_file."; %let host=xxxxxxxxxx 7551; options comamid=tcp remote=host noconnectmetaconnection; signon userid="xxxxxxx\zsassystemuserdcc" password="{SAS002}03079E1140FD8F163EF93EB41335DE5D0D5A90AA49A7ED19"; %syslput file1=&nome_file.; rsubmit; options NETENCRALG=SSL; filename outref "G:\&file1."; Proc Upload infile=locref outfile=outref BINARY; run; data _null_; call symput('host','elaawgsasa12.global 17551'); run; options comamid=tcp remote=host noconnectmetaconnection; signon userid="sassrv" password="sassrvadm"; filename locref "G:\&file2"; rsubmit; filename outref "/sasgrid/hseq/1_0/KPI_HSEQ4ALL_X_SPM/&file2."; Proc Upload infile=locref outfile=outref BINARY; run; /* filename out sftp "/01_IMPORTED_KPI/&file2." host='ftp-enl.bravosolution.com' debug cd='/01_IMPORTED_KPI/' user='enlusr01160' optionsx='-i /home/sassrv/.ssh/SPM_PVTK.ppk'; data _null_; infile "/sasgrid/hseq/1_0/KPI_HSEQ4ALL_X_SPM/&file2." recfm=n ; input x $char1. @@; file out recfm=s; put x $char1. @@; run; */ endrsubmit; endrsubmit; %mend; %invio; ... View more

I have an output proc tabulate SAS (in attached an example), my customers want that I change all values lower than a specific,value in my case all value lower than 3 to frequency with a generic symbol(e.s '*') also values sum and average. In addition, if there is only one asterisk-marked value in the column (before the subtotal), you must also add an asterisk to the lowest value after 3 (excluding 0). Finally, if the column contains many values equal to 1 and the total can be attributed to them, you must also mask another value in that case; specifically, the lowest one. Someone can help me? Thank you ... View more

I have a daatset .sas7bdat and I need to convert the column format chart into varchar. If I create a structure table with SAS Studio receive this error:   One or more variables were converted because the data type is not supported by the V9 engine.   I understand that is necessary to create the table structure on Cas, but I don't know a way for insert the data on the table.   this is my code for insert dataset on CAS: proc cas; upload / path="&path/inspection_question_answer.sas7bdat" casout={caslib="hseq" name="HSEQ4A_INSPECT_ANSWER_QUESTION1" replication=0}; quit; proc casutil incaslib="hseq" outcaslib="hseq"; droptable casdata="HSEQ4A_INSPECT_ANSWER_QUESTION" quiet; promote casdata="HSEQ4A_INSPECT_ANSWER_QUESTION1" casout="HSEQ4A_INSPECT_ANSWER_QUESTION"; save casdata="HSEQ4A_INSPECT_ANSWER_QUESTION" casout="HSEQ4A_INSPECT_ANSWER_QUESTION" replace; quit;     But this table is actually very large and my client asked to convert char columns to varchar, but at the moment I can’t get it done     Any suggestions?   Thanks ... View more

Hello to all, I have to transfer a file from the sas server to another via SFTP connection. My system administrator installed the private key on the server. I try to run the following code:   filename out sftp "SPM_KPI_HSEQALL_MAY2023.csv" host='XXXXXXX' debug cd='01_IMPORTED_KPI' user='XXXXX' optionsx='-i  /home/risorse/asea007/.ssh/SPM_PVTK.ppk -pw "XXXXXX"'; data _null_; infile "/sasgrid/hseq/1_0/SPM_KPI_HSEQALL_MAY2023.csv" recfm=n ; input x $char1. @@; file out recfm=s; put x $char1. @@; run;   Can you help me figure out if there’s something wrong with the code?   Thank you ... View more

Dear All, I have to write an excel file in a s3 bucket. From the SAS manual I read that you can use the S3 proc, specifying some parameters like : %let access_key = "XXXXXXXXXXXXXXXXXXXXXXXXXX"; %let secret_key = "XXXXXXXXXXXXXXXXXXXXXXX";   The administrator of bucket s3 gave me only the bucket and no other information because he thinks it is not necessary, as my SAS server is authorized both in writing and in reading. Can I do this in SAS? If so, how can I do it? Thanks to those who can answer ... View more