Hi Everyone   I have created this table, however what i need is the "Status" to be "Not Verified" for all, if one of them is "Not Verified" for the same name.   Current Table: Name rule status abc not verified not verified abc verified verified abc verified verified abc verified verified   What i am ideally looking for is: Name rule status abc not verified not verified abc verified not verified abc verified not verified abc verified not verified     Thank you ... View more

Hi All,   I am trying to import an Excel file (.xlsx), which currently sits on the server. The query i have been trying to run is as below:   Proc import datafile=New_File_&Pdate..xlsx (&Pdate:is a macro assigned for previous day) out=Prev_File dbms=XLSX; Getnames=Yes; run;   However, i have been getting this error:   16 Proc import datafile=New_File_&Pdate..xlsx NOTE: Line generated by the macro variable "PDATE". 16 New_File_18JUL2016 _________________ 22 201 NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string. ERROR 201-322: The option is not recognized and will be ignored.     Can you please help me understand, what the error is.   Thank you ... View more

Hi All,   I have 2 datasets, which i need to match and delete those records which match. Below is sample of what i am referring to: Dataset1: Name1 Valentino Rossi Marc Marquez George Lorenzo Valentino   Dataset2: Name2 Valentino Marc   i am using query below:   proc sql; CREATE TABLE del_name as Select A.*, B.*   FROM Work.dateset1 as a left join Work.Dateset2 as B on A.Name like B.Name ; run; quit;   The Issue is that, it matches only exact cases and does not consider anything preceeding the first name. Name1 Name2 Valentino Rossi   Marc Marquez Marc George Lorenzo   Valentino Valentino   The Output should look something like below:   Combined Data   Name1 Name2 Valentino Rossi Valentino Marc Marquez Marc George Lorenzo   Valentino Valentino   Appritiate your help.   Thanks ... View more

Hi,   I am trying to calculate Date difference between rows for the Data as below:   Name Date Seq_id Days_diff xyz 1/01/2016 1 0 xyz 1/01/2016 2 0 abc 3/01/2016 1 2 abc 4/01/2016 2 1 abc 7/01/2016 3 3 def 10/01/2016 1 3 def 10/01/2016 2 0   I am using the query below to calculate the Days_Diff:   data Dummy5; set Dummy4; days_Diff = intck('days',DATE,lag(Date)); by name; run;   As you can see in the table, the function calculates the difference in days based on the previous row (Which is fine), but does not take into consideration of Seq_id.    Can anyone help me to make the function throw the result as below, where the difference in days restarts when Seq_id = 1:   Name Date Seq_id Days_diff xyz 1/01/2016 1 0 xyz 1/01/2016 2 0 abc 3/01/2016 1 0 abc 4/01/2016 2 1 abc 7/01/2016 3 3 def 10/01/2016 1 0 def 10/01/2016 2 0   Thank you ... View more