cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QLi
‎09-10-2020
  • 64 Posts
  • 4 Likes Given
  • 0 Solutions
  • 17 Likes Received

Re: joining on a computed column in eg

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-26-2012 10:06 AM
3 Likes
‎06-26-2012 10:06 AM
3 Likes
It isn't possible to put computed column into "ON" when joinning talbe. The simple way is just to add a piece of code before joinning tables, such as: proc sql; create view table1_1 as select table1.*, year(calldate)as year from table1;quit; ... View more

Re: condiotional highlighting for non numeric fields

by Fluorite | Level 6 in SAS Web Report Studio
‎06-26-2012 09:49 AM
‎06-26-2012 09:49 AM
Could you please put some simple code ? It will be easy to find solution by others ... View more

Re: error in proc format

by Fluorite | Level 6 in SAS Procedures
‎06-26-2012 09:46 AM
‎06-26-2012 09:46 AM
Try use opition "multilabel"  in the Value statement. for example proc format; value $gender  (multilabel) '1'='Male' '2'='Female' '1','2',' '='Total people'; ... View more

Re: SAS GChart display issue

by Fluorite | Level 6 in SAS Programming
‎06-25-2012 04:31 PM
1 Like
‎06-25-2012 04:31 PM
1 Like
to put  "Discrete" Option in the statement of VBAR3D,  try it PROC GCHART DATA=have;   VBAR3D   DAY_DATE / discrete SUMVAR=VOLUME  SHAPE=Cylinder FRAME TYPE=SUM SUM   LEGEND=LEGEND1   COUTLINE=BLACK   RAXIS=AXIS1   MAXIS=AXIS2 PATTERNID=MIDPOINT   LREF=1   CREF=BLACK   AUTOREF   space=0 ; RUN; QUIT; ... View more

Re: How to add column average on the end of table (proc tabulate)?

by Fluorite | Level 6 in SAS Procedures
‎06-25-2012 04:00 PM
3 Likes
‎06-25-2012 04:00 PM
3 Likes
3. Is it possible to change background of cell if target > N? Make a little bit change based on the code of PG: /* Change Target Type from Char to Num*/ proc sql; create view processN as select process, id, input(target,2.)as target_n, day, count(*) as nb from process group by 1, 2, 3, 4; quit; /* Color Format*/ proc format ; value  col low -5 ='yellow'             6-high='red'; run; proc tabulate data=processN format=4.0;      class process id target_n day;   classlev target_n /s=[background=col.];      var nb;      table process = '' * id = ''* target_n = '' ,      (day = 'N' all='Mean N')*nb=""*mean=""      / misstext='0'; run; ... View more

Re: How to append multiple columns into a column (with many rows) ?

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-19-2012 11:21 AM
‎06-19-2012 11:21 AM
Try to use proc transpose and maybe work it out. data have; input Name $ Sex $ Age height weight; cards; alfred m 14 69 112.5 alice f 13 56.5 84 barbara f 13 65.3 98 ; run; proc sort data=have out=have2; by name; run; proc transpose data=have2 out=have_t; by name; var height weight age ; run; ... View more

Re: date format in sql where statement issue

by Fluorite | Level 6 in SAS Procedures
‎06-14-2012 11:05 AM
‎06-14-2012 11:05 AM
Check the informat  of FST_SRVC_DT and try  this condition. WHERE   year (A.FST_SRVC_DT BETWEEN)=2010 ... View more

Re: Working with Delimit in SAS EG

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-14-2012 10:54 AM
4 Likes
‎06-14-2012 10:54 AM
4 Likes
If you use Enterprise Guide, you can follow these steps. From" File" in the tool Bar , select "Import Data",  Click "Text Format "  , select "Delimited" in the format and select "Space" in the  Delimiter Click Run. Try it and good luck ... View more

Re: extract a substring from a string

by Fluorite | Level 6 in SAS Programming
‎06-14-2012 09:06 AM
‎06-14-2012 09:06 AM
It works great. Thanks, All ... View more

extract a substring from a string

by Fluorite | Level 6 in SAS Programming
‎06-13-2012 04:26 PM
‎06-13-2012 04:26 PM
All; I have data as the following. data  have; input string $40.; datalines; c 10 year fixed n 30 year fixed n 15 year fixed sh nchfa fha 30 year c 30 year fixed homepath c 7 yr arm homepath ; run; I want to substring from a string to get the column like: 10 year 30 year 15 year 30 year 7 yr Thanks ... View more

bufsize=

by Fluorite | Level 6 in SAS Programming
‎01-12-2012 01:37 PM
‎01-12-2012 01:37 PM
Hi, all, Is it possible to define buffer size  in the libname statement?   or how can pre define  buffsize = for the whole librabry? Thanks. ... View more

To Alter a column definition

by Fluorite | Level 6 in SAS Procedures
‎01-05-2012 12:49 PM
‎01-05-2012 12:49 PM
Proc Datasets is hard to change column's length. But you can try data step by length statement; Data want; length var1 $ 40; set have; run; ... View more

proc sql: can I make it for short?

