02-02-2023
mnjtrana
Pyrite | Level 9
Member since
10-08-2012
- 87 Posts
- 117 Likes Given
- 4 Solutions
- 13 Likes Received
-
Latest posts by mnjtrana
Subject Views Posted 1086 05-01-2020 06:50 AM 1132 05-01-2020 04:34 AM 1176 04-16-2020 05:05 AM 1342 04-06-2020 03:00 AM 1426 04-05-2020 01:37 PM 1136 04-03-2020 03:49 AM 902 03-03-2020 04:18 AM 1106 02-06-2020 05:00 AM 975 05-04-2018 07:47 AM 2146 05-04-2018 04:21 AM -
Activity Feed for mnjtrana
- Got a Like for Re: how to list the library and table used in a program. 01-03-2024 09:34 AM
- Got a Like for Re: Fill in Blanks with 'NA'. 09-14-2022 09:55 PM
- Posted Re: Issue with multi processing on SAS Programming. 05-01-2020 06:50 AM
- Liked Re: Excel file creation from SAS 9.2 for Kurt_Bremser. 05-01-2020 04:36 AM
- Liked Re: Excel file creation from SAS 9.2 for Reeza. 05-01-2020 04:36 AM
- Liked Re: Read sas program to create metadata for SASKiwi. 05-01-2020 04:35 AM
- Liked Re: Read sas program to create metadata for Reeza. 05-01-2020 04:35 AM
- Posted Issue with multi processing on SAS Programming. 05-01-2020 04:34 AM
- Posted Error connecting to server for signon on SAS Programming. 04-16-2020 05:05 AM
- Tagged Error connecting to server for signon on SAS Programming. 04-16-2020 05:05 AM
- Liked Re: Read sas program to create metadata for SASKiwi. 04-06-2020 05:54 AM
- Liked Re: Read sas program to create metadata for Patrick. 04-06-2020 05:54 AM
- Posted Re: Read sas program to create metadata on SAS Programming. 04-06-2020 03:00 AM
- Posted Read sas program to create metadata on SAS Programming. 04-05-2020 01:37 PM
- Tagged Read sas program to create metadata on SAS Programming. 04-05-2020 01:37 PM
- Tagged Read sas program to create metadata on SAS Programming. 04-05-2020 01:37 PM
- Posted Excel file creation from SAS 9.2 on SAS Programming. 04-03-2020 03:49 AM
- Liked Re: SAS Enterprise Guide 5.1 vs 7.1 for Kurt_Bremser. 03-03-2020 04:50 AM
- Posted SAS Enterprise Guide 5.1 vs 7.1 on SAS Programming. 03-03-2020 04:18 AM
- Liked Re: SAS 9.2 to SAS 9.4 migration for SASKiwi. 02-07-2020 05:08 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 03-22-2018 09:43 AM 1 12-26-2016 11:09 PM 1 04-30-2018 04:00 AM 1 04-30-2018 04:04 AM 1 04-30-2018 05:19 AM
05-01-2020
06:50 AM
Hey, thanks for the reply. As i mentioned, this is not the actual prod code, i tried to create a dummy one, so please ignore any syntax/logic errors. However we came across few scenarios where 1 reports is submiited twice to 2 parallel sessions. We are not sure how this is happening, because we have been using this logic without any issues for many years now. And this scenario is happening randomly. It happens once in a month or so. We tried everything but didnt find any fix. I am thinking this has to do something with process not completed and being submitted again.
... View more
05-01-2020
04:34 AM
Hi All,
I am facing peculiar issues with parallel prcessing in sas9.2 batch. My program creates 10 remote sessions and then more than 100 reports are submitted parallely to the open sessions.
However we came across few scenarios where 1 reports is submiited twice to 2 parallel sessions. We are not sure how this is happening, because we have been using this for many years now.
And this scenario is happening randomly. It happens once in a month or so. We tried everything but didnt find any fix. I am thinking this has to do something with process not completed and being submitted again.
FYI this is not the actual prod code, i tried to create a dummy one, so please ignore any syntax/logic errors.
Appreciate the help in advance!
Thanks
%let all_rep=100;
%macro new;
%do i =1 to &all_rep;
%multipc(&&rep_&i);
%end; %mend;
%macro multipc(statemnt);,
options autosignon=remote=sess1;
signon sess1 user= fsfsf passwd=;
rsubmit sess1 wait= yes connectpersist=yes cmacvar=stat_sess1
&statemnt;
endrsubmit;
signoff;
%mend; %new;
... View more
04-16-2020
05:05 AM
Hi All,
I am facing issues, using sas connect to remote sign in and submit parallel jobs. We used to use this sicne last 2 years, but lately there has been many issues with our batch. Sometimes it comes sometimes it doesnt. After restarting the batch it works. Not sure what exactly is the issue.
The error is below:
Error message is
ERROR: A communication subsystem partner link setup request failure has occurred. ERROR: Cannot start remote process. ERROR: Remote signon to SERVER1 canceled.
options autosignon=remote=sess1;
signon sess1 user= fsfsf passwd=;
rsubmit sess1 wait= yes connectpersist=yes cmacvar=stat_sess1
/* sas statements here */
endrsubmit;
signoff;
... View more
- Tags:
- rsubmit
04-06-2020
03:00 AM
We are actually migrating to sas 9.4 along with new sources of input. So we need to change few of the dataset names through lookup and few of the variable names being used in the assignment statement inside the datastep. so we need to know where the dataset starts, where it ends, what is the input datasdet name and what are the assignment or other statements inside dataset. I know we wont be able to automate it 100% , but the program list is huge, so any manual effort reduced will help a lot.
... View more
04-05-2020
01:37 PM
Hi All,
@Reeza @KurtBremser @ChrisHemedinger @Patrick @LinusH @Tom
I am trying to read few sas programs and create a dataset from it and extract some metadata from it.
So basically i am trying to read the whole program step by step and add some flags like below.
We are trying to flag the step_no: which is the count for the complete step, whether its a proc or a proc sql or datastep.
data_Step_no- for each value present for the step_no, assign incremental count till the datastep end.
proc_Step_no- for each value present for the step_no, assign incremental count till the proc end(or basically a run;).
We are trying to do this using @@ and mutiple find statements, however couldn't make it working for the data_step_no and proc_step_no. Do you think there is any such way to accomplish this task. We are trying to automate our migration. we are using sas EG7.1 on unix and sas 9.2
code
rec_no
step_no
data_step_no
proc_step_no
data want;
1
1
1
.
infile tmp truncover end=done;
2
1
2
.
input @1 father $9. mother $10. address $40.;
3
1
3
.
input child $9. age ?? 3.0 @@;
4
1
4
.
run;
5
1
5
.
DATA COMMAS;
6
2
1
.
INFILE DATALINES DLM=',';
7
2
2
.
INPUT ID HEIGHT WEIGHT GENDER $ AGE;
8
2
3
.
DATALINES;
9
2
4
.
1,68,144,M,23
10
2
5
.
2,78,202,M,34
11
2
6
.
3,62,99,F,37
12
2
7
.
4,61,101,F,45
13
2
8
.
;
14
2
9
.
run;
15
2
10
.
PROC PRINT;
16
3
.
1
TITLE 'Example 2.1';
17
3
.
1
RUN;
18
3
.
1
DATA AMPERS;
18
4
1
.
INPUT NAME & $25. AGE GENDER : $1.;
18
4
2
.
DATALINES;
18
4
3
.
RASPUTIN 45 M
18
4
4
.
BETSY ROSS 62 F
18
4
5
.
ROBERT LOUIS STEVENSON 75 M
18
4
6
.
;
18
4
7
.
run;
18
4
1
.
PROC PRINT;
18
5
.
2
TITLE 'Example 4';
18
5
.
2
RUN;
18
5
.
2
/* this is comment*/
19
.
.
.
... View more
04-03-2020
03:49 AM
Hi All,
I am using SAS 9.2 and want to create excel with multiple spreadsheets. I am using SAS EG 7.1 with Unix.
However i have tried to use proc export along with DBMS=XLS, the file gets created but no data in it.
I then tried ods tagsets.excelxp, however that is not working as well.
Any suggestion to create excels in sas 9.2 would be highly helpful.
Thanks,
Manjeet
Thanks,
Manjeet
... View more
03-03-2020
04:18 AM
Hi Team,
I wanted the communities help regarding SAS Enterprise Guide version 5.1
Our BAU SAS projects are created in SAS EG 5.1 and we never used the SAS EG 7.1 version. Until recently when a new hire is going to get the SAS Eg installed, we got to know that the SAS EG 5.1 version is decommissioned by our organization. And only SAS EG 7.1 version is only available for installation.
We wanted to understand, if using SAS EG 7.1 for the SAS projects(.EGP) and programs will end up in any error or issues. I think SAS EG 7.1 will automatically migrate the previous EGP projects to the new version which will create issues for others users, trying to access those projects from SAS Eg 5.1.
Any help will be highly appreciated.
Thanks,
Manjeet
... View more
02-06-2020
05:00 AM
Hi All,
One of our client is moving from SAS 9.2(LINUX) to SAS 9.4 version on a new Linux server. The software will be upgraded by the SAS Admins along with the necessary configurations. However we would also need to migrate the SAS codes to the new server.
Apart from the library and new sources changes, We wanted to know if we need to do any changes to the codes. I mean i know SAS 9.4 is backward compatible, but are these things which we can change to make the code more efficient.
Thanks in advance. Manjeet
... View more
05-04-2018
07:47 AM
Hi,
That seem's odd, the data transfer works fine as long as you have the access to the directory and have sufficient space. I have been doing this process and saving the data to network drives, but never got any issue.
Can you please share one screenshot please?
... View more
05-04-2018
04:21 AM
Hi,
You can use the anydtdte21. informat to read this type of data, it reads and extracts the date value from various date, time, and datetime forms.
Pls refer to code below.
data need;
input date_var anydtdte21.;
datalines;
2018/04/22
20180422
2018-04-22
2018-04-22 05:36:02
13042018
run;
More details here:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002605538.htm
Please give a like and mark as solution if it helped.
... View more
04-30-2018
09:28 AM
Hi- If i understood correctly, you have specific values that needs to be changed to numeric .
In the below code, you are checking for specific values for names and assigning new_val variable to numeric values as you mentioned.
data need;
set have;
if name in("Trans1. Customer A" ,"Trans4. Customer A") then new_val = 1;
else if name in("Trans2. Customer B"0 then new_val = 2;
else if name in("Trans3. Customer C"0 then new_val = 3;
run;
... View more
04-30-2018
06:44 AM
We also had this kind of requirement in one of my project which resided in mainframe and we neede dto convert it to windows sas9.4 code. so the printer output had to be removed, all of this printer code was luckily inside a macro, so they used to call the printer macro in the program. So we just removed the printer code from there and changed it to ODS PDF, so now we had all the printer output in the pdf which was emailed to user based on the printer name earlier. macro call %print_main(<dataset name>, <printer name>); now based on the printer name an email is triggerd to user id mentioned in one permanent dataset with the ods pdf report. Hope this may help you!
... View more
04-30-2018
05:23 AM
Your CSV file is created perfectly. It's just you have to use the MS Excel or any other spreasheet program to open it to show in 3 columns. A text editor like notepad wordpad etc will show it in one line only, like you mentioned.
... View more
04-30-2018
05:19 AM
1 Like
I got your point, you can add the autoexec as tools>options folder. you can refer the below the below link: https://blogs.sas.com/content/sasdummy/2011/01/10/you-asked-for-it-the-autoexec-process-flow/
... View more
04-30-2018
04:04 AM
1 Like
Noprint works only to supress the ouptut from the output window. However what you are trying to do is trying to supress the log, which is not the same thing. So unless you route your log using proc printto, there is no other way.
... View more