h..............elllppppppppppp

[NYCpal]

nenu okka xls file ni exporting and also converting it into csv file by adding run  date  .below is the code :

%let dt = %sysfunc(today(), mmddyy6.);
%put &dt;

proc export data=abc_1 dbms=xlsx

outfile='A:\test\xyz_&dt..csv'

dbms=csv

replace;

run;

 ERROR: Insufficient authorization to access;

[uncertainty]

8 hours ago, NYCpal said:

nenu okka xls file ni exporting and also converting it into csv file by adding run  date  .below is the code :

%let dt = %sysfunc(today(), mmddyy6.);
%put &dt;

proc export data=abc_1 dbms=xlsx

outfile='A:\test\xyz_&dt..csv'

dbms=csv

replace;

run;

 ERROR: Insufficient authorization to access;

Do u have write access to file system ??

[fake_Bezawada]

9 hours ago, NYCpal said:

nenu okka xls file ni exporting and also converting it into csv file by adding run  date  .below is the code :

%let dt = %sysfunc(today(), mmddyy6.);
%put &dt;

proc export data=abc_1 dbms=xlsx

outfile='A:\test\xyz_&dt..csv'

dbms=csv

replace;

run;

 ERROR: Insufficient authorization to access;

endhi idhi ae basha idhi shell scripting ah 

[Variety_Pullayya]

3 hours ago, uncertainty said:

Do u have write access to file system ??

give access to everyone for the file and the folder.

chmod -R 777

[NYCpal]

3 hours ago, uncertainty said:

Do u have write access to file system ??

Access undhi 

[NYCpal]

7 minutes ago, Variety_Pullayya said:

give access to everyone for the file and the folder.

chmod -R 777

Everyone can access tat file and folder 

[kumar1984]

20 hours ago, NYCpal said:

nenu okka xls file ni exporting and also converting it into csv file by adding run  date  .below is the code :

%let dt = %sysfunc(today(), mmddyy6.);
%put &dt;

proc export data=abc_1 dbms=xlsx

outfile='A:\test\xyz_&dt..csv'

dbms=csv

replace;

run;

 ERROR: Insufficient authorization to access;

dbms=xlsx dbms=csv rendu ichav enti bro

[Selfgoal]

4 minutes ago, kumar1984 said:

dbms=xlsx dbms=csv rendu ichav enti bro

Hi kumar bro long time no see 

[Katti_Ramdas]

7 hours ago, NYCpal said:

Everyone can access tat file and folder 

May be excel open cheste oka alert vastadi ga that is causing it i guess

[Selfgoal]

Just now, Katti_Ramdas said:

May be excel open cheste oka alert vastadi ga that is causing it i guess

Good guess 

pakkaelli aduko amma 

[Aakupaccha_caradu]

[kumar1984]

SAS enterprise guide use chesthe ganaka export wizard use cheyyi bro and then get code

[Naaperushiva]

21 hours ago, NYCpal said:

nenu okka xls file ni exporting and also converting it into csv file by adding run  date  .below is the code :

%let dt = %sysfunc(today(), mmddyy6.);
%put &dt;

proc export data=abc_1 dbms=xlsx

outfile='A:\test\xyz_&dt..csv'

dbms=csv

replace;

run;

 ERROR: Insufficient authorization to access;

Bro excel file ki ayithe Why dont you use a libname statement. It directly creates a library of tables.

 

Coming to your question akkada dbms=csv and xlsx ani pettav gaa

[Naaperushiva]

11 hours ago, fake_Bezawada said:

endhi idhi ae basha idhi shell scripting ah 

Sas kaaka adhi

[Katti_Ramdas]

48 minutes ago, Selfgoal said:

Good guess 

pakkaelli aduko amma 

Mg