About deega

deega · ‎01-24-2017

@Rick_SAS Thanks for the reply. I have not used arrays much and trying to understand your program. Could you please tell what is _N_ here ???

deega · ‎01-24-2017

@stat_sas by particular record, i mean for each record, something like below Record No. Nearest Record 1 Nearest Record 2 Nearest Record 3 1 5 6 7 2 1 2 3 3 2 1 6 4 5 1 6 5 : : : 6 : : : 7 : : : 8 : : : 9 : : : 10 : : : : :

deega · ‎01-24-2017

@Reeza This is what my question is... Few days back I used SPSS Modeler, using its KNN Node, we can quickly find the nearest record ...

deega · ‎01-23-2017

Hi All, I have a dataset with around 100000 records. I want to know only those three records that have shortest distance with a particular record. If I run the distance procedure then the program generates the output of matrix of 100000 variables giving distance of a variable with all other variables. It is actually not required and unecessarily it eats up my system time and sometimes evenhangs my system. If there is any other procedure that gives me the variables with just the shortest distance, please share. Thanks in advance.....

deega · ‎12-15-2016

Thanks... I saw this document but was little confused... It solved my problem

deega · ‎12-15-2016

Hi All, I am running the following code: proc freq data = filename; table A*B/ nocum nocol norow out = datasetA;; weight C; run; Now the value in column C is too big and the summation is making it much bigger , around 12 digit number so in the output I am getting the values like 2.239E9. Is there a way to format two way table ?

deega · ‎12-07-2016

Is there a way to tell the system which variable to read as character & which one as numeric/date. I have one numeric column with 13 digits, if I mention getnames=yes in proc import then it makes that column as numeric but values are junk. If I mention getnames=no in proc then it makes that as text. Ideally I want it numeric with 13 digits but if that is not possible then I want it as text but with getnames.... Please send your expert advice........

deega · ‎11-30-2016

Hi I am using below codes to make a histogram proc univariate data=filename noprint; histogram VAR1 ; run; I am getting histogram in the output but with Percentage and I want with Frequency count. Could anybody please help me on the same.

deega · ‎11-21-2016

Thanks.... The input was not in my hand.. it is CSV file, i received...

deega · ‎11-21-2016

Hello Everyone, I am trying to find the difference in two dates in number of days. I have dates in numeric format as follows: 20150218 20150216 20150219 20150220 20150315 20150317 20150319 20150320 20150321 20150322 Now I want the difference of theses dates from 20161001 in number of days. Thanks in advance !

deega · ‎11-11-2016

Thanks Everbody. I have found the solution in proc sql. Left join is giving me desired output.

deega · ‎11-11-2016

My main Dataset is Dataset-2 and I want to add detail information of corresponding ID. The detail information of Id is in form of P1 P2... etc in Dataset1 and that is why I am merging by ID.

deega · ‎11-11-2016

Yes, Dataset2 has duplicates. In my output instead of 10 records, I am getting far more than 10.

deega · ‎11-11-2016

Hi All, I would like two combine the following two datasets. Dataset-1 ID P1 P2 P3 P4 1 A B C D 2 B A C 3 A C B D 4 D C A B 5 C A B 6 C A B D 7 A B C 8 A C B 9 A C 10 B C D A Dataset-2 Main_Id ID 1 2 2 3 3 2 4 2 5 2 6 5 7 5 8 9 9 9 10 9 I expect the following Dataset Main_Id ID P1 P2 P3 P4 1 2 B A C 2 3 A C B D 3 2 B A C 4 2 B A C 5 2 B A C 6 5 C A B 7 5 C A B 8 9 A C 9 9 A C 10 9 A C I wrote following program proc sort dataset1; by id; run; proc sort dataset2; by id; run; data final ; merge dataset1 dataset2; by id; run; but I am getting multiple records in the result. Please advice. Thanks in advance !

deega · ‎11-07-2016

Wow ! Yes, its working .....

Online Status	Offline
Date Last Visited	‎03-27-2017 01:15 AM

String query in Arrays

Re: transpose multiple columns and getting output in columns

transpose multiple columns and getting output in columns

delete row and sum the value of one of its column

Re: checking values within row

checking values within row

Removing duplicate values

Re: transpose in particular format

transpose in particular format

Re: shortest distance

Re: transpose multiple columns and getting output in columns

Re: transpose in particular format

Re: Multiple Queries

Re: shortest distance

Re: format in proc frequency

Re: format in proc frequency

Re: Import dates variable from CSV

Re: shortest distance

Re: shortest distance

Re: shortest distance

shortest distance

Re: format in proc frequency

format in proc frequency

proc import csv

Histogram with frequency count

Re: date difference from particular date and output in number of days

date difference from particular date and output in number of days

Re: Merge/ Combine

Re: Merge/ Combine

Re: Merge/ Combine

Merge/ Combine

Re: Distinct values in sub Group