@DrAbhijeetSafai wrote: Yes @FreelanceReinh , which, I had asked a further query here, below the same thread. The answer I linked to was the reply to that further query.   Please let me know if I am missing something while using 'options work' statement etc. The WORK= system option is one of those options which cannot be changed via the OPTIONS statement. (Note that "OPTIONS statement" is not listed in section "Valid in:" at the top of the documentation of the option.) This is because using an OPTIONS statement requires a running SAS session, which in turn needs an established WORK library. Luckily, you don't need to change the WORK= system option, as explained in my reply of last week starting with "There is no need to change anything. ..." ... View more

Hi @DrAbhijeetSafai,   I answered this question last week in your more recent thread: https://communities.sas.com/t5/SAS-Programming/How-to-copy-values-of-a-column-in-SAS-viewtable/m-p/923170/highlight/true#M363472  ... View more

For even greater simplicity, you can omit the VAR statement in Paige Miller's PROC MEANS step, as the procedure will then analyze all numeric variables in the input dataset. ... View more

Hello @PriyaB,   In addition to the insufficient length specifications, at least for variable STATION, mentioned by @Patrick (I disagree with his comment about "location $", though) there is the issue of embedded blanks in the character values -- assuming that the "JA digit sequence" part of your data lines is the intended value of STATION and the rest is for LOCATION.   It looks like the two values on each line are separated by two blanks (green rectangles below). But from a screenshot we can't tell for sure if a "blank" is an ordinary space character (ASCII code 32). Strangely enough, the two "blanks" (?) indicated by the red arrows above do not occur in the screenshot of your output -- which suggests that you created that output from slightly different data lines.   Character variable STATION is created with the default length of 8 bytes, but presumably ought to accommodate up to 16 characters. You increased the length of LOCATION to 20 bytes, but this is still insufficient for the 22-character string "MIYAKE-JIMA, TOKYO, JA" (or do you want to omit the "JA" at the end because it is redundant in a dataset named weather_japan?).   So, you could use length station $16 location $22; input station & location &; The ampersand signs allow for the embedded single blanks in the values (see documentation INPUT: List), given the double-blank column separators.   Alternatively, you could integrate the length definitions into the INPUT statement by adding informat specifications and omit the LENGTH statement: input station &:$16. location &:$22.; (see again the INPUT: List documentation; this is modified list input)   or, similarly, with a more generous, common length definition for both variables: input (station location) (&:$25.);   ... View more

As I explained in that previous thread, datasets in the WORK library can be opened with the Universal Viewer like datasets in any other library. You can even open datasets that are not assigned to a library (with a LIBNAME statement) at all. The Universal Viewer works with .sas7bdat files wherever they are stored and it then calls the folder where the dataset resides a "library" (see Library tab in the software) and lists all .sas7bdat files it finds there. ... View more

Hello @DrAbhijeetSafai,   I don't think this is possible with VIEWTABLE, but it should work with the SAS Universal Viewer, which I suggested to you earlier this year. (Actually, I have only tested it by copying to Notepad because I don't have Excel on my workstation. But copying from Notepad's .txt file to Excel on another PC worked, so it should work directly as well.) ... View more

Hi @rogerward,   You can also use the RETAIN statement: data want; set have; newcounter=ifn(id=lag(id),coalesce(counter,newcounter),counter); retain newcounter; run;   The code can be simplified if (as in your sample data) the COUNTER of the first observation of an ID is never missing: data want; set have; newcounter=coalesce(counter,newcounter); retain newcounter; run; ... View more

@SASdevAnneMarie wrote: Do you know please how to add the condition and in this expression, like "/\b2,25|\b2\.25|\b1,75|\b1\.75/ and 'RATE'". So you want to check if a string contains one (or more) of the numbers discussed previously and also the string "RATE" (or "'RATE'" with single quotes? Perhaps case-insensitive?)?   You could search for "RATE" with a separate function call (e.g., of the FINDW function). However, if you know positively that "RATE" would always occur before (or always after) the number, you can add it conveniently to the regular expression: "/\bRATE\b.*(\b2,25|\b2\.25|\b1,75|\b1\.75)/i" This regex matches RATE, rate, Rate, etc. (but not Strategy, rated, etc.), followed by a word boundary and a sequence of (zero or more) virtually arbitrary characters and then any of the four numbers of interest. So, example strings matching this pattern are Rate:1,75 The rate is exactly 2.25%. estimated rate: 1.737 (95%-CI: 1.716-1.758) The latter match could be avoided by adding \b metacharacters after the numbers, but then 2.250 etc. would no longer match (without further extensions of the regex). ... View more