About Abelp9

Abelp9 · ‎03-10-2022

Hello everyone, my question is related to the SAS options. It turns out that when I hover over a SAS function or macro, like %let %if %do %then... etc, a yellow box appears with information and the same macros. This yellow box can be seen in the attached image. The fact is that a friend, with the same version of SAS as me (7.1), does not see that box when he hovers over a button, so I guess he has something disabled in the options. Could someone tell me how to solve this so that he can also see the help? Thank you very much in advance, greetings

Abelp9 · ‎03-02-2022

Hello everyone, I'm new to programming in SAS and I'm trying to create a macro that moves the 160 .xlsx files that are generated in one folder, to another, within the SAS server. The names of the files are different and it cannot be use the wildcard "*" to name all the files, that's why I had thought of a macro with macrovariables. What I intend to do is the following, The file names always start with "XDF_" followed by a number (for example: 0001475) this number is a field called cod_SAP from another table, then the date would go (I have no problem with this ) then it would go again "_XDF_M2_"month in number format, type 202202".xlsx. That is, if we pass this to macrovariables it would be something like this: XDF_&column._&date._XDF_M2_&month..xlsx And a file would be for example: XDF_0001475_20220302_XDF_M2_202203.xlsx They will all have the same value in the date and month macrovariable, what will change will be the codes. There are 160 different codes so I have 160 .xlsx files that I want to move. Here is the code I have been testing: data tabletest; set origintable; Rank + 1; if first.test then Rank = 1; run; PROC SQL; CREATE TABLE TEST1 as SELECT DISTINCT cod_SAP, Rank FROM TABLETEST; QUIT; data _null_; set TEST1; call symput ('codes',_n_); run; %macro testmove; %global month; %let month = 202112; %global date; %let date= 20220302; %do i=1 %to &codes; data _null_; set tabletest(where=(rank=&i.)); call symput ('column',compress(cod_SAP)); run; filename in "/opt/sas/data/xxx/xx/xx/xxx/FinalFolder/XDF_&column._&date._XDF_M2_&month..xlsx"; filename out "/opt/sas/data/xx/xx/xx/xx/BridgeFolder/XDF_&column._&date._XDF_M2_&month..xlsx"; * copy the file byte-for-byte; data _null_; length filein 8 fileid 8; filein = fopen('in','I',1,'B'); fileid = fopen('out','O',1,'B'); rec = '20'x; do while(fread(filein)=0); rc = fget(filein,rec,1); rc = fput(fileid, rec); rc =fwrite(fileid); end; rc = fclose(filein); rc = fclose(fileid); run; filename in clear; filename out clear; %end; %mend testmove; %testmove; What happens with this code is that it simply copies 5 files and sometimes it does it when they are empty, it only copies the empty excel and with the name that is in the source folder, could someone tell me where the error would be? or any other alternative to try to move 160 excel files with different names to another folder automatically? I can't use xcopy, I have to do it with the noxcmd option enabled Thank you very much in advance

Abelp9 · ‎03-01-2022

It has created 160 empty folders for me, I guess what the macro will do is create 160 folders and inside the excel in question, how can I make it not create folders for me? and only copy the xlsx? Another option will be to copy the most external folder directly

Abelp9 · ‎03-01-2022

Abelp9 · ‎03-01-2022

