Recently in the SAS Community Library: SAS' @Sundaresh1 highlights a sometimes overlooked task when applying document embeddings for purposes of similarity-based search. Normalisation of vectors helps obtain relevant matches.
Hi, I just had a request a Waterfall plot from my internal client that he wants to use solid colors for the first five groups but 2 groups with color and pattern. I tried to use Discrete Attribute Map data but I don't think fillpattern variable is available although I am not getting any SAS error message. If fillpattern works in the data, that will be great. Then, I tried styleattrs statement with datafillpatterns option. The main problem is that there is no option "not to put any pattern". For the good old SAS/Graph, pattern statement had two options as 'E' and 'S' but the 15 values for datafillpatterns do not include any null value. I tried datafillpatterns=(' ' ' ' ' ' X1 X1 R1 L1) but I got syntax error. Is there any way to indicate "blank" value to datafillpatterns option? I know one more method would be proc template but I haven't tried yet. Any idea? Thank you in advance. Raymond
... View more
Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value.
... View more
Can someone please explain difference between bquote and str in sas with a working example.I am aware of theoretical difference between them.
But ,I want to understand with example which shows why str can't be used in place of bquote
... View more
I have a data file describing users (ID), time periode a service is in use (FromYrMon-ToYrMon) and hours of services (hours). There are two problems. First, the time periods partly overlap. There are also some gaps between the time periods but that is probably correct. Second, the hours of services are not consistently coded in the sense that the same time period (or parts of it) may have differences in hours. The file I want, includes for each ID, one observation per month, the maximum of hours for that month and 0 for months where there are gaps between time periods. I guess the solution will be something like 1) transposing, 2) fill in gaps and 3) pick the highest number of hours for each month.
data have;
input ID FromYrMon YYMMN6 ToYrMon YYMMN6. Hours comma4.2;
datalines;
1 201701 201711 0.75
1 201704 201711 1.20 1 201801 201802 4.00 2 201710 201802 2.00 ; Data want; ID YYMon Hours 1 201701 0.75 1 201702 0.75 1 201703 0.75 1 201704 1.20 1 201705 1.20 1 201706 1.20 1 201707 1.20 1 201708 1.20 1 201709 1.20 1 201710 1.20 1 201711 1.20 1 201712 0.00 (NB) 1 201801 4.00 1 201802 4.00 2 201701 0.00 2 201702 0.00 2 201703 0.00 2 201704 0.00 2 201705 0.00 2 201706 0.00 2 201707 0.00 2 201708 0.00 2 201709 0.00 2 201710 2.00 2 201711 2.00 2 201712 2.00 2 201801 2.00 2 201802 2.00
... View more
Feedback option in proc sql statement we use to display columns in logs. so what is use of it?There is any benefit to see columns in log files.
... View more