Using the ways listed below to call the SAS code in powershell script:   #Step 2: Execute the SAS code #Start-Process SAS -ArgumentList "-sysin ""C:\Users\apal1018\Desktop\Work\PHR automation\MY\Test.sas""" #Start-Process SAS -ArgumentList "-initstmt '%include ""C:\Users\apal1018\Desktop\Work\PHR automation\MY\Test.sas"";'" #Start-Process SAS -ArgumentList "-initstmt 'dm editor ""fileopen """"C:\Users\apal1018\Desktop\Work\PHR automation\MY\Test.sas"""""";dm ""SUBMIT;"";'" Start-Process sasoact.exe -ArgumentList "action=Submit datatype=SASFile filename=""C:\Users\apal1018\Desktop\Work\PHR automation\MY\Test.sas"" progid=SAS.Application.940"   Getting same error everytime:  PS C:\Users\apal1018> Start-Process sasoact.exe -ArgumentList "action=Submit datatype=SASFile filename=""C:\Users\apal1018\Desktop\Work\PHR automation\MY\Test.sas"" progid=SAS.Application.940" Start-Process : This command cannot be run due to the error: The system cannot find the file specified. At line:1 char:1 + Start-Process sasoact.exe -ArgumentList "action=Submit datatype=SASFi ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Start-Process], InvalidOperationException + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand ... View more

I have Excel report with multiple sheets having formula's refreshing from Backend sheet of same excel. After exporting data to one of the sheets, i can't open the excel.   filename temp "/home/ouput/auto/sas/NAV_Report3.xlsx"; proc export data=Test outfile=temp dbms=xlsx replace; sheet='Backend'; run; quit;   Error that i am getting is " We found a problem with some content in 'NAV_Report3.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes."   After clicking Yes, i am getting "The workbook cannot be opened or repaired by Microdoft Excel because it is corrupt."    Any idea folks ?? ... View more

25 GOPTIONS ACCESSIBLE; 26 proc export outfile="/temp/myloc/dev/nonp/output/auto/sas/testing.xlsb" 27 data = one replace 28 DBMS=xls; 29 sheet="Sheet1"; 30 run; File is not OLE2 Requested Input File Is Invalid ERROR: Export unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. ... View more