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: 
Sathish_jammy
‎07-17-2024
  • 191 Posts
  • 110 Likes Given
  • 3 Solutions
  • 8 Likes Received

Re: Match the corresponding values and concatenate by '/'

by Lapis Lazuli | Level 10 in SAS Programming
‎12-16-2019 05:15 AM
‎12-16-2019 05:15 AM
I appreciate your response @gamotte  It results in C0 for the new value but also at the end of all observation were it not requires. like: abc/def - C1/C2/C0 ghi/mno - C3/C5/C0 Could you please help me to sort out the C0 at the unrequired Observations. Much Thanks! ... View more

Re: Match the corresponding values and concatenate by '/'

by Lapis Lazuli | Level 10 in SAS Programming
‎12-16-2019 04:57 AM
‎12-16-2019 04:57 AM
Thank you so much @ed_sas_member  @gamotte   Both of your code works well.   Additionally, I required one more condition for this task. Assume that I mentioned any new combination of 3alphabets in (have1(varX1)) which not listed in (varX(have)) How could I get the result as 'C0' in varY1. For example : abc/mno/uvx  - C1/C5/C0 ghi/pqr/jkl  - C3/C0/C4   It required because Once I found the C0 so I could add that new value in my list manually like uvx - C6 pqr - C7   ... View more

Match the corresponding values and concatenate by '/'

by Lapis Lazuli | Level 10 in SAS Programming
‎12-16-2019 04:11 AM
‎12-16-2019 04:11 AM
Dear Experts,   I share the sample dataset which matches my requirement for the study. I have two datasets contains 2 columns varX varY.  data have1; input varX$ varY$; cards; abc C1 def C2 ghi C3 jkl C4 mno C5 ; The above code list the alphabets individually refers to C_value. The below code refers to the combination of alphabets, So according to alphabets I need to match the C_values on varY1. data have2; input varX1$; cards; abc/def ghi/mno jkl/def ; Required Output like: abc/def C1/C2 ghi/mno C3/C5 jkl/def C4/C2   Kindly suggest a code to solve the task. Thanks in advance! ... View more

Re: How to take file created date

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-12-2019 05:22 AM
‎12-12-2019 05:22 AM
I agree with your points, Thank you for your valuable comment.  ... View more

Re: How to take file created date

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-12-2019 04:51 AM
‎12-12-2019 04:51 AM
data have; input filename$1024.; cards; D:\testing.xlsx ; data want; set have; rcs = filename("fileref", filename); fid=fopen('fileref'); Bytes=finfo(fid,'File Size (bytes)'); crdate=finfo(fid,'Create Time'); moddate=finfo(fid,'Last Modified'); run; proc print; run; ... View more

Re: creating summary table in SAS

by Lapis Lazuli | Level 10 in New SAS User
‎12-10-2019 03:13 AM
‎12-10-2019 03:13 AM
Proc Tabulate will help you to summary the % values   proc tabulate data = have; class month points; table month all, points*(n*f=8. colpctn='%') all='Total'*(n*f=8.)/rts=10; run; ... View more

defining pvalue in ttest

by Lapis Lazuli | Level 10 in SAS Procedures
‎11-30-2019 04:11 AM
‎11-30-2019 04:11 AM
Dear Experts,    I have a dataset containing 2 columns - Weight, Follow_weight I need to find the pval value using ttest for those variables. Weight column contains 120 values in each row, F_wt column contains only 78 rows Just for a sample, I share the data (have) here. data have; input Wt F_wt; cards; 56.8 59.2 75.2 71.3 88.0 85.1 76.5 76.2 101 26.5 Does the below method will return correct pval?   ods select none; ods output ttests=ttest statistics=tstats; proc ttest data=have; paired wt*f_wt; run; Don't use the above dataset for analysis, It's just for a visual.     ... View more

Re: Remove all Text before Comma

by Lapis Lazuli | Level 10 in SAS Programming
‎11-11-2019 07:00 AM
‎11-11-2019 07:00 AM
data want; set have; want=scan(Comment_variable,-1,','); run; ... View more

