Hello,   I have a table that has the below columns...   ID   Name1     Name2     Name3     Age1     Age2      Age3     Last1     Last2      Last3   With the exception of the column named ID, I would like to re-organise the columns based on number at the end so that I get the below result...   ID    Name1    Age1     Last1     Name2     Age2      Last2     Name3     Age3      Last3   I have used PROC SQL, to just select them in the order I'd like, however I want to know if there is a quicker way that will do it automatically for me?   Cheers ... View more

Hello,   Looking for some assistance...   I have a dataset with a column containing various member_id's (see below example). I would like the first character, everything left of the dash, to be moved to the end of the string prefixed with two 0's and the dash removed. For example, using the below example, looking at the first member id, I'd like 5-12344 to become 12344005.   COLUMN A 5-12344 5-1234 5-123456 7-345 2-3456   Thanks ... View more

Hello,   I have the below code which looks at exporting the datasets. However, I'd like the email to have the HTML results attached as a PDF instead - any ideas?   %let user = crf; %let dataset=CIRC; %let dataset1=/user/&user/CIRC.csv; Data &dataset; set CIRC; run; proc export data=&dataset outfile="&dataset1" dbms=csv replace; run; ***update email recipients here***; filename mymail email To=("cameron.test@test.com" ) subject="Circulation Report - Prev 90 days" attach=("&dataset1"); data _null_; file mymail; put "Hello,"; put " "; put "Please see the attached circulation file for campaigns sent in the last 90 days."; put " "; put "This report can be used as a retrospective sense check. "; put " "; put"Thanks,"; put"CWR automated message"; run; ... View more

Hi,   I have the below code that shows using uniform axis, the trended comparison between 2016 vs 2017. However, I'm trying to specify the legend into the chart but nothing works...any help would be appreciated. I would like two keys; one for '2017' and oanother for '2016'.   GOPTIONS RESET=ALL CBACK=WHITE BORDER HTITLE=12PT HTEXT=10PT; SYMBOL INTERPOL=JOIN COLOR=BLACK VALUE=DOT; LEGEND1 LABEL=(POSITION=(BOTTOM RIGHT) ) VALUE=('YR16' 'MTH_RENEW') ACROSS=1; TITLE 'RENEWALS 2016 VS 2017'; PROC GBARLINE DATA=CVMGEN.EME_RNWLS_2017 UNIFORMAXES; VBAR MTH_RENEW / SUMVAR=YR17 MAXIS=AXIS1 ; PLOT / SUMVAR=YR16; RUN; QUIT; Thanks ... View more

Hello,   I have a dataset that looks like the below...   ID               Tran Date                 Enrol Date            Expiry Date 12345         04JAN2015              01JAN2015          31DEC2015  12345         03DEC2016              01DEC2016        31NOV2017  12345         04APR2017              01APR2017         31MAR2018  12345         03JAN2018              01JAN2018          31DEC2018    Basically, I have multiple lines of record for each ID for every time they renew a membership. I'm trying to work out the difference bewteen the transaction date and the closest expiry date. This will then tell me whether the renew before or after the expiry date and how many days difference it is.   Any help appreciated. ... View more

Hello,   I have the below code whereby I'm trying to import multiple .csv file types from a network folder. I access SAS through citrix reciever.   DATA TEST; INFILE '\\CLIENT\O$\EUROMKTG\MARKETING ANALYTICS DEPT\CAMPAIGN REPORTING\TEST\CLICKS.CSV'; PROC IMPORT OUT= WORK.NEWDATA DATAFILE='\\CLIENT\O$\EUROMKTG\MARKETING ANALYTICS DEPT\CAMPAIGN REPORTING\TEST\CLICKS.CSV'; RUN; Please can anyone help? ... View more

Hello,   Looking for some assistance - I have SAS Enterprise Guide 6.1 M1HF7 (6.100.0.4234) (64-bit). I use citrix reciever and am looking to import all files from a given folder on my local C drive. Below is the code I currently have but for some reason it falls over...   PROC IMPORT DATAFILE='\\Client\C$:\SAS\EME June.CSV' OUT= WORK.NEWDATA DBMS = CSV. REPLACE; GETNAMES=YES;   Please can anyone help?   Thanks, Cam ... View more