01-06-2021
tarikbirinci1
Calcite | Level 5
Member since
03-30-2020
- 10 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by tarikbirinci1
Subject Views Posted 1549 09-07-2020 03:57 AM 1573 09-07-2020 02:51 AM 1662 09-06-2020 05:12 PM 737 09-06-2020 11:31 AM 786 09-06-2020 09:32 AM 1241 09-06-2020 09:16 AM 841 08-24-2020 04:47 AM 873 08-24-2020 03:41 AM 681 08-20-2020 05:39 PM 754 08-20-2020 04:03 AM -
Activity Feed for tarikbirinci1
- Posted Re: How to Update Multiple Codes at the Same Time? on SAS Programming. 09-07-2020 03:57 AM
- Posted Re: How to Update Multiple Codes at the Same Time? on SAS Programming. 09-07-2020 02:51 AM
- Posted How to Update Multiple Codes at the Same Time? on SAS Programming. 09-06-2020 05:12 PM
- Posted Re: How To Show Disc Fill Rates With Sas Scripts? on SAS Programming. 09-06-2020 11:31 AM
- Posted How To Show Disc Fill Rates With Sas Scripts? on SAS Programming. 09-06-2020 09:32 AM
- Posted How To Sending E-mail With Error Rows From The Log File? on SAS Programming. 09-06-2020 09:16 AM
- Posted Re: How to mail SAS table in excel form? on SAS Programming. 08-24-2020 04:47 AM
- Posted How to mail SAS table in excel form? on SAS Programming. 08-24-2020 03:41 AM
- Posted Re: How to - browse excel file from my local with sas scripts? on SAS Programming. 08-20-2020 05:39 PM
- Posted How to - browse excel file from my local with sas scripts? on SAS Programming. 08-20-2020 04:03 AM
09-07-2020
03:57 AM
I forgot to type Out1 libnames for every Want data set. I have edited the code as below. Yes, there should be 5 different paths but there should be only one code. /*CODE 1*/
LIBNAME OUT1 "C:\OUT1";
DATA OUT1.WANT;
SET HAVE;
RUN;
/*CODE 2*/
LIBNAME OUT2 "C:\OUT2";
DATA OUT2.WANT;
SET HAVE;
RUN;
/*CODE 3*/
LIBNAME OUT3 "C:\OUT3";
DATA OUT3.WANT;
SET HAVE;
RUN;
/*CODE 4*/
LIBNAME OUT4 "C:\OUT4";
DATA OUT4.WANT;
SET HAVE;
RUN;
/*CODE 5*/
LIBNAME OUT5 "C:\OUT5";
DATA OUT5.WANT;
SET HAVE;
RUN; Maybe someting like the following structure, but I am not sure about how to do it well. %MACRO PATH(LIBNAME);
%IF &LIBNAME.= OUT1 %THEN %DO;
LIBNAME OUT1 "C:\OUT1";
%END;
%ELSE %IF &LIBNAME.= OUT2 %THEN %DO;
LIBNAME OUT2 "C:\OUT2";
%END;
%ELSE %IF &LIBNAME.= OUT3 %THEN %DO;
LIBNAME OUT3 "C:\OUT3";
%END;
%ELSE %IF &LIBNAME.= OUT4 %THEN %DO;
LIBNAME OUT4 "C:\OUT4";
%END;
%ELSE %IF &LIBNAME.= OUT5 %THEN %DO;
LIBNAME OUT5 "C:\OUT5";
%END;
%MEND PATH;
%PATH(OUT1);
%PATH(OUT2);
%PATH(OUT3);
%PATH(OUT4);
%PATH(OUT5); /* &libname macro variable should be dynamic but I couldn't figure out how to do it */ LIBNAME &libname "C:\&libname";
DATA &libname.WANT;
SET HAVE;
RUN;
... View more
09-07-2020
02:51 AM
Here is code as text: DATA HAVE;
LENGTH NAME $ 32 ID 8;
INFILE DATALINES MISSOVER;
INPUT NAME ID;
DATALINES;
JOHN 1
JACK 2
EMILY 3
BLAKE 4
ROBIN 5
BRAD 6
;
/*CODE 1*/
LIBNAME WANT "C:\OUT1";
DATA WANT;
SET HAVE;
RUN;
/*CODE 2*/
LIBNAME WANT "C:\OUT2";
DATA WANT;
SET HAVE;
RUN;
/*CODE 3*/
LIBNAME WANT "C:\OUT3";
DATA WANT;
SET HAVE;
RUN;
/*CODE 4*/
LIBNAME WANT "C:\OUT4";
DATA WANT;
SET HAVE;
RUN;
/*CODE 5*/
LIBNAME WANT "C:\OUT5";
DATA WANT;
SET HAVE;
RUN; Thank you for your support.
... View more
09-06-2020
05:12 PM
Hello everybody, I have 5 codes doing the same job, the only difference between these codes is that they write to different paths. Here is a thing that forces me, when I change one of the codes, then I need to do it for all of the other codes too. This causes me both margin of error and a waste of time for me. So here, I am looking for an automatic structure that can solve my issue. Let's assume, I have five sample codes and they write to different directories as below; If I want to change something in any of them, I want all of them to be affected at the same time. How can I build that structure?
... View more
09-06-2020
11:31 AM
Thank you very much for your invaluable response. But, rate column comes missing. What can be the reason? On the other hand, I want to add a condition. I am going to devide used variable to total size variable then I want to get the percentage of the available storage. So, if the percentage of available storage less than 10%, I want to get notification through the e-mail. Is it possible to do this? Thanks,
... View more
09-06-2020
09:32 AM
Hello everybody, I am working on unix environment, so as you know with "df -h" command I can see the availability percentage of discs. But also, I need sas scripts which provide me to show disc space rate for my co-workers. I put the unix screen as below. I expect to see following sas results table: Can somebody help me about this? Thanks,
... View more
09-06-2020
09:16 AM
Hello everybody, I know that following code works for sending an e-mail, however I want to put error rows which starts with ERROR: from my log into the body of this e-mail. And I also want to attach the full log to the attachment of the mail. I think I can make it with the ATTACH statement. But the main point is sending error rows into mail's body. FILENAME MYMAIL EMAIL;
DATA _NULL_;
FILE MYMAIL
TO="tarik.birinci@ozu.edu.tr"
SUBJECT="%upcase(&SYSHOSTNAME) INFO";
PUT " Hello";
RUN; I prepared a log for you and it is in the attachment. If this kind of log file occurs, then I want to see the mail as below. My desired e-mail output as below. I will be glad if somebody help me about this issue. Thank you,
... View more
08-20-2020
05:39 PM
Yes, your assumptions are correct. We can both work on Sas Studio and Sas EG. Yes, they can work with these Sas tools. About your third question, actually as you remember from Sas EG (I also attach the screenshot as below) I would like to similar screen for them to browse their local file in any browser. ss As a summary, because we all have accessibility to Sas Visual Analytics hub, we expect to create browser screen to import our local file. To do this, we need Sas scripts to build that structure. Thanks,
... View more
08-20-2020
04:03 AM
Hello everybody, I want to import an excel file from my local with any of the browser screens such as Chrome, Explorer etc. But I want to expect to show that screen to all of my co-workers who can reach that Sas server. At the end of the day, I also want to map these excel files with desired paths, so I have a structure in my mind like this way. If any of the experts can help me about creating the sas scripts? Thanks in advance.
... View more