Re: Change all the date variable in MMDDYY10. format

by Lapis Lazuli | Level 10 in SAS Programming
‎11-11-2019 06:56 AM
‎11-11-2019 06:56 AM
For five variables the suffix is like _date, the remaining date variable suffix is like _DT. It'll be fine enough for me to convert only  (suffix)_DT variables. ... View more

Change all the date variable in MMDDYY10. format

by Lapis Lazuli | Level 10 in SAS Programming
‎11-11-2019 06:45 AM
‎11-11-2019 06:45 AM
Dear Experts,   I import the data into SAS from SQL Server (then analyzed) and Exported the dataset to Excel. The date variable in the format of DATETIME22.3. (10NOV1947:00:00:000) I know the way to convert for one/two variables. but my dataset has 50 more date variables. I want to format all variables in MMDDYY10. at one shot.  Kindly suggest code to solve the date format.   Thanks in advance!     ... View more

Automatic update on table_2 from table_1

by Lapis Lazuli | Level 10 in SAS Programming
‎10-29-2019 01:27 AM
‎10-29-2019 01:27 AM
Dear Experts,   I attend a telephonic interview with CSS Corp. They ask me technical questions from MS-SQL Server. I need to know whether the method is possible in SAS. The question is: Assume you have 2 tables which have the same rows and columns.  If I modify the existing value / Add the new row in Table_1, how the table_2 automatically update the new value?.   Is there any possible methods to do automatic updates. Please share your ideas. Thanks in advance!   ... View more

Re: Display the missing CLASS in Proc Tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎09-10-2019 02:39 AM
‎09-10-2019 02:39 AM
@andreas_lds  Tried, But that doesn't work ... View more

Display the missing CLASS in Proc Tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎09-10-2019 12:39 AM
‎09-10-2019 12:39 AM
Dear Experts,   I have a table to evaluate the Sum/Count using Proc Tabulate procedure. If the class value has (0/Null/Missing) value it omits that entire class row in the table. but I need to specify the null value too. I'll share the code and Image for a better understanding.   proc tabulate data = Sv.SRK; title '17) Monthly Income of Respondent'; class Monthly_Inc15 Qut2_Sex; tables Monthly_Inc15 all, (Qut2_Sex *(n*f=8. colpctn='%')) all='Total'*(n*f=8. reppctn='%')/rts=10; run; In the given table 80,001 - 1,00,000 1,00,001 - 1,25,000 1,25,001 - 1,50,000 1,50,001 - 1,75,000 till 2,75,000 class value is missed.   I want to display the gender values like 0 for the missed Monthly_Inc value. Kindly suggest some ideas to solve the task. Thanks in advance!   ... View more

delete the rows for group condition

by Lapis Lazuli | Level 10 in SAS Programming
‎09-04-2019 08:52 AM
‎09-04-2019 08:52 AM
Dear Experts,    I want to delete the rows using a condition given below. Kindly go through my sample dataset for better details.   data have; input Id Events value; cards; 101 0 12 101 0 15 101 1 14 101 0 18 108 0 45 108 1 25 108 0 23 ; In the given set. I want to delete the row which occurs after the event meets 1. Rows need to delete :  101 0 18 108 0 23 Kindly suggest some code to solve the task  Thank you!   ... View more

Update the value in cross format

by Lapis Lazuli | Level 10 in SAS Programming
‎09-04-2019 06:57 AM
‎09-04-2019 06:57 AM
Dear Experts,   I'm trying to update the column which already existing in another column using cross level. In more detail. I share the sample dataset and my required output below.   data aaa; input ID val1; cards; 10 0 10 12 10 15 10 14 15 0 15 24 15 26 ; I expect my result as ID Val1 Val2 10 0 0 10 12 0 10 15 12 10 14 15 15 0 0 15 24 0 15 26 24   Please let me know if clarification required. Kindly suggest some ideas to resolve the task. Thanks in advance!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-17-2024 12:27 PM
Likes given to
Likes from
Quick links