It returns this: 71 %mend mp_copyfolder; 72 %mp_copyfolder(/opt/sas/data/xx/xx/xx/xx/FinalFolder/,/opt/sas/data/xx/xx/xx/xxx/BridgeFolder/) NOTE: Compression of the WORK.DATA1 dataset is disabled because it would increase the size of the dataset. NOTE: The data set WORK.DATA1 has 1 observations and 0 variables. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,669+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 1| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 136| _DISARM| 2032| _DISARM| 0.000000| _DISARM| 0.000885| _DISARM| 1961763947.668653| _DISARM| 1961763947.669538| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,669+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 144| _DISARM| 2032| _DISARM| 0.010000| _DISARM| 0.002187| _DISARM| 1961763947.667533| _DISARM| 1961763947.669720| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: Sentencia DATA used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 %mp_dropmembers(%scan(&outds,-1,.), libref=WORK) _ 180 WARNING: Apparent invocation of macro MP_DROPMEMBERS not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 length directory ______ 180 72 ! filepath $500 fref fref2 $8 file_or_folder $6 filename $80 ext $20 msg $200 foption $16; if _n_=1 then call 72 ! missing(of _all_); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 data &out_ds(compress=no keep=file_or_folder filepath filename ext msg directory level ); length directory 72 ! filepath $500 fref fref2 $8 file_or_folder $6 filename $80 ext $20 msg $200 foption $16; if _n_=1 then call __ 180 72 ! missing(of _all_); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 retain level &level; ______ 180 3 Sistema SAS 15:24 Tuesday, March 1, 2022 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc = filename(fref, "&path"); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if rc = 0 then do; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 did = dopen(fref); ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 numopts=doptnum(did); _______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 do i=1 to numopts; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 foption=doptname _______ 180 72 ! (did,i); if foption=:'Directory' then i=numopts; end; directory=dinfo(did,foption); if did=0 then do; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if foption=:'Directory' then i=numopts; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; 4 Sistema SAS 15:24 Tuesday, March 1, 2022 ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 directory=dinfo(did,foption); _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if did=0 then do; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if rc = 0 then do; did = dopen(fref); numopts=doptnum(did); do i=1 to numopts; 72 ! foption=doptname(did,i); if foption=:'Directory' then i=numopts; end; directory=dinfo(did,foption); if 72 ! did=0 then do; putlog ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 msg=sysmsg(); ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 put _all_; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 stop; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; ___ 180 5 Sistema SAS 15:24 Tuesday, March 1, 2022 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc = __ 180 72 ! filename(fref); end; else do; msg=sysmsg(); put _all_; stop; end; dnum = dnum(did); do i = 1 to ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 else do; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 msg=sysmsg(); ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 put _all_; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 stop; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; 6 Sistema SAS 15:24 Tuesday, March 1, 2022 ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 dnum = dnum(did); ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 do i = 1 to dnum; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 filename = ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 filepath=cats(directory,'/',filename); ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc = filename(fref2,filepath); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 midd=dopen(fref2); ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 72 ! dmsg=sysmsg(); if did > 0 then file_or_folder='folder'; rc=dclose(midd); midf=fopen(fref2); fmsg=sysmsg() 7 Sistema SAS 15:24 Tuesday, March 1, 2022 ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if did > 0 then file_or_folder='folder'; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc=dclose(midd); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 midf=fopen(fref2); ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 fmsg=sysmsg(); ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if midf __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc=fclose(midf); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 8 Sistema SAS 15:24 Tuesday, March 1, 2022 72 if index(fmsg,'File is in use') or index(dmsg,'is not a __ 180 72 ! directory') then file_or_folder='file'; else if index(fmsg,'Insufficient authorization') then ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 else if index(fmsg,'Insufficient authorization') then file_or_folder='file'; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 else if ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if file_or_folder='file' then do; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 ext = ___ 180 72 ! prxchange('s/.*\.{1,1}(.*)/$1/', 1, filename); if filename = ext then ext = ' '; end; else do; ext='' ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 if filename = ext then ext = ' '; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 9 Sistema SAS 15:24 Tuesday, March 1, 2022 NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 else do; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 ext=''; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 file_or_folder='folder'; ______________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 output; ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 rc = dclose(did); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MP_DIRLIST". 72 stop; ____ 10 Sistema SAS 15:24 Tuesday, March 1, 2022 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,678+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| -1| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2032| _DISARM| 0.000000| _DISARM| 0.000210| _DISARM| 1961763947.678400| _DISARM| 1961763947.678610| _DISARM| 0.000000| _DISARM| | _ENDDISARM ERROR: La variable filepath no está en el archivo WORK.DATA1. NOTE: La compresión del conjunto de datos WORK.DATA1 está deshabilitada porque aumentaría el tamaño del conjunto de datos. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATA1 may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,679+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 0| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 8| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 0.000574| _DISARM| 1961763947.679081| _DISARM| 1961763947.679655| _DISARM| 0.000000| _DISARM| | _ENDDISARM WARNING: El conjunto de datos WORK.DATA1 no se ha reemplazado porque este paso se ha parado. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,679+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 16| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 0.002204| _DISARM| 1961763947.677621| _DISARM| 1961763947.679825| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: Sentencia DATA used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: Apparent invocation of macro MF_EXISTDS not resolved. ERROR: Required operator not found in expression: %mf_existds(&outds) ERROR: The macro MP_DIRLIST will stop executing. ERROR: El archivo WORK.MC60F77C8BAE371B48927CFA233E5F19.DATA no existe. NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2836:190 2836:238 72:149 NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,682+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 0.001116| _DISARM| 1961763947.681176| _DISARM| 1961763947.682292| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: Sentencia DATA used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: El archivo WORK.MC60F77C8BAE371B48927CFA233E5F19.DATA no existe. WARNING: Table WORK.MC60F77C8BAE371B48927CFA233E5F19 no se ha suprimido. 73 74 GOPTIONS NOACCESSIBLE; 75 %LET _CLIENTTASKLABEL=; 76 %LET _CLIENTPROCESSFLOWNAME=; 77 %LET _CLIENTPROJECTPATH=; 78 %LET _CLIENTPROJECTNAME=; 79 %LET _SASPROGRAMFILE=; 80 81 ;*';*";*/;quit; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-03-01T15:25:47,688+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 0.001127| _DISARM| 1961763947.687196| _DISARM| 1961763947.688323| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDIMIENTO SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 11 Sistema SAS 15:24 Tuesday, March 1, 2022 81 ! run; 82 ODS _ALL_ CLOSE; 83 84 85 QUIT; RUN; 86

