Hi Don,   Yes, this is possible. With the Rank functionality, you can set different color tresholds. In your case it should be something like "If Current Price < Avg Price (6 months) then Red".   To be able to use these 2 measures, you should either create calculated items or do the calculations up front in your data preparation.   I don't think it's a good idea to combine both of your methods in one object / page, it will be confusing for end users.   Hope it made sense,   Jasper ... View more

Hi! One way to do this is by creating a parameter and connect it to a text input box.   Then create a calculated measure that checks the value of the parameter and then chose the corresponding kpi, ie: if [parameter] = 'kpi1' then kpi1 else if [parameter] = 'kpi2' then kpi2 ... ...   Then use this calculated measute in your cross-tab   One problem is that you can't change the format dynamically depending on the chosen kpi, they all get what you specify for the calculated measure.   Another is that the user must type the exact name of the kpi. One way to solve this is that the text box filters a list with your kpi's and the user selects kpi from this list, also you create another parameter used in the calculated measure.   Hope this can give you some inspiration 🙂   //Fredrik ... View more

If you have command line access, then you can simply: filename tmp pipe 'dir "..." /b'; data want; length name $200; infile tmp; input; name=_input_; run; That is windows, you can do the same on other OS.     I would question why you need this though?  File operations are much better done with specific tools for the task.  A simple batch file with: dir/b > files.txt Or more complicated VB script to loop etc. merged in with what ever your process is, I expect it involves copy/pasting or archiving or something like that.  SAS really isn't an OS level tool.  ... View more

Stealing @gamotte's example data: data have; infile cards dlm=',' dsd; attrib Date format=date9. informat=ddmmyy8.; length name $10.; input ID Date name $ Amount Flag_first_name Flag_last_name; cards; 12345,21032016,Bob,200,0,0 12345,21032016,Bob,300,0,0 12345,31122014,Bob,500,0,0 67890,31012012,John,100,0,0 67890,31012006,John,200,1,0 ; run; proc sort data=have; by id date amount; run; data want; set have; by id; if last.id; run; ... View more

Do you have SAS/ACCESS to PC Files licensed and installed? Run proc setinit and proc product_status. ... View more

To see your licenses, run proc setinit. Who set up the SAS system? That person could easily tell you if (s)he needed to configure the metadata server. And you should be able to identify a running metadata server by its starting script, which would be called from SASCONF/Lev1/SASMeta/MetadataServer. ... View more

Dear all,   Thank you for the suggestions, since we do not have a sas admin team or sas manager in our org, I will make a call to sas India today and explain the requirement to them. may be they might provide further guidance. Thanks again!!     ... View more

Hi Patrick, Thank you for the insight, I value the same too. I have been trying my best to bring in the best practices. I hope for the best in this case. Thank you. ... View more

RPT files are from Crystal Reports and are not an open file format.  ... View more

1) Sharepoint should be access controlled, it should be linked to ActiveDirectory.  Plus you can put restrictions and such like in the build of the SP for this.  However it still does not make any sense to me to hide something which is only there to help people, if its not to be viewed and used, don't put it on there?   2)  Excel files are a really poor format.  Password protecting is a bit ridiculous to be honest.  Again as above, Sharepoint is access controlled and provides functionality, so why do you need to do this anyway, all you are doing is creating files which one day you will not be able to open.   3) Whatever you operating system or setup you are using will have an OS, be it linux or windows or something else.  These all have functions to delete files e.g x 'del "c:\temp\*.log"'; For windows. ... View more

SAS file names are 32 characters in length, start with a letter or underscore and can only contain alphanumeric characters and underscores, no spaces. Your names don't align with that. You can use longer names with spaces but then you also need to type it out that way every time and as a programmer I would never recommend that. It's a major PITA.   I'm not sure if you didn't put a file name or removed it from the log...but it shouldn't be a period for sure.   @don21 wrote: Hi Tom, Thankyou for the inputs but, still the query fails due to the file names . Error: 11 + proc import datafile= " ."  out= RM Deliquent Repayment Exception (label= " ." ); run; _________ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. ERROR 76-322: Syntax error, statement will be ignored.   ... View more