Hello SAS ppl I am trying append the data in sql server using sas. I was using below libname passthrough for appending the data. But while appending all the blank columns are converting into NULL in sqlserver. I see we can use NULLChar = SAS|YES |NO But I am not able to get them properly can some one please help. How I can use this NULLCHAR ? Libanme sqlserver ODBC DSN =XXXXX SCHEMA =XXXXX UID=XXXX PWD=XXXX IGNORE_Read-only_column= YES INSTERBUFF= 10000; PROC APPEND BASE = sqlserver.table_want data=inputdata ; Run ... View more

Hello SAS people I have question I am using a append to load the data in odbc SQL server I was using the libname statement as below to append some 8.5 million data with 100 columns which is working fine but taking around 1 hour to complete the load. Do you think it is there a way to optimize it? Shall I increase the INSERTBUFF to 100,000? Or any bulkload things please suggest. Libname mylib ODBC DSN=XXX schema= xxx UID=XXX PWD=XXX IGNORE_READ_ONLY_COLUMNS= YES INSERTBUFF= 10000 ... View more

Hi guys My data is like Id. Name $ 10 Doj :date9. dot:date9.; 11235 Jim 12jul2017 01auj2018 11235 Jim. 12jul2019 01auj2019 11235 Jimcarod 12jan2020 01feb2020 11235 Jimcarod 12jul2020 01auj2020 My code should replace all the row with name Jimcarod . As its is the latest entry and have same id ... View more

Hell all , I'm looking to get the column headers name in other dataset based on the flag . Please see the attached pdf for the requirements. Do we have any options to create it please let me know thanks in advance. ... View more