Hi Guys...I am using Conditional Start-End and theare are three conditions that has to be true as follows: a sas table is the source with following columns and values act = 20345(numeric) vir = 21345(numeric) act_flg = N(character, size 1) vir_flg = N(character,size 1) Following is what I am putting in 'condition' act < vir & act_flg='N' & vir_flg='N' if I used the first condition i.e. act<vir .. conditional flow executes but when I put all the above conditions the conditional flow doesnot execute. Somehow the conditions are not true when I put all three... pls advise!
... View more
Scenario: There are three Customers that have same phone no. C1 with Customer Code CD1 C2 with Customer Code CD2 C3 with Customer Code CD3 With same phone number 123456789 The source comes as follows Phone CustCode RefCustCode 123456789 CD1 C1 123456789 CD2 C2 123456789 CD3 C3 The following output is desired: Required Table Code RefCustCode RelatedRefCustCode Phone CD1 C1 C2 123456789 CD1 C1 C3 123456789 CD2 C2 C1 123456789 CD2 C2 C3 123456789 CD3 C3 C1 123456789 CD3 C3 C2 123456789
... View more
Hi guys, I have following dataset have; ID Name sportsplayed languagesSpoke 1 Richard chess|golf|Sudoku ENG|HINDI|PUNJABI 2 SAM judo|golf Arabic|ENG 3 Mich Soccer ENG 4 Rach Cards ENG|HINDI 5 Nic Cricket|Soccer ENG Required Output has to be want; ID NAME QUALITIES 1 RICHARD chess 2 RICHARD golf 3 RICHARD Sudoku 4 RICHARD ENG 5 RICHARD HINDI 6 RICHARD PUNJABI ...and so on I know how tp pivot one column...pls help
... View more
Hi Guys, I have following datasets dataset1 nameid name sportsPlayed 1 sam cricket|football|badminton 2 ravi cricket|chess The output sas table has to be outputDATASET nameid name sportsPlayed 1 sam cricket 1 sam football 1 sam badminton 2 ravi cricket 2 ravi chess I tried using sort and 'by' but ... Thanks in advance
... View more
Hi Guys, I have following datasets dataset1 nameid name sportsPlayed howGood 1 sam cricket vg 1 sam football g 1 sam badminton a 2 ravi cricket vg 2 ravi chess vg The output sas table has to be outputDATASET nameid name sportsPlayed 1 sam cricket|football|badminton 2 ravi cricket|chess I tried using sort and 'by' but seems like I am not getting the idea correctly... Thanks in advance
... View more
the rules are as follows: 1) the first csv will be named as output1.csv the second csv will be named as output2.csv 2) output csvs does not require headers. note: there is a column in the source dataset that is rownumber...
... View more
Hi Friends, I have following sas dataset Name Age Country Sam 15 CA Rohan 13 USA Mich 16 IND the result required is separate CSVs for each record in above dataset. In this case it will be three CSVs with one record each.
... View more
Hi, Shmuel Thanks for the reply...I would clear out the question more... I have a .txt file that I have to move into SQL database. This text file have five fields and I receive this file daily with around 5k records in it e.g. Field1 Field2 Field3 Field4 Field5 id1 name1 age1 DOB1 chr1,chr2,chr3 id2 name2 age2 DOB2 chr4,chr5,chr6 I am using SAS DI for ETL, The output should be as follows Field1 Field2 Field3 Field4 Field5 id1 name1 age1 DOB1 chr1 id1 name1 age1 DOB1 chr2 id1 name1 age1 DOB1 chr3 id2 name2 age2 DOB2 chr4 id2 name2 age2 DOB2 chr5 id2 name2 age2 DOB2 chr6 So, please base the solution based on above scenario....would appreciate if you could help me based on SAS DI environment as we use transformations(eg. File Reader, Extract etc.) for ETL and we do not use BASE SAS.
... View more
Hi, I have following data set Column - A ac,dc,gh,th,kl a,t,hj,tyu xy,hgt,g125,ujy How can I move it to Column B ac dc gh th kl a thj tyu . . . I am using SAS DI, would appreciate if I could get a function for this.
... View more
I have SQL server as the data source and when I register a table in SAS DI, in some of the text fields a black diamond with question mark appears in it. Is there a way to handle this.
... View more
