@Ksharp 👍   I swear it's impossible to know about all the ODS options and capabilities unless you stumble upon them and save a note somewhere. vsspace is not described on this page where it should be.   ODS has grown over the years, especially after the tagsets came along. There are now multiple ways to do things, with each method having different abilities and limitations. SAS should clean this up, pick a destination that can do it all and let the other destinations become obsolete, and document that destination properly. The worst most prolific is the relationship with Excel, as @ChrisHemedinger briefly demonstrated.             ... View more

See these answers. https://communities.sas.com/t5/ODS-and-Base-Reporting/Hyperlinking-in-Excel-using-ODS-Excel-and-PROC-REPORT/td-p/700582 https://www.lexjansen.com/pharmasug/2021/DS/PharmaSUG-2021-DS-037.pdf   ... View more

This marks the records for separation as you posted: proc sql; select *, count(distinct VALUE) 'Count' from TEST group by DATE; date id value OBS Count 15JAN2024 2 Y 9 2 15JAN2024 3 x 10 2 15JAN2024 1 x 8 2 22MAR2024 1 x 1 1 22MAR2024 3 x 3 1 22MAR2024 2 x 2 1 24MAR2024 2 x 5 1 24MAR2024 1 x 4 1 28MAR2024 1 x 6 1 30SEP2024 1 x 7 1       ... View more

@raja777pharma wrote: Hi,   How to separate data that have duplicate records when by id those are more than 2 records.   example: data test; date       id   value 22Mar   1     x 22MAr  2    x 22 Mar  3    x   24 Mar  1    x 24 Mar  2   x   28 Mar  1    x   30 Sep  1    x   15 Jan    1    x 15 Jan  2    Y 15 Jan  3    x   want two data set    Duplicate by date and value ,in duplicate include single records also in red color in one dataset  those are duplicate by value and green in another data set which are not duplicate by value   Note: if only one record for the date the records also consider as duplicate and separate The requirements are unclear, Why are the two 15JAN X observations not duplicates? ... View more

Not all Xpath syntaxes are supported. The documentation states: CAUTION These forms are the only XPath forms that the XML engine supports. If you use any other valid W3C form, the results will be unpredictable.   Unsure what's wrong with your code as I don't have time to check, but this works: data _null_; file '~/kk.xml'; put '<team>'; put '<name type="first">'; put 'Albert'; put '</name>'; put '<name type="last">'; put 'Einstein'; put '</name>'; put '</team>'; file '~/kkmap.xml'; put '<?xml version="1.0" ?>'; put '<SXLEMAP version="2.1">'; put '<TABLE name="TEAM">'; put '<TABLE-PATH syntax="XPath">'; put '/team'; put '</TABLE-PATH>'; put '<COLUMN name="VAR1">'; put '<PATH>/team/name[@type="first"]</PATH>'; * <=== namespace ; put '<TYPE>character</TYPE>'; put '<DATATYPE>STRING</DATATYPE>'; put '<LENGTH>30</LENGTH>'; put '</COLUMN>'; put '</TABLE>'; put '</SXLEMAP>'; run; filename XML "~/kk.xml"; filename MAP "~/kkmap.xml"; libname XML xmlv2 xmlmap=MAP; proc print data=XML.TEAM; run; Obs  VAR1 1 Albert   Expand from this working code to yours and see where things break.       ... View more

1. Do you miss a space? /Workbook/Worksheet [@{1}Name="Sheet2"]/Table/Row 2. Do you need to use the namespace? Can't you point to something like /Workbook/Worksheet ss:Name="Sheet2"/Table/Row 3. Have you tried asking SAS to generate a map and use that as your starting point? ... View more

SAS also shines by its backward compatibility. Take a program written for mainframe 40 years ago and it will likely run as-is today under Linux. ... View more

1. Post the full log please. 2. Did you check the data? This message can simply mean that the data was imported but some unexpected values were found. Please check. ... View more

To note that MEMSIZE is for memory including paging space. REALMEMSIZE is for RAM only.     ... View more

Your join is wrong. You don't use ref1. Your whole SQL is invalid (no  select , etc).   Check your code, this works as expected*: data SOURCE; retain COL1-COL4 1; run; data TABLE_REF; retain COL3-COL4 1; CLASS=repeat('a',299); run; proc sql; create table OUT as select case when SOURCE.COL1 is not null then REF.CLASS when SOURCE.COL2 is not null then REF1.CLASS end as CATEGORY length=300 from SOURCE left join TABLE_REF ref on SOURCE.COL3=REF.COL3 left join TABLE_REF ref1 on SOURCE.COL4=REF1.COL4 ; quit; * Almost as expected. SAS Studio displays a non-existent label. 😞         ... View more

@PaigeMiller You can also build in the single quotes that Oracle requires.   proc format; picture dateora low-high ='''%0d-%b-%y''' (datatype=date); run; data TEST; DATE='01JAN2024'd; putlog DATE= dateora. ; run; DATE='01-Jan-24'   ... View more

If you need the ID proc sql; create table DIF as select monotonic() as ID , COLUMN1 , COLUMN2 , COLUMN1-COLUMN2 as DIF from HAVE(keep=COLUMN1) , HAVE(keep=COLUMN2) ; quit; ID column1  column2  DIFF 1 4000 3500 500 2 4000 3300 700 3 4000 3100 900 4 4500 3500 1000 5 4500 3300 1200 6 4500 3100 1400 7 5000 3500 1500 8 5000 3300 1700 9 5000 3100 1900 ... View more

If you want this smooth plot, you need points between the hours. Do you have that detail? How many points?   Mind that the more points, the less volume by point. So if the volume is say 600 in an hour, a per-minute plot will show around 10 on the Y axis. A per-30-minute plot will show around 300 on the Y axis. Etc.   ... View more

My preference is to code date '2017-01-21' to avoid any confusion.   ... View more

I'm pretty sure Oracle understands 4-digit years '01-JAN-2000' . ... View more