Dear Mentors,   I am running a piece of code vis shell script through putty which uses the below line:   INPUT(PUT(DATEPART(A1.Date), YYMMDD8.), YYMMDDN8.)   and I am getting error as below:   ERROR: The informat YYMMDDN was not found or could not be loaded.   However, when i ran the same code in SAS Studio, it runs smoothly.   Please help.   Thanks in Advance.   Sandeep ... View more

Hello Everyone,   I am stuck at a point where I need to transfer CSV files generated from sas to db server location. Below are the details:   I am using Sas 9.4 and below process will be run on batch via control M.   SAS server: 10.20.30.40 Csv file location: /sasdata/test.csv   Db server: 10.20.30.50 Csv transfer location: /test1/test2/test.csv   I have tried "filename outfile sftp" but stuck at primary key think (no knowledge about this).   Below is the code that I tried:   Filename outfile sftp 'test.csv' cd='/test1/test2/' Host='10.20.30.50' options="-oport=22" user="username" debug;   Proc export data=test outfile=outfile dbms=csv replace ;run;   Error: host key verification failed. Couldn't read packet: connection reset by peer.   Please provide your valuable suggestions.   Thanks ... View more