Able to connect to PC files but not able view the data and write to the excel file in sas viya

rajashekhar1708 — Thu, 27 Feb 2020 05:32:53 GMT

Able to connect to PC files but not able view the data and write to the excel file.

CODE:

options validvarname=any;

libname xl XLSX 'C:\Users\107792\Desktop\excel\con_a_del.xlsx';

/* discover member (DATA) names */

proc datasets lib=xl;

quit;

libname xl list;

PROC DATASETS LIBRARY=xl;

QUIT;

data xl.class;

set sashelp.class;

run;

proc sql;

create table as xl.class;

select * from Sashelp.class;

quit;

libname xl clear;

LOG

1 %studio_hide_wrapper;

82 options validvarname=any;

83 libname xl XLSX 'C:\Users\107792\Desktop\excel\con_a_del.xlsx';

NOTE: Libref XL was successfully assigned as follows:

Engine: XLSX

Physical Name: C:\Users\107792\Desktop\excel\con_a_del.xlsx

/* con__del.xlsx file is having 10 sheets naming S1,S2,S3….S10 those sheets are also not recognised */

85 /* discover member (DATA) names */

86 proc datasets lib=xl;

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya

AnandVyas — Thu, 27 Feb 2020 05:51:09 GMT

Does the user under which the SAS session is executing has permission to write to the path - C:\Users\107792\Desktop\excel\? The error states that it could not create a tmp file at this location.

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya

BrianGaines — Thu, 27 Feb 2020 13:03:59 GMT

Hi @rajashekhar1708,

Which version of SAS Studio are you using? SAS Studio 5.1?

Thanks,

-Brian

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya

rajashekhar1708 — Fri, 28 Feb 2020 07:19:09 GMT

We are using SAS Viya 3.5

Develop SAS Code

topic Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya in SAS Studio

Able to connect to PC files but not able view the data and write to the excel file in sas viya

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya

Re: Able to connect to PC files but not able view the data and write to the excel file in sas viya