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: 
Rohan
‎09-01-2015
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Compare two data sets

by Calcite | Level 5 in SAS Programming
‎02-04-2012 11:59 PM
‎02-04-2012 11:59 PM
Hello Friends, I want to search if a observation (date) in data set B1 is in data set A1 or not. If obv in A1 found then print "found" else append the observation of B1 into A1. data a1; input date_file $; datalines; 24NOV2011 25NOV2011 26NOV2011 27NOV2011 28NOV2011 ; data b1; input date_file $; datalines; 26NOV2011 30NOV2011 ; I try to use PROC COMPARE but it's not giving desirable result. Please help me out. Thanks Rohan, ... View more

Re: How to print userid.

by Calcite | Level 5 in SAS Programming
‎01-18-2012 03:05 AM
‎01-18-2012 03:05 AM
Hello Ksharp, Thanks for the reply. if I use "&sysuserid" , it would create a column in dataset. but I want to pass the value of it to another variable. data ABC; id = &sysuserid; run; I want that dataset ABC only has one column named ID and it contains the value of sysuerid. Could u please help me out ? Thanks, ... View more

How to print userid.

by Calcite | Level 5 in SAS Programming
‎01-18-2012 01:29 AM
‎01-18-2012 01:29 AM
Hello Friends, I have a issue. I want to print the userid while I'm updating a dataset in column "updated_by". I'm not getting the function to get it. Could you please help me out? Thanks ! Rohan. ... View more

File name in macro variable.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 10:20 AM
‎12-27-2011 10:20 AM
Thanks Kshrap. but i still wonder why was "%nrquote" not working ... View more

File name in macro variable.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 10:18 AM
‎12-27-2011 10:18 AM
Thanks Laary.... my bad ... View more

File name in macro variable.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 02:02 AM
‎12-27-2011 02:02 AM
Hello Frnds, I have a doubt, %let srcpath = %nrquote(/PROJECT/sourcefiles/); %let file1 = %unquote(rohan.txt); data XXX; if (fileexist("&scrpath/&file1")) then do; infile "&srcpath/&file1"; input date1 date9. number; end; run; but this " fileexist("&scrpath/&file1"))" is not working. Code is not able to resole the macro variable. Please help. Thanks. ... View more

Re: Need help to repat the row based on column value.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 01:59 AM
‎12-27-2011 01:59 AM
Thank you for response.. ... View more

Re: Need help to repat the row based on column value.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 01:59 AM
‎12-27-2011 01:59 AM
Thank you for response.. ... View more

Re: Need help to repat the row based on column value.

by Calcite | Level 5 in SAS Programming
‎12-27-2011 01:57 AM
‎12-27-2011 01:57 AM
Thank you Resa,, u rocks.. ... View more

Need help to repat the row based on column value.

by Calcite | Level 5 in SAS Programming
‎12-16-2011 12:40 AM
‎12-16-2011 12:40 AM
Hello All, I have a problem. I have to split the row based on a column value. My data is like : Key  Coupon   ID 1       1234      A 2        0100     B 3.       0081     C Otput should be Coupon      ID 1               A 2               A     3               A     4               A               1               B 8               C 1               C ie. if for all the non-zero values in Column Coupon, the entire row should repeat except Column Coupon. The Vaue in coupon should be splied in 1 char. Please help me. I'm new for SAS programming. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links