turcay Tracker

Re: How to Create and Configure an Amazon S3 Download Job

turcay — Sun, 13 Oct 2019 22:24:36 GMT

Aha, I am so sorry, you were right. It is opposite, I have DIS 4.8 but I try to import from DIS 4.9, so it is a problem

Re: How to Create and Configure an Amazon S3 Download Job

turcay — Sun, 13 Oct 2019 22:18:56 GMT

Actually, the spk is created in DIS 4.8 and I am trying to import DIS 4.9, so I think, we are good?

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sun, 13 Oct 2019 20:59:26 GMT

I agrree with this but how can I fix those warnings then?

Re: How to Create and Configure an Amazon S3 Download Job

turcay — Sun, 13 Oct 2019 20:58:00 GMT

Here, no need to take an action, right?

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sun, 13 Oct 2019 20:57:33 GMT

Okay, I will try it, thanks

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sun, 13 Oct 2019 20:56:08 GMT

But I received that file from another environment and in that environment DI Studio was probably 4.8 but here it is 4.9 and this is the reason I receive that error, I am okay with that

but why I cannot open Job Editor screen which I could open before and I know that there is no upgrade and or renewal or etc. Except from the importation process why I cannot open my current jobs?

Thanks

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sun, 13 Oct 2019 20:46:17 GMT

I do not think so because this week, I tried to import that file before that, I have my other own jobs and those were working. I think your suggestions will be following these notes->

https://support.sas.com/kb/41/571.html

http://support.sas.com/kb/56/034.html

This should fix the problem, right? Any idea?

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sun, 13 Oct 2019 20:40:46 GMT

Hello,

It is -> Current version: 9.04.01M5P091317 so you mean that if I first resolve other issue, I can fix this problem too?

Actually, this one seems that independent from other subject because I could open Job Editor before, and never happened, it just does not let me to see Job Editor screen aynmore, my jobs are located there but I cannot display them. Just a spinning wheel for a second, then nothing happens. It is for all jobs and for every people.It started to appear for everybody on thursday.

Thanks

Re: How to Create and Configure an Amazon S3 Download Job

turcay — Sun, 13 Oct 2019 20:30:06 GMT

Hello,

When I type SETINIT, it shows me that -> Current version: 9.04.01M5P091317, it means that it is SAS 9.4. So what do you exactly mean here? Is this prevent my importing process here ? Or it is just a warning to inform me?

Thanks

How to Create and Configure an Amazon S3 Download Job

turcay — Sat, 12 Oct 2019 11:17:15 GMT

Hello everybody,

I am also getting following errors, when I try to import Job from Unix to SAS DI Studio, how can I fix this issue?

WARNING: The custom transform 'Download File From Amazon S3' found at configured location '/System/Applications/SAS Data Integration Studio/DI Studio Common Data/Generated Transformations' is not a recognised standard transform for DI Studio 4.8. Exported projects which utilise this transform will not be compatible with standard installations.

WARNING: The custom transform 'sFTP' found at configured location '/System/Applications/SAS Data Integration Studio/DI Studio Common Data/Generated Transformations' is not a recognised standard transform for DI Studio 4.8. Exported projects which utilise this transform will not be compatible with standard installations.

WARNING: The custom transform 'Upload File To Amazon S3' found at configured location '/System/Applications/SAS Data Integration Studio/DI Studio Common Data/Generated Transformations' is not a recognised standard transform for DI Studio 4.8. Exported projects which utilise this transform will not be compatible with standard installations.

Re: Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sat, 12 Oct 2019 10:46:43 GMT

I also applied following note too -> http://support.sas.com/kb/56/034.html

Unable to Open Data Integration(DI) Studio Job Editor Screen

turcay — Sat, 12 Oct 2019 10:34:28 GMT

Hello everybody,

I was able to open Job Editor screen, when I double click to DI Studio Job but suddenly, I am not able to open Job Editor screen in DI Studio.

I checked for the following note-> https://support.sas.com/kb/41/571.html and it seems that the file is JavaArgs_1=-Xmx1024m and JavaArgs_13=-XX:MaxPermSize=128m

I also went to SAS Management Console Metadata Manager - Active Server - Foundataion - Analyze/Repair Metadata and it seems that it verified Metadata Files.

@joeFurbee @LinusH @AllanBowe @JohnJPS @Bipasha @Patrick

Thanks

Create New Variable by Getting Begining and Ending Value - Need Short Fix

turcay — Tue, 11 Jun 2019 18:43:58 GMT

Helle everybody,

Thanks to @Ksharp, @LaurieF , @r_behata, @novinosrin I made it my following question -> https://communities.sas.com/t5/SAS-Programming/Create-New-Variable-by-Getting-Begining-and-Ending-Value/m-p/529693#M144768

However, I want to do little changes in my question;

let's say that I have a following population ;

Data Have;
Length ID 8 DateCharacter $ 32;
Infile Datalines Missover;
Input  ID DateCharacter;
Datalines;
1 201601
1 201602
1 201603
1 201604
1 201605
1 201606
1 201607
1 201608
1 201609
1 201610
1 201611
1 201612
2 201605
2 201606
2 201607
2 201608
2 201609
2 201610
2 201611
2 201612
;
RUN;

Instead of following view;

I want to see whole periods and table_names same ->

As I tried to say as above; if 01MAY2016 is equal to period 5 in 12 months range then every 01may2016 should equal to period 5 same for other months. And table_name variable should be constant, as you can see in the image.

We need to count distinct YearMonth values then give the range between Begining and Ending Value and then assign the period values for this range. I hope I could make myself clear?

If can somebody help about this, I would be so happy.

Thanks

Re: How to Drop Earliest Date and Add the Latest Date into Data Set?

turcay — Tue, 11 Jun 2019 18:18:52 GMT