Abelp9 · ‎03-01-2022

This is the code I entered: %macro mp_copyfolder(source,target); %mp_abort(iftrue=(%mf_isdir(&source)=0) ,mac=&sysmacroname ,msg=%str(Source dir does not exist (&source)) ) %mf_mkdir(&target) %mp_abort(iftrue=(%mf_isdir(&target)=0) ,mac=&sysmacroname ,msg=%str(Target dir could not be created (&target)) ) /* prep temp table */ %local tempds; %let tempds=%mf_getuniquename(); /* recursive directory listing */ %mp_dirlist(path=&source,outds=work.&tempds, maxdepth=MAX) /* create folders and copy content */ data _null_; length msg $200; call missing(msg); set work.&tempds; if _n_ = 1 then dpos+sum(length(directory),2); filepath2="&target/"!!substr(filepath,dpos); if file_or_folder='folder' then call execute('%mf_mkdir('!!filepath2!!')'); else do; length fref1 fref2 $8; rc1=filename(fref1,filepath,'disk','recfm=n'); rc2=filename(fref2,filepath2,'disk','recfm=n'); if fcopy(fref1,fref2) ne 0 then do; msg=sysmsg(); putlog "%str(ERR)OR: Unable to copy " filepath " to " filepath2; putlog msg=; end; end; rc=filename(fref1); rc=filename(fref2); run; /* tidy up */ proc sql; drop table work.&tempds; %mend mp_copyfolder; %mp_copyfolder(/opt/sas/data/xx/xx/xx/xx/FinalFolder/,/opt/sas/data/xx/xx/xx/BridgeFolder/) And it returns this error: 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Transferencia_archivos'; 4 %LET _CLIENTPROCESSFLOWNAME='Autoexec'; 5 %LET _CLIENTPROJECTPATH='C:\xx\xx\xx\xxxx\xxxx.egp'; 6 %LET _CLIENTPROJECTNAME='xxxx.egp'; NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. 7 %LET _SASPROGRAMFILE=; 8 9 ODS _ALL_ CLOSE; 10 OPTIONS DEV=PNG; 1 ;*';*";*/;quit;run; ______________ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 11 GOPTIONS XPIXELS=0 YPIXELS=0; 12 FILENAME EGSR TEMP; 13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14 STYLE=HtmlBlue 15 STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css" ___________________________________________________________________________________________ 49 15 ! ) NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 16 NOGTITLE 17 NOGFOOTNOTE 18 GPATH=&sasworklocation 19 ENCODING=UTF8 20 options(rolap="on") 21 ; 22 23 GOPTIONS ACCESSIBLE; 24 %macro mp_copyfolder(source,target); 25 26 %mp_abort(iftrue=(%mf_isdir(&source)=0) 27 ,mac=&sysmacroname 28 ,msg=%str(Source dir does not exist (&source)) 29 ) 30 31 %mf_mkdir(&target) 32 33 %mp_abort(iftrue=(%mf_isdir(&target)=0) 34 ,mac=&sysmacroname 35 ,msg=%str(Target dir could not be created (&target)) NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. I don't know very well if I have to modify something inside the macro, I'm trying to copy all the contents of a folder and move it to another path inside the SAS server Thank you so much for help me

Abelp9 · ‎03-01-2022

I have tried to save the 5 macros that macro uses (6 in total) and to put my source and destination path as arguments of the last macro but it does not work for me

Abelp9 · ‎03-01-2022

I'm new to programming so I don't understand very well what you are telling to me, I will continue searching the internet, thank you very much!

Abelp9 · ‎03-01-2022

Hello, I'm new to programming and I'm trying to automate a process, I'm in a part where my code creates about 160 excel files and sheets are added to these files (each excel sheet, a different code since it starts from a table in different SAS). Before it went well because the destination path of these xlsx files was within SAS, now it is still within SAS but in a bridge folder with windows, that is, the excels are created and automatically when going to the bridge folder, they go from sas and come to windows. The problem is that as the files are transferred very quickly to windows, in the following block of code where the second sheet would be created, a new excel is created for me since by the time I execute the second piece of code, the files that were generated in the first one is already in windows, and my bridge folder seen from SAS is empty, so the excel files are not renamed and files are created with loose sheets. What I had thought was to create a slightly larger code where I can create 5 sheets at a time (before there would be 5 pieces of code, 1 for each sheet) and that directly send it to my bridge folder, so that the complete excel files are exported . Does anyone know if this can be done? I pass you the code of two sheets that I create and I would like to work, the idea would be to do the same with the other pieces of code. *MACRO 1; proc sql noprint; select distinct cat("DATA I1_",&month.,"_",compress(&COLUMN.,,'kad'),"; set &TABLE.(where=(&COLUMN.='", &COLUMN.,"'));run; proc export data=I1_",&month.,"_", &COLUMN.," outfile='&out_path.","ST_", &column.,"_", &fecha., "_S_M7_",&month.,"' dbms=xlsx replace;sheet='SHEET 1';run; ;run")length=500 into :allsteps separated by ';' from &TABLE. quit; %macro runSteps; &allsteps.; %mend; %runsteps *MACRO 2; proc sql noprint; select distinct cat("DATA I2_",&month.,"_",compress(&COLUMN.,,'kad'),"; set &TABLE.(where=(&COLUMN.='", &COLUMN.,"'));run; proc export data=I2_",&month.,"_", &COLUMN.," outfile='&out_path.","S_", &column.,"_", &fecha., "_S_M7_",&month.,"' dbms=xlsx replace;sheet='SHEET 2';run; ;run")length=500 into :allsteps separated by ';' from &TABLE. quit; %macro runSteps; &allsteps.; %mend; %runSteps I don't know if I have expressed myself clearly, but my intention is to create those 2 sheets in the same code, not having to make a code for one and another code for another, to be able to export the excel with all its sheets to the bridge folder, and do not export loose sheets since they are transferred very quickly to windows. Thank you very much in advance, greetings

Abelp9 · ‎02-28-2022

why it returns to me this error? "ERROR: Insufficient authorization to access PIPE."

Abelp9 · ‎02-28-2022

Do you have any kind of documentation handy where I can read more about this? I am new programming in sas and it is the first time that I see those functions

Abelp9 · ‎02-28-2022

how could i do that?

Abelp9 · ‎02-28-2022

Hello everyone, I am trying to automate a process and one of my programs generates about 50 files with different excel names in a specific folder within SAS. What I want to do is move those .xlsx from the folder where they are created, to another one inside SAS (That folder is my bridge between sas and windows). How could I do this? I have been testing with the following code: filename in "/opt/sas/data/xx/xx/xx/xx/FinalFolder/*.xlsx"; filename out "/opt/sas/data/xx/xx/xx/xx/BridgeFolder/*.xlsx"; * copy the file byte-for-byte; data _null_; length filein 8 fileid 8; filein = fopen('in','I',1,'B'); fileid = fopen('out','O',1,'B'); rec = '20'x; do while(fread(filein)=0); rc = fget(filein,rec,1); rc = fput(fileid, rec); rc =fwrite(fileid); end; rc = fclose(filein); rc = fclose(fileid); run; filename in clear; filename out clear; But it returns me many notes of this type: NOTE: Argument 1 to function FPUT(0,'') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'x') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'l') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'/') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'w') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'o') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'r') at línea 35 columna 22 is invalid. NOTE: Argument 1 to function FPUT(0,'k') at línea 35 columna 22 is invalid. I think the problem is in the asterisk that I use to refer to all the files in the folder (since they are called differently and I want to automate it) because when I put the specific name of a file it works for me. Can someone give me a hand with this? Thank you very much in advance, greetings

