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: 
krishnaalla
‎09-26-2019
  • 10 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: i need to compare all variables between two tables

by Fluorite | Level 6 in New SAS User
‎09-26-2019 04:02 PM
‎09-26-2019 04:02 PM
i am able to compare have1 dataset 1st column with have2 dataset with 1st column.. like same its comparing 2nd to 2nd.   but i need to see between 1st dataset column with all in 2nd dataset.     ... View more

Re: i need to compare all variables between two tables

by Fluorite | Level 6 in New SAS User
‎09-26-2019 03:59 PM
‎09-26-2019 03:59 PM
  data have1;   informat x1-x5 $8.;   input R x1-x5;   cards; 1 12 A B 14 12 2 C X 12 X 5 3 1 1 1 1 1 4 a b c d e 5 a a a a a ; run; data have2;   informat v1-v5 $8.;   input R v1-v5;   cards; 1 12 d B 14 12 2 C X 12 X 5 3 1 1 1 1 1 4 a c c d e 5 a a b a a ; run; proc sort data=have1; by R;run; proc sort data=have2; by R;run; data want(drop=count i); merge have1 have2; array _v{*} v:; array _v{*} v:; array st{100} $25. ; do i=1 to dim(_v); do j=1 to dim(_X);   if _X{j}=_v{i} then st{i}="Match";else St{i}="Non Match"; end; end; run;   ... View more

Re: i need to compare all variables between two tables

by Fluorite | Level 6 in New SAS User
‎09-26-2019 03:48 PM
‎09-26-2019 03:48 PM
compare every variable in one data set  with available variables in other data set. ... View more

Re: i need to compare all variables between two tables

by Fluorite | Level 6 in New SAS User
‎09-26-2019 03:35 PM
‎09-26-2019 03:35 PM
I need to see the match data all variable in one table with available variables in another table ... View more

i need to compare all variables between two tables

by Fluorite | Level 6 in New SAS User
‎09-26-2019 03:14 PM
‎09-26-2019 03:14 PM
data a; input id a b c; cards; 1 1.1 1.2 1.3 2 2.1 2.2 2.3 3 3.1 3.2 3.3 ; run;   data b; input idx abc bcd cde def efg fgh; cards; 1 1.1 1.2 1.3 1.4 1.5 1.6 2 2.1 2.2 2.3 2.4 2.5 2.6 3 3.1 3.2 3.3 2.4 2.5 2.6 ; run;   for example: a compare with abc a compare with bcd a compare with cde   how can i compare see the matching and nonmatching data.  ... View more

Re: How to group the data for similar values in a reverse order ?

by Fluorite | Level 6 in New SAS User
‎01-21-2019 10:50 PM
‎01-21-2019 10:50 PM
i want to group the values : example:  AUS Vs IND  having 10 values IND Vs AUS  having 15 values     treat as a similar value and group it as one value.    in need IND Vs AUS count as 25 values ... View more

How to group the data for similar values in a reverse order ?

by Fluorite | Level 6 in New SAS User
‎01-21-2019 10:41 PM
‎01-21-2019 10:41 PM
   I want to group "AUS Vs WI" & "WI Vs AUS"  data test; infile datalines; input Match $12.; datalines; AUS Vs WI IND Vs SRI AUS Vs WI WI Vs AUS IND Vs AUS AUS Vs IND SRI Vs IND NZ Vs SA SA Vs NZ ; run; proc print data=test; run;   ... View more

Re: How to insert sheets into existing workbook in sas

by Fluorite | Level 6 in Graphics Programming
‎05-23-2017 05:46 AM
‎05-23-2017 05:46 AM
Thank you for suggesting,   But i am using 'MSOFFICE2K_X' tagsets its not 'MSOFFICE2K' ..   MSOFFICE2K_X will create .xml and html both, MSOFFICE2K will create html only.   currently my problem with Msoffice2k_x not able to create a mutiple sheets, but previously the sheet generated by using msoffice2k_x. according to modifications i need mutiplesheets from two report procedures one report procedure will generate one main sheet and other contains mutiple sheets.   so, the main sheet i geneerated by using msoffice2k_x and the other i generated by excelxp tagsets both are xls only.   Now, i want to insert those sheets in one excel workbook. by using DDE.     I dont know how to use DDE. ... View more

Re: How to insert sheets into existing workbook in sas

by Fluorite | Level 6 in Graphics Programming
‎05-23-2017 04:57 AM
‎05-23-2017 04:57 AM
i understand what you said but i use 'MSOFFICE2K_X' tagsets which generate .xls with a html features( in my words fronts and colours etc.), but excelxp doesn't support a html features.   i have a problem that the previous reports were msoffice2k_x, so i need to generate a report in the by using msoffice2k_x tagsets ods.   but the new problem according to the msoffice2k_x it doesnt support to generate a multiple sheets, so the main sheet i generated msoffice2k_x tagsets, and the remaining sheets i use excelxp tagsets.   the main sheet i need a same like before (msoffice2k_x) designed, so generated individally, iam not able to understand the exact syntax for DDE.   any example can you suggest. ... View more

How to insert sheets into existing workbook in sas

by Fluorite | Level 6 in Graphics Programming
‎05-23-2017 01:46 AM
‎05-23-2017 01:46 AM
i have two excel .xls files, i need to insert sheets in to existing excel workbook, how can i do this by using DDE in sas.   suggest me any example...     1. one excel workbook generated using msoffice2k_x & other excelxp tagsets. 2. i face a problem that msoffice2k_x tagsets not able to create mutiple sheets, i need msoffice2k_x syle only. 3. so, one main workbook '.xls'  generated by using msoffice2k_x tagsets & other workbook i use excelxp tagsets. 4. now my problem is i need to insert one workbook in to other. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-26-2019 07:23 PM
Likes given to
View All
Quick links