I am programming in SAS 9.4 for Windows and reading a PDF document which has variable labels with values. It looks something like: Name: Sue Today's Date: 04/25/2018 Age: 54   I have been able to read the PDF document and get a dataset with 3 records that looks like: FieldName       values               labels Name               Sue                   Name Todays_Date    04/25/2018      Today's Date Age                   54                     Age   I would like to create a dataset with 1 record that looks like: Name          Todays_Date     Age Sue             04/25/2018           54   I am looking for ideas on how to do this.   I tried writing code that used macros but the macro is just putting in the line FieldName = values instead of the 3 lines Name = values, Todays_Date = values and Age = 54: data Have; length FieldName $ 20 values $ 20 labels $ 20; FieldName = 'Name'; values = 'Sue'; labels = 'Name'; output; FieldName = 'Todays_Date'; values = '04/25/2018'; labels = "Today's Date"; output; FieldName = 'Age'; values = '54'; labels = 'Age'; output; run; %macro Assign(FN, Value, Labels); &FN. = &Value.; %put &FN.; %put &Value.; %mend; data Want; set Have; %Assign(FieldName, values, labels); run; proc print data = Have; run; proc print data = Want; run; ... View more

Our clinical study is required to do Medical Device reporting to be compliant with the EU DIRECTIVES 90/385/EEC AND 93/42/EEC. We need to create a MED DEV report weekly in Excel. I have attached a picture of the template. The requirements are that the column widths, fonts and coloring have to match the template. I believe we also need to color code some columns to highlight modified records from new records. I know there are lots of resources in the community about creating reports in Excel, but has anyone specifically programmed the MED DEV report? I am not looking for how to generate the dataset. I am looking for the code to produce the Excel report from the dataset. This just seems like a task that many of us will have to do and it would be nice to have a common piece of code that is all debugged that we can reuse as a community. Or a nice SAS procedure (Proc MEDDEV?) that would create the report for us! I will post my solution when I have it running and debugged. I am not asking for anyone to create new code, but if you have already programmed this and are willing to share your code, that would be very nice!   Below is a picture of the MED DEV report in the Excel template:   ... View more

I am trying to use the same code for production and test. The goal is to have a variable at the top of the program to tell me if the environment is production or test, then this variable would be used in conditional statements.   I need to do 2 things: 1. Set different SQL Server ODBC connection strings based on whether I am in production or test 2. Set a variable to different directories for libnames and filename and ods rtf statements I am very open to suggestions. Here is what I am trying: For #1, this works: /* Set up SQL server connections */ %macro SetSQL(Environment = Production);        %if "&Environment." = "Production" %then %do;        /* Production environment */                       libname SQL odbc            noprompt="DRIVER=SQL Server;SERVER=xxxxxx;WSID=dbo;DATABASE=xxxxx;Trusted_Connection=Yes"                   preserve_tab_names=yes Ignore_Read_Only_Columns=Yes;        %end;        %else %if "&Environment." = "Validation" %then %do;        /* Validation environment */                       libname SQL odbc            noprompt="DRIVER=SQL Server;SERVER=yyyyyyy;WSID=dbo;DATABASE=yyyyy;Trusted_Connection=Yes"                   preserve_tab_names=yes Ignore_Read_Only_Columns=Yes;         %end;      %mend; /* Options are Production or Validation */ %SetSQL (Environment = Validatation);   Trying the same approach for #2 does not work. Are variables assigned in a macro local variables? Is there a way to make them global variables? %let Environment = Production; /* Production or Validation */ %macro SetDir;          %if "&Environment." = "Production" %then                           %let SICD_Dir = C:\Prod;           %else              %let SICD_Dir = C:\VAL;           %put "&SICD_Dir.";  /* This prints the correct value to the log */ %mend; %SetDir;   data _null_;      a = "&SICD_Dir.";      b = "&Environment.";      put a = b =; run; /* Error on the null data step for a = "&SICD_Dir."; line */ WARNING: Apparent symbolic reference SICD_DIR not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. */   I would then use the &SICD_Dir variable this way: libname raw "&SICD_Dir\Data";   Any help would be wonderful! ... View more