Abelp9 · ‎02-28-2022

And is there something that does the same functions as the outlook rules?

Abelp9 · ‎02-28-2022

Hello everyone, I'm new to programming in SAS and I would like to add a check if there are 4 files in a given path. Files with the same name but different dates will be stored in this folder, for example: 'test1_20210228.csv', the date is stored in a macro variable called &period. What I did before was this: %let myfilerf1=/opt/sas/data/test1_&period..csv; %let myfilerf2=/opt/sas/data/test2_&period..csv; %let myfilerf3=/opt/sas/data/test3_&period..csv; %let myfilerf4=/opt/sas/data/test4_&period..csv; %macro PROD1; %if %sysfunc(fileexist(&myfilerf1)) %then %do; %put OK; %end; %else %do; %abort cancel; %end; %mend PROD1; %PROD1 %macro PROD2; %if %sysfunc(fileexist(&myfilerf2)) %then %do; %put OK; %end; %else %do; %abort cancel; %end; %mend PROD2; %macro PROD3; %if %sysfunc(fileexist(&myfilerf3)) %then %do; %put OK; %end; %else %do; %abort cancel; %end; %mend PROD3; %macro PROD4; %if %sysfunc(fileexist(&myfilerf4)) %then %do; %put OK; %end; %else %do; %abort cancel; %end; %mend PROD4; options mprint; %PROD1 %PROD2 %PROD3 %PROD4 But the problem is that we want to automate this and the abort cancel does not work in batch, so I would like to make a kind of macro or something that sends me an email (I know how to do this) if any of those 4 files do not exist. I had thought of concatenating the different macros of myfilerf but I don't know how to do it, to make it check if all 4 exist, if they exist, put an OK, if they don't exist, send me an email, but since there are 4 files, I don't want them to I sent 4 emails (1 for each file) so I want to compress everything in a macro if possible, but I don't know how to reference the 4 files for the day that marks &period if inside the fileexist I can only put a macro variable. Can someone help me with this? I hope I explained myself well, thank you very much in advance