Thank you I also tried to do with following way but it does not work;

proc sql;
create table have3 as
select * from have
union all
select * from have2 where YEARMONTH not in(select YEARMONTH from have) ;
quit;

proc sort data=have3;
by ID descending yearmonth;
run;

proc sql noprint;
  select count(distinct(yearmonth)) into :countyear from have3;
quit;
%put &countyear;

data have;
set have3;
by id ;
if not last.id and &countyear.>12;
Run;

any suggestions? @ChrisNZ @Ksharp @Reeza @novinosrin @LinusH @Kurt_Bremser @Quentin @SuryaKiran

Re: How to Drop Earliest Date and Add the Latest Date into Data Set?

turcay — Tue, 11 Jun 2019 17:07:53 GMT

Thank you for your response but I think we both need to control 12 month count and min and max yearmonth control. If there is 12 distinct yearmonth and have data set max(yearmonth) is not equal to Have2 table max(yearmonth)

It should be like following but becaust it is character variable it does not work. Can you help me about it?

proc sql noprint;
  select count(distinct(YEARMONTH)), min(YEARMONTH),max(YEARMONTH) into :countyear,:minyear, :maxyear from HAVE;
quit;
%PUT &countyear.;
%PUT &minyear.;
proc sql noprint;
  select max(YEARMONTH) into :maxyear from HAVE2;
quit;
%PUT &maxyear.;


data WANT;
  if &countyear=12 and max(YEARMONTH) ne "&maxyear" then set HAVE(where=(YEARMONTH ne "&minyear")) HAVE2;
  else set HAVE ;
run;

Re: How to Drop Earliest Date and Add the Latest Date into Data Set?

turcay — Tue, 11 Jun 2019 16:02:44 GMT

Hello,

Thank you for your response. However, what if my have2 table come 201705 again, I do not want to multiplixity. I want to prevent it. I think we need to add some more controls, right?

Data Have;
Input  ID YEARMONTH $;
Datalines;
1 201606
1 201607
1 201608
1 201609
1 201610
1 201611
1 201612
1 201701
1 201702
1 201703
1 201705
;
Run;
Data Have2;
Input  ID YEARMONTH $;
Datalines;
1 201705
;
Run;

proc sql noprint;
  select count(distinct(YEARMONTH)), min(YEARMONTH),max(YEARMONTH) into :countyear,:minyear, :maxyear from HAVE;
quit;
%PUT &countyear.;
%PUT &minyear.;
%PUT &maxyear.;


data WANT;
  if &countyear=12 then set HAVE(where=(YEARMONTH ne "&minyear")) HAVE2;
  else set HAVE ;
run;

@ChrisNZ

Thanks

Re: How to Change Type and Format of a Variable Without Renaming?

turcay — Wed, 30 Jan 2019 00:38:57 GMT

Thank you for your response.

But what if I have more than one variable. For example, what if I have 300 variables in my data set, should I write them one by one ?

How to Change Type and Format of a Variable Without Renaming?

turcay — Wed, 30 Jan 2019 00:02:51 GMT

Hello everyone,

I have one more simple question. I want to change the type and format of Yearmonth variable without changing its name in PROC SQL Actually, I was thinking that I am writing the correct code however, nothing has changed. Can somebody help me to create my desired format for the variable YearMonth, please?

Data Have;
Input  ID YEARMONTH $;
Datalines;
1 201606
1 201607
1 201608
1 201609
1 201610
1 201611
1 201612
1 201701
1 201702
1 201703
1 201704
1 201705
;
Run;
PROC SQL;
CREATE TABLE WANT AS
SELECT *,Input(YEARMONTH,YYMMN6.) AS YEARMONTH Format=date9.
FROM Have;
QUIT;

Desired;

Thank you

How to Drop Earliest Date and Add the Latest Date into Data Set?

turcay — Tue, 29 Jan 2019 23:51:53 GMT

Hello everyone,

I would like to ask you question related to data manipulation. I want to drop the noncurent year and add the current year into my data set (HAVE). Also I want to do this when my data set (HAVE) includes 12 different yearmonth value.

Actually, I made my desired output as below(data set want) but I am not sure whether it is the correct way to do this.

ıf somebody has more practical method, does s/he help me, please?

Data Have;
Input  ID YEARMONTH $;
Datalines;
1 201606
1 201607
1 201608
1 201609
1 201610
1 201611
1 201612
1 201701
1 201702
1 201703
1 201704
1 201705
;
Run;
Data Have2;
Input  ID YEARMONTH $;
Datalines;
1 201706
;
Run;

PROC SQL NOPRINT;
    SELECT COUNT(DISTINCT(YEARMONTH)) INTO :COUNTYEAR FROM Have;
QUIT;
%PUT &COUNTYEAR;

%MACRO LOOP;
%IF &COUNTYEAR=12 %THEN %DO;
PROC SQL;
CREATE TABLE HAVE AS
SELECT * FROM HAVE
HAVING YEARMONTH NE MIN(YEARMONTH);
QUIT;
PROC SQL;
CREATE TABLE WANT AS 
SELECT * FROM HAVE
 OUTER UNION CORR 
SELECT * FROM HAVE2
;
Quit;
%END;
%MEND LOOP;
%LOOP;

Thank you,

Re: Create New Variable by Getting Begining and Ending Value

turcay — Thu, 24 Jan 2019 09:23:11 GMT

Like following;

data temp;
 set have;
 by id;
 if first.id then period=0;
 period+1;
  d=input(DateCharacter,yymmn6.);
 format d date9.;
run;

proc sql;
create table want as
select *,cats(put(min(d),date9.),'_',put(max(d),date9.)) as table_name length=40
 from temp
  group by id
   order by id,d;
quit;

It seems it is working without any problem