About atul_desh

atul_desh · ‎06-19-2017

If I want duplicate based on var1-var4, then var5 is coming from second dataset only.. is there any way to get correct value : output is coming like(var5 is coming from ds2 in both the dataset,which should 6 in first observation) : SAS Output Obs var1 var2 var3 var4 var5 DS_NAME 1 2 1 2 3 4 7 ds1 1 2 3 4 7 ds2 data ds1; input var1 var2 var3 var4 var5; datalines; 1 2 3 4 6 6 7 8 9 10 ; data ds2; input var1 var2 var3 var4 var5; datalines; 11 12 13 14 15 1 2 3 4 7 ; proc sort data = ds1; by var1-var4; run; proc sort data = ds2; by var1-var4; run; %let d1 = ds1; %let d2 = ds2; data want; merge &d1(in=in1) &d2(in=in2); by var1-var4; if in1 & in2 then do; DS_NAME = "&d1"; output; DS_NAME = "&d2"; output; end; run; proc print data=want; run;

atul_desh · ‎06-13-2017

I want to show duplicate records with their source_name

atul_desh · ‎06-13-2017

Hello, data ds1; input var1 var2 var3 var4 var5; datalines; 1 2 3 4 5 6 7 8 9 10 ; run; data ds2; input var1 var2 var3 var4 var5; datalines; 11 12 13 14 15 1 2 3 4 5 ; run; data want [[common observation from ds1 & ds2, with their source table] ] should be look like : var1 var2 var3 var4 var5 DS_Name 1 2 3 4 5 ds1 1 2 3 4 5 ds2 Thanks in advance.

atul_desh · ‎06-12-2017

Is there is any other, I tried this one before but it is not removing all the observation from A, which are present in B (on basis of both variable st_code & ID). I think its due to I've multiple observation of st_code & multiple IDs

atul_desh · ‎06-12-2017

Hi, I want to remove observation from A which are present in B; data a; input st_code Addr$ Name$ ID; datalines; 06111 kota atul 552927 08888 delh gaur 552927 13089 pune pink 666666 ; run; data b; input st_code ID; datalines; 06111 552927 13089 552927 13135 552927 ; run;

atul_desh · ‎06-09-2017

This is how I'm doing it now.. now it is less time consuming and giving what I wanted : proc sort data=A; by Var1 Var2 Var3; run; proc sort data=B; by Var1 Var2 Var3; run; data pre_want; merge A (in=a) B (in=b); byVar1 Var2 Var3; if not a and b; run; proc append base=A data=pre_want; run;

atul_desh · ‎06-08-2017

how can use only_in_b for append b to a ??

atul_desh · ‎06-08-2017

what if I append all the observation and in last I do nodupkey ?

atul_desh · ‎06-08-2017

Hello, I've two datasets, Lets say A and B, there are 215 Variables in each of the dataset and datasize is 90 G. I want to append B dataset into A but not to append the duplicate values which are common based on "Three Variables, not based on all 215 variable". I can't use (syncadd=no uniquesave=yes) and also can't use below code, as it will check all variables for duplicity. proc sql feedback; create table lib_w.want select * from lib_A.dsA union corresponding select * from lib_B.dsB ; quit; I'm thininking to creat new varialbe as catx(all three variable) in both A and B and then "A.catx_var ne B.Catx_Var" is there is other way around ? Please help, Thanks in Advance.

atul_desh · ‎06-08-2017

Hey KSharp, when I'm running this query its checking for all variables for duplicity. I need to check based on only 3 Variables. Is there any other way around. Thanks

atul_desh · ‎05-30-2017

$file1 = Get-Content L:\servers.txt $file2 = Get-Content L:\HofixID.txt $objects = foreach($f1 in $file1) { foreach($f2 in $file2) { New-Object psobject -Property @{ Server = $f1 HotfixID = $f2 } } } $objects |Export-Csv -Path "L:\output.csv" -NoTypeInformation $CSV = import-csv “L:\output.csv” | select Server,HotfixID,@{n=’CommanName’;e={$_.Server + ” ” + $_.HotfixID}} $CSV |Export-Csv "L:\outputfinal.csv" -NoTypeInformation $PCSV =import-csv “L:\patch_ouput.csv” | select Server,HotfixID,@{n=’CommanName’;e={$_.Server + ” ” + $_.HotfixID}} $PCSV |Export-Csv "L:\patch_outputfinal.csv" -NoTypeInformation

atul_desh · ‎05-25-2017

It is working fine, what error you're getting ? %let name =chk; libname TD5 "L:\user\desktop"; PROC IMPORT OUT= &name DATAFILE= "L:\user\desktop\book1.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; run; PROC IMPORT OUT= TD5.&name DATAFILE= "L:\user\desktop\book1.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; run;

atul_desh · ‎05-24-2017

Its done now.. thanks.. I created temperory dataset from all files and then set in the final dataset (keeping only variable what i want). %let i=1; %do %while (%scan(&fn,&i,' ') ne ); proc import datafile="&D_IN_reason/%scan(&fn,&i,' ')" out=work.chk_&i dbms=dlm replace; delimiter='09'x; getnames=yes; guessingrows=max; run; %put %scan(&fn,&i,' '); %let i=%eval(&i+1); %end; run; %mend cr_agg_list; %cr_agg_list; options symbolgen mlogic mprint; data fnl_chk; attrib filename format=$200.; set chk_1-chk_&n_obs (keep=Filename TotalRecords); run;

atul_desh · ‎05-15-2017

Problem is, 1st file is having 12 variable (Var1[Name] to Var12 [Country]) and let say 6th file is having 4 Variable (Var1[Name] to Var4[Country]). when I'm reading all data Var12[Country] is coming blank for 6th File.

atul_desh · ‎05-15-2017

it is not working.. data want (keep=FileName TotalRecords); infile "Path" dsd dlm='09'x; input FileName : $50. TotalRecords : $50. ; run; It is taking variable names according to occurence in the file.

Online Status	Offline
Date Last Visited	‎03-28-2022 11:30 PM

Re: array break until multiple condition met

Re: array break until multiple condition met

Re: array break until multiple condition met

array break until multiple condition met

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Not getting mail from sas Job when running on Unix SAS Grid

Re: array break until multiple condition met

Re: proc sql problem adding new variable

Re: proc sql problem adding new variable

Re: Set All Datasets present in library into one dataset

Re: Set All Datasets present in library into one dataset

Not getting mail from sas Job when running on Unix SAS Grid

Re: Catx or trim? Help with Problem

Re: selecting common observation based on all variable names with sour...

Re: selecting common observation based on all variable names with sour...

selecting common observation based on all variable names with source d...

Re: Removing observations based on two variable after matching with ot...

Removing observations based on two variable after matching with other ...

Re: Appending Non-Duplicate based on three variables

Re: Appending Non-Duplicate based on three variables

Re: Appending Non-Duplicate based on three variables

Appending Non-Duplicate based on three variables

Re: Append Unique records

checked

Re: Problem with macro variable resolution in dataset name

Re: can I choose few variable name from multiple text file

Re: can I choose few variable name from multiple text file

Re: can I choose few variable name from multiple text file