by Fluorite | Level 6 in SAS Procedures
‎11-17-2011 09:50 AM
‎11-17-2011 09:50 AM
Maybe you can merge Proc Sql  into one or two,  proc sql;     create table finrep as     select    A.*, (A.Assets+B.Assets)/2 as Assets_avg,C.IND,d.IPO_date,e.*, f.*     from    fin_info as A INNER JOIN fin_info_s as B,     ON    A.stkcd=B.stkcd and A.year=B.year LEFT JOIN industry as C ON A.stkcd=C.stkcd LEFT JOIN IPO AS d ON A.stkcd=d.stkcd LEFT JOIN control AS e ON A.stkcd=e.stkcd AND A.year=e.year LEFT JOIN str_dummy(drop=STR07 STR08) as f ON A.stkcd=f.stkcd; quit; ... View more

Collapsing data

by Fluorite | Level 6 in SAS Programming
‎10-25-2011 03:51 PM
‎10-25-2011 03:51 PM
I have a data set need to collaspse. Then current data looks  the following: ID     Type     Code     Amt 234      RC1       A        102 234     RC1        C        101 234      RC1      B         104 238    RC1       A         125 238    RC1       B         126 238    RC2       C         127 Want data looks the following: ID     Type     Code1(amt Max)   Amt1      Code2    Amt2     Code3(amt min)    Amt3(amt min) 234    RC1          B                       104          A          102          C                           101 238     RC1        B                        126         A           125                                       . 238     RC2        C                        127                       .                                          . Do you have any idea to do it? Thanks ... View more

User defined formats can not be preloaded

by Fluorite | Level 6 in SAS Procedures
‎09-15-2011 09:50 AM
‎09-15-2011 09:50 AM
To get the order  in the report table, I defined the format with option NOTSORTED. proc format library=fmt.catalog fmtlib ; value $Cov_fmt (notsorted) '$0'='$0' '$50'= '$50' '$75'='$75' '$100'= '$100' '$200'= '$200' '$250' ='$250' '$500' ='$500' '$1,000' ='$1,000' '$30/day ($900 max)'='$30/day ($900 max)' '$40/day ($1,200 max)'='$40/day ($1,200 max)' '$50/day ($1,500 max)'='$50/day ($1,500 max)' '$900 max'='$900 max' '$1,500 max'='$1,500 max' '$2,000' ='$2,000' '$2,500' ='$2,500' '$5,000'='$5,000' '$10,000'= '$10,000' '$12,000' ='$12,000' '$20,000' ='$20,000' '$25,000'= '$25,000' '$30,000' ='$30,000' '$40,000' ='$40,000' '$50,000' ='$50,000' '$60,000' ='$60,000' '$75,000' ='$75,000' '$100,000' ='$100,000' '$250,000' ='$250,000' '$300,000' ='$300,000' '$100/week'='$100/week' '$10,000 | $0 Deductible'='$10,000 | $0 Deductible' '$10,000 | $250 Deductible'='$10,000 | $250 Deductible' '$10,000 | $500 Deductible'='$10,000 | $500 Deductible' '$10,000 | $1,000 Deductible'='$10,000 | $1,000 Deductible' '$50,000/$100,000'='$50,000/$100,000' '$100,000/$300,000'='$100,000/$300,000' '$250,000/$500,000'='$250,000/$500,000' '$300,000/$300,000'='$300,000/$300,000' '$500,000/$500,000'='$500,000/$500,000' '100% Medical Coverage Only'='100% Medical Coverage Only' '100% Medical Coverage | 80% Income Replacement'='100% Medical Coverage | 80% Income Replacement' '80% Medical Coverage Only'='80% Medical Coverage Only' '80% Medical Coverage | 60% Income Replacement'='80% Medical Coverage | 60% Income Replacement' 'Added On#$50,000/$100,000'='Added On#$50,000/$100,000' 'Added On#$100,000/$300,000'='Added On#$100,000/$300,000' 'Added On#$250,000/$500,000'='Added On#$250,000/$500,000' 'Added On#$300,000/$300,000'='Added On#$300,000/$300,000' 'Added On#$500,000/$500,000'='Added On#$500,000/$500,000' 'Added On#$25,000'='Added On#$25,000' 'Added On#$50,000'='Added On#$50,000' 'Added On#$100,000'='Added On#$100,000' 'Added On#$200,000'='Added On#$200,000' 'Added On#Decline'='Added On#Decline' 'Decline'='Decline' 'No'='No' 'Yes'='Yes' 'Nonstacked'='Nonstacked' 'Stacked'='Stacked' 'Reduced By#$50,000/$100,000'='Reduced By#$50,000/$100,000' 'Reduced By#$100,000/$300,000'='Reduced By#$100,000/$300,000' 'Reduced By#$250,000/$500,000'='Reduced By#$250,000/$500,000' 'Reduced By#$25,000'='Reduced By#$25,000' 'Reduced By#$50,000'='Reduced By#$50,000' 'Reduced By#$100,000'='Reduced By#$100,000' 'Reduced By#Decline'='Reduced By#Decline' ; run; When I used it in the Proc Tabulate, it showed Warning" Cann't Preloaded "         proc tabulate data = Reqtd_Cov order = data   ;             class requested_limit /preloadfmt;             class coverage_code state ;              format requested_limit $Cov_fmt.;                  table (coverage_code='' )* (requested_limit=''  ) all, state=''*n=''*f=comma6.0 ;* all*f=comma6.0;                  run ; Could you help me check it whether or not I missed something? Thanks in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-10-2020 09:36 AM
Likes given to
View All
Likes from
View All
Quick links