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: 
Karem
‎07-15-2022
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to remove Apostrophe ( ' ) in each observation during PROC IMP...

by Calcite | Level 5 in SAS Procedures
‎07-12-2017 04:57 AM
‎07-12-2017 04:57 AM
    Thank you! @KurtBremser / @RW9.   Converting to csv is simpler considering if there will be a numerous header.       best regards,   Geof ... View more

How to remove Apostrophe ( ' ) in each observation during PROC IMPORT ...

by Calcite | Level 5 in SAS Procedures
‎07-11-2017 04:45 AM
‎07-11-2017 04:45 AM
Hi.   I'm having  trouble in importing XLS file to SAS data set. Proc Import works, but the SAS data set produces all observation as CHAR.   I checked the XLS file (which is software generated file), and i have found that all observation has an APOSTROPHE ( ' ), whether it is CHAR or NUM header. While (1st Row) Header do not have this apostrophe ( ' ).   How can i removed this apostrophe ( ' ), so that SAS can translate correct observation type in all header ?   Note: Find/Replace in Excel can't find apostrophe ( ' )   XLS Numeric Header: With ( ' )   XLS Char Header: With ( ' )   XLS (First Row) Header: Without ( ' )     CODE: proc import out= name datafile= "&fpath" dbms=xls replace; getnames=yes; datarow=2; mixed=no; run;     thanks!   Karem ... View more

Re: SAS: How to plot Multiple X group (3 or more) using Stacked Bar

by Calcite | Level 5 in Graphics Programming
‎07-04-2017 04:40 AM
‎07-04-2017 04:40 AM
Hi Damo,   Thank you for the reference. I haven't use the annotate.   When i posted my question i have seen the sample 45124. That sample has 2 groups in X-axis.   And i can't find a solution to make it 3 groups or more. Could you help me on this portion?     I tried to familiarize myself on annotate, but i only found that the annotate facility, replace the 1st X-group and hide the orig 1st X-group (generated by vbar).   however, i don't have an idea on how to make 2 x-group from annotate and 1x group from VBAR (group function).   Using same data set from sample 45124, this x axis i would like to script. Is this possible in SAS ?   (from JMP)   best regards,   Karem     ... View more

SAS: How to plot Multiple X group (3 or more) using Stacked Bar

by Calcite | Level 5 in Graphics Programming
‎05-15-2017 11:21 PM
‎05-15-2017 11:21 PM
Hi Guys,   Can SAS create multiple X group (3 or more) in a plot ? See image below.     This grouping can be done in JMP's Graph Builder, i hope i can code the same in SAS (9.4m3 - windows7)   And i hope to futher improve the plot by adding Line on Right Axis (if possible).       thanks in advance!   ... View more

SAS: How to Look into folder/subfolder. Open and concatenate data file...

by Calcite | Level 5 in SAS Programming
‎05-15-2017 10:44 PM
‎05-15-2017 10:44 PM
Hi Guys,   Kind a new in dealing with files and folders in SAS. I'm hoping someone can help me.     Procedure:   1. Go to MainFolder 2. Look for subfolder (1st row: Sub1) declared into the Input_Table 3. Open EACH subfolder from Sub1_? to Sub1_1_? 4. Open *.xls file. see *.xls sample.     Locate cell C2     IF value of C2 is equal to dataID (1st row: abc123 of Input_Table) 5. THEN OPEN measure.csv. see measure.csv sample 6. repeat 2-5 (next row of Input_table) 7. concatenate measure.csv, see output table.           Im using SAS9.4m3 / Windows 7. I hope i illustrate my query properly. Let me know if you have questions.   Appreciate if you can explain the codes as well.   thank you very much! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-15-2022 03:56 AM
Likes given to
View All
Quick links