From what you see a data set with 3 variables should be able to replicate that. Two variables are the x and y axis variables. The third would indicate which "group" would be used to identify and set properties like marker type, color and size.   If by different "measures" you mean different variables holding one of the values then you modify the data to have a generic "value" variable, pick your name, and then add the group variable base on which variable supplied that value.   I don't use VA so won't try to provide an example but once you have data that looks like that it should be relatively easy.   An example would be the SASHELP.Class data set. Think of the X axis as Height, Y axis as Weight and Sex or Age as group variable. ... View more

As a minimum you should include the code that you are running. Then we have a chance to follow the attempt and may be able to provide comments. Better would be to show the Log from SAS when running your program to see if SAS is seeing potential problems. ... View more

Is the value supposed to represent a negative percentage?   Is the variable numeric or character? Proc Contents will help with this if you aren't exactly sure. If the existing variable has a length of 8  , implied from your value (100.00%, and is character then you will need to create a new variable as there is not enough enough space to insert the character. How exactly is the value created? That would be the place to address this instead of "fixing" later. Show the code.   Best is to provide example data in the form of a data step so we know exactly what we are dealing with.     ... View more

@dennis_oz wrote: Hi, I need some help. I have a column which has a format applied on the column. So before double clicking on the first row there was another value displayed. On clicking it displays '01'.    The issue is when when I try to append this dataset to another dataset the format value is lost and '01'  is retained. How can I retain/preserve this format value rater than have the underlying value.   I hope I am clear on question guys. any help will be appreciated.     thanks.   Means that the format is not applied to the base data set . Use Proc Datasets to modify the data set in place to apply the format to the variable. ... View more

@Discaboota wrote: Thank you Tom for your help, it is what I was looking for. I am thinking of dividing the data into groups so that I can deliver groups sequentially to the required person. If the original sequence is needed then perhaps the below. This increments a counter every 20 observations. data want; set have; retain group 1; if mod(_n_,20)=0 then group+1; run; ... View more

Since we do not have your data we can't test this.   Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.   What is your current system PAPERSIZE setting? Changing that may be appropriate if the PDF is not intended for printing on specific sizes of paper. You can make a logic size as big as needed to share the PDF.     ... View more

@MK_96 wrote: HOW CAN I EXTRACT ONLY "Y" VALUES TO NEW VARIABLE FROM BELOW CODE .? IS THERE ANY FUNCTION THAT WORKS ?? DATA CHK; TEXT="122 AGH Y yy jaja Yy &#^#7aa "; RUN; There are probably multiple functions that work depend on what the desired result actually is. If you want to remove the Y, first you have tell us if that means remove the lower case y as well. I say this because you are using all capital letters so it is not clear. Here are just some of the possible examples DATA CHK; TEXT="122 AGH Y yy jaja Yy &#^#7aa "; text2 = compress(text,'Y'); text3 = compress(text,'y'); text4 = compress(text,'Y','i'); text5 = compress(text,'Y','ik'); text6 = translate(text,' ','Yy'); RUN; Compress removes characters. Examples show just upper case Y, lower case Y, case insensitive Y, remove everything except the case insensitive Y's (extracted from the string and KEPT). Translate replaces characters with a different single character. TRANWRD might be another option as well as regular expressions. But since you did not provide an example of what you expect this is all guesses as to what you may want. ... View more

Your example data should include enough information that you can point to variables and values to do the task. Which means how do we know what disease? What "particular date" ?   Do you have a SAS data set with the information? If not building one or more sets with the information is a first step.   ... View more

I am sorry but I do not understand what you expect.   Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character), name and even values.   Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against. Or write your own small example data step.   Warning: Use of the same data set as input and output such as you have in your macro: data &ds; set &ds; <other code> run; can cause problems as the code completely replaces your &ds data set. So a minor logic error can corrupt data a bit, a major logic error can result in an empty data set depending on what the other code actually does. This can be compounded in macros as unless you set options like MPRINT you don't typically get as much information in the LOG and don't see what happened. And after the first pass replacing the data set you may have to go back in process to rebuild the original input.   ... View more

One approach that can be quite flexible is to move the logic and values into a Format or Informat depending on usage. I didn't type out all the values, the pattern should be obvious.   proc format; value $Fcodeflag 'F01','F02','F03' = "in list" run; data want; set have; array D(*) D01-D30; do i= 1 to dim(d); if put(d[i],$fcodeflag.)= 'inlist' then flag=1; end; drop i; run Some advantages of a format approach:   1) one place to look for such and modify if you keep code organized 2) if the values are in a data set you can use code to turn the values into a format. So adding a group of values to the set and running code may be simpler than modifying the places where you might use the list.   Note the use of the (*) instead of 30 in the Array statement. With a list of variables the * will mean "get the size from the list". So if you add or remove variables the size adjusts to the provided variables. The DIM instruction for the loop control. Dim returns the defined size of the array. So with the (*) in the array any change to list of variables also adjusts the loop counter.   Also if you only want to find set the flag one time, goes to code efficiency you can execute a LEAVE instruction to quit the loop as soon as the first match is found: data want; set have; array D(*) D01-D30; do i= 1 to dim(d); if put(d[i],$fcodeflag.)= 'inlist' then do; flag=1; leave; end; end; drop i; run Which may a second use if you do not drop the i variable the value would be the index of the array where the value is found. Might be useful in some cases. ... View more

It may help to provide a starting data set and what you expect.   You have not clearly described what the resulting data set should contain, variable names, types and some specific values.   Or why. ... View more

Actual values and working through and example would be useful. I can't tell what you expect for output. How do you expect to provide the "Varx_y" value? Did you mean to say " for each record(raw_name)" instead of " for each record(raw data)"?   Please be consistent about discussing values in terms of variable names. We have to guess what you mean when provide variable names that do not match terms discussed like " parameter name, parameter code and AVAL" when there are no variable actually with those names.   Maybe you want something like this: Data want; set source_info; where raw_name ='raw1'; run; Remember that computers are pretty literal and if your spelling of 'raw1' is different in the actual data set, such as "Raw1" or "raw 1" or "raw_1" then the where condition might not find what you want.   ... View more

You say "identifying diseases" in the title. Which of these dates relates to disease? Before which "particular date".   You must define characteristics in terms of the variables you share with us as we do not know any interpretation without your help. ... View more

@abx wrote: Thank you! It works! but I am have really large dataset. Splitting by each cus_number is quite a lot for me. Still have not answered why the split is so important to the process.   In a very large number of cases it is beneficial to add a variable that describes the "group" of interest and process using BY processing. ... View more

I had something similar happen recently on a system that has not had any changes to SAS itself in over a year. In my case one editor window stayed the same and only new windows had the font problem. Similar solution: restart SAS and no problem. One time in using PC SAS since version 6.06, nearly 30 years.   I blame it on some Windows update somewhere, possibly to fonts or font settings. ... View more