How can we import SAS EG program/project in SAS VIYA ... View more

I have a source table/dataset and I want two separate  target tables/datasets Target Table 1, Target Table 2 as below . Please advice.   Source table Target Table 1 Target Table 2 ID Name Phone No 10 AAA 123 20 BBB 234 30 CCC 434 40 DDD 343 50 EEE 442 ID Name 10 AAA 20 BBB 30 CCC 40 DDD 50 EEE ID Phone No 10 123 20 234 30 434 40 343 50 442 ID is the key column; Name and Phone No are non-key columns   I have tried below code and it worked too. data source; input id name $ ph $; datalines; 10 AAA 123 20 BBB 234 30 CCC 434 40 DDD 343 50 EEE 442 ; run;   data Target1 ; set one(drop = ph); run;   data Target2; set one(drop = name); run; Please suggest any other approach and also can we do it in single data step? All suggestions are welcome.   Thank you.     ... View more

I want to read values from mytext file   mytext RamabcSamabcKaleabc   How to read data this type of file. Please advise. Also please let me know if i can specify string in dlm option for e.g dlm='abc'   ... View more

Hi All,   Please help me below query .  I need date for last  friday for every month  like JAN2021  -> 29/01/2021 FEB2021 -> 26/02/2021 MAR2021 -> 26/03/2021 APR2021 -> 30/04/2021 MAY2021 -> 28/05/2021 and so on till DEC2021  ... View more

Hello All,   I have below requirement   In a external file I have data like  Sam,sam11@abc.com ,abc  22/09/1992,Math Ram,ram5@abc.com ,xyz 22/09/1993, English   I want to read data from this file and get output like   Sam,sam11@abc.com ,abc 22/09/1992,Math Ram,ram5@abc.com ,xyz22/09/1993, English   Please let me know the how can i solve this. Thanks! ... View more