Hi,   I need some logic to carry out the following requirements if possible please.    My current table (New_Orders) has the following variables   Email Name REF Last Name Order Region Status TelNo Login_id   What I need is to create 2 new variables within this table called 'New_Order' and 'Curr_User'    Requirements New Variable 'New_Order' = if Login_ID is in table New_Orders and New_Orders_Prev_Month then 'Existing' else 'N/A' New Variable 'Curr_User'  = if Email is in table New_Orders and New_Orders_Prev_Month then '1' else 'N/A'   Thanks ... View more

Hi,    I need to create a proc import and import a csv from a previous run. I have an excel file of which is date stamped   Examples: All_Order_0219 All_Order_0619 All_Order_0719 All_Order_0919   As you can see, there isn't a file for each month as the code is run on an ad-hoc basis and currently, I manually update my PROC IMPORT to reference the most recent file.    What I am trying to do is avoid the user from having to manually state which file to import (below) and ideally, I'd like my code to look at the most recent file and automatically import, is there anyway of doing this please?   Proc Import Datafile='E:\Processing\Orders\All_Order_0919.xls' Out=Work.All_Order_Previous_Run DBMS=XLS replace; run;   Thanks ... View more

Hi,    I have a variable (Date_In) which has the date and time (2016-05-21 10:06:08).    How can I remove the time from the variable and format the date as DDMMYYYY?   Thanks   ... View more

Hi,    I have a CSV file that I need to import into SAS but the issue I have is around 2 date variables (Date_Set and Date_Out) within the CSV as they are both formatted as:    26/07/2017 10:16:00   I need a step within my PROC IMPORT to import all the data but the 2 date variables (Date_Set and Date_Out), I need these formatted as a shorthand date only and for the time element to be removed (ddmmyyyy).   I have looked through the forum and struggling to find a resolution, any idea how to resolve please?   Thanks ... View more

Hi,   I have the following code (below) of which I am getting an error that I don't know how to get around, any ideas please?    proc sgplot data=Aggregated_Results_2 (obs=250); scatter x=email y=Actual_BS_Income / datalabel=Observation ; xaxis discreteorder=data display=none ; run;   ERROR: Unable to load the Java Virtual Machine. Please see the installation instructions or system administrator. ... View more