Hi All,   1. we have option to schedule SAS jobs automatically in internal sas tool.  2. Now we need to pick the latest file from path where logs get saved and then,  3. we will need to check for errors and send notification email with or without errors.      Please suggest , steps to achieve above. thanks.  ... View more

Hi All,   Greetings.    We have a scenario like, there is an external file with value as below.  "January 27, 2020 10:55:00 AM" "January 27, 2019 12:23:00 PM" .... ... etc..   we need to validate this each time when we receive, whether this column has all values with same format (as mentioned above) or not. if not we need to flag them as error. this is the requirement along with many other with other variables.    Question : So here, to convert above date values into sas date type, which date informat we can use . Please suggest. (I know WORDDATE20. will read when we have only date in words. But we need SAS informat, which converts into sas date format, when both date and time is present as mentioned above).       Thanks in advance.    Regards, Hari.     ... View more

Hi All,   Please help to create a SAS dataset when we have data as below which has more than 1 delimiter. Here , delimiter is | and actual data is saved between double quotes.    we have data like below, which is coming in a .csv file and data is saved in first cell of each row. 1.  Please note that here we need to consider '|' as a delimiter.  2. we need to read values with out quotes or even if quotes come , it's fine we can compress later.   3. values for 4th column is null.  4. so finally, we need to have a dataset with 6 columns and 2 rows.    Reqnr|"S Id"|"abc"|"abc Date"|"Name"|"cont" FCQ00001|"FCQ00001000"|"No"|""|"FLOW"|"EDTA K2 4mL (violet)" FCQ00005|"FCQ00005000"|"No"|""|"FLOW"|"EDTA K2 4mL (violet)"   Please help on this. Thanks in advance.   ... View more

Hi All,   - I have written Proc transpose with ID statement in which there are 10 variables and 4 of them(Var7 - 10 in table below) have more null values for most of the records. - This is causing number of warnings, though there is no issue in Output. Please check table below o understand better.    Please suggest me, how to avoid warnings in this case. thanks in advance.       Var 1 Var 2 Var 3 Var 4 Var 5 Var 6 Var 7 Var 8 Var 9 Var 10 1000 aa XX CC XYZ 7-Jan-21         1001 bb XX CC XYZ 2-Sep-20         1002 cc XX CC XYZ 18-Sep-20         1003 dd XX CC XYZ 30-Nov-20         1004 ee XX CC XYZ 27-Mar-20         1005 ff XX CC XYZ 29-Apr-20 More than 10 NAP 29-Apr-20 Skeletal Survey 1005 XX XX CC XYZ 29-Apr-20 Less Than 5 xxx 7-Jan-21 abc survey              ... View more