Hi   I have to read/copy the  XLS file Sheet 1 having image content and sheet 2 having  records from source location, copy it to destination Location, while copying xls file at destination(SAS Server) the file getting corrupted, please could any one help me       file name expfile ref ftp  "& file.xls"  cd= path     data _null_; infile expfile NBYTE=n; INPUT; file "/serverpath/file.xls" recfm=n; put _INFILE_ @@; run; ... View more

file name expfile ref ftp  "& file.xls"  cd= path     When I am copying file to this location , its getting corrupted as the Xls file 1st tab has image file in it, please let me know if I can Use ODS to read the Image file. Thank you. data _null_; infile expfile NBYTE=n; INPUT; file "/serverpath/file.xls" recfm=n; put _INFILE_ @@; run; ... View more

SFTP code working fine but Image Xls file is getting copied to destination web  server, but XLS file getting corrupted as   it couldn't read imagetab. ... View more

%lET FNAME = %SYSFUNC(CATS(DER_EXTRACT_MONTHLY_DECSIONDATE_,%SYSFUNC(TODAY(), MMDDYY6. ),_,%SYSFUNC(YEAR("&SYSDATE"D)),%SYSFUNC(MONTH("&SYSDATE"D)),%SYSFUNC(DAY("&SYSDATE"D)),%SYSFUNC(TIME(), HHMMSS6.),.CSV)); %PUT &FNAME.; i WAS TRYING TO GET THIS FINALLY RESOLVED IT, Thank you every one ... View more

der_extract_monthly_decisiondate_030418_20180303235454.csv yes 6 digit and 14 digit part vary and file name remains the same. Thank you. ... View more

Actual Name of the file   der_extract_monthly_decisiondate_030418_20180303235454.csv   As this is the monthly file datetime cahnge every month. ... View more

I have to read this actual file der_extract_monthly_decisiondate_030418_20180303235454.csv and the should generated as der_extract_monthly_patsiondate.csv date and time may vary every month.   Import    der_extract_monthly_decisiondate_030418_20180303235454.csv    file with  Date and generate it as          der_extract_monthly_decisiondate.csv   %let fname =der_extract_monthly_patsiondate_%sysfunc(date(030418_20180303235454).csv This may change every month how to hardcode this (date(030418_20180303235454) %sysfunc(date(030418_20180303235454)SourceFile1 = "der_extract_monthly_decisiondate_" & Convert_Date(Run_Date) & "*" & ".csv" SourceFile1 = "der_extract_monthly_decisiondate_" & Convert_Date(Run_Date) & "*" & ".csv" NewNameFile1 = "der_extract_monthly_decisiondate.csv" ... View more

This may change every month how to hardcode this %sysfunc(date(030418_20180303235454) SourceFile1 = "der_extract_monthly_decisiondate_" & Convert_Date(Run_Date) & "*" & ".csv" NewNameFile1 = "der_extract_monthly_decisiondate.csv"   ... View more

Do we have any alternate method in SAS instead of USing SFTP in SAS filename my data sftp "/Dir/RPTS/qtr/&CSV_file" host="hostname" user="username"; ... View more

converting SAS EG 5.1 code on SAS EG 7.1 OPTIONS FMTSEARCH=(userfmt); 31 libname userfmt "/ced_d/shared2/qcpap72ydir/sas_userfmt"; NOTE: Libref USERFMT was successfully assigned as follows: Engine: V9 Physical Name: /ced_d/shared2/qcpap72ydir/sas_userfmt 32 33 %put &Run_Date; 030618 34 data _null_; 35 header = 'clinipoint_CD_and_RD'; 36 37 run_date = "&Run_Date"; 38 substr(run_date,3,2) = '01'; 39 40 month = substr(run_date,1,2); 41 day = substr(run_date,3,2); 42 year=substr(run_date,5,4); 43 44 MonthName = put(month,$monthMMM.); __________ 484 ERROR: File LIBRARY.FORMATS.CATALOG was created for a different operating system. ERROR: File USERFMT.FORMATS.CATALOG was created for a different operating system. NOTE 484-185: Format $MONTHMMM was not found or could not be loaded. 45 report_month = compress(MonthName || '_' || Year); 46 2 The SAS System 17:40 Tuesday, March 6, 2018 47 put MonthName; 48 put Year; 49 put report_month=; 50 51 call symputx('header',header,'g'); 52 call symputx('report_month',report_month,'g'); 53 run; ... View more