Online Status	Offline
Date Last Visited	‎03-28-2023 11:25 AM

Re: Check in a data step if a table exists to create another from it

Re: Check in a data step if a table exists to create another from it

Check in a data step if a table exists to create another from it

Re: Create a stored process in SAS and execute it from Excel and do no...

Create a stored process in SAS and execute it from Excel and do not cr...

Como cuantificar un error y guardarlo en una macro en SAS.

Create a dynamic week filter in SAP Analytics Cloud.

Re: Delete a line in a table containing a record with a line break.

Delete a line in a table containing a record with a line break.

Transforming date values from 07/20/2022 to 20220720 keeping the colum...

Re: Create a stored process in SAS and execute it from Excel and do no...

Re: Create a stored process in SAS and execute it from Excel and do no...

Re: Create a stored process in SAS and execute it from Excel and do no...

Re: Delete a line in a table containing a record with a line break.

Re: Transforming date values from 07/20/2022 to 20220720 keeping the c...

Error importing a csv file from a J path to the sas server (opt/sas), ...

How to enable the option in SAS to see the yellow help box when you ho...

Move multiple files with different names between SAS server folders wi...

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Create several excel sheets that start from different tables in th...

Create several excel sheets that start from different tables in the sa...

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Refer to all files in a path in SAS with "path/*.xlsx"

Re: Automate process that starts in Outlook and ends in SAS, transfer ...

Macro to check if there are 4 files in a given path (with macro variab...