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: 
Criptic
‎03-08-2022
  • 172 Posts
  • 116 Likes Given
  • 13 Solutions
  • 48 Likes Received

Re: Select n rows before and after an observation based on 2 criteria

by Lapis Lazuli | Level 10 in SAS Programming
‎03-20-2019 06:37 AM
‎03-20-2019 06:37 AM
No worries, have a great one! ... View more

Re: PROC APPEND Alternatives

by Opal | Level 21 in SAS Data Management
‎03-18-2019 05:59 AM
‎03-18-2019 05:59 AM
@dharmesh  Just to show you how that would look like using SQL UNION CORR. data class1 class2 class3; set sashelp.class(where=(name='Alfred')); output; output; name='Other'; output class2; run; proc sql; create table want as select * from class1 union corr select * from class2 union corr select * from class3 ; quit; proc print data=want; run; This only works if you've got the same columns in all source tables AND if you really want to de-duplicate records which is different to just select the first record per sort key (where other variables within the same key still could have different values). ... View more

Re: Missing values in year function handled differently

by Lapis Lazuli | Level 10 in SAS Programming
‎02-12-2019 03:25 AM
‎02-12-2019 03:25 AM
Thanks the autoexec_usermods.sas was exactly the place where the option was set differently. ... View more

Re: SPD Server Table Loader Transformation autogenerates a libname sta...

by Lapis Lazuli | Level 10 in SAS Data Management
‎01-08-2019 02:25 AM
‎01-08-2019 02:25 AM
Pre-Assigned was the right keyword here for me. Somehow I forgot to set that option in one environment. Thank you! ... View more

Re: Suppress fluff in sas stored process log

by Rhodochrosite | Level 12 in Developers
‎11-15-2018 09:30 AM
1 Like
‎11-15-2018 09:30 AM
1 Like
SAS 9.4M6 should be available at the end of November 2018.   Vince DelGobbo SAS R&D ... View more

Re: Making ID variable without any other information

by Super User in SAS Programming
‎10-17-2018 01:43 PM
‎10-17-2018 01:43 PM
Keep your own counter per ITER instead of use the automatic _N_ variable. row+1; if first.ITER then row=1; Or you can use a DO Loop around the SET statement, note that means you need to add an OUTPUT statement. data long2; do row=1 by 1 until(last.Iter); set long1; by Iter; SUBID = 1 + int((ROW-1)/12); output; end; run;    Or better just use two DO loops. data long2; do SUBJID=1 by 1 until(last.iter); do row=1 to 12 until(last.Iter); set long1; by Iter; output; end; end; run; ... View more

Re: Can a stored process in enterprise guide use the work of the user ...

by Pyrite | Level 9 in SAS Enterprise Guide
‎10-17-2018 05:28 AM
‎10-17-2018 05:28 AM
thanks for the quick replies!   I don't see any other options then to create my own task, to make it not too complicated for business users   Using a library which is shared for every user is securitywise not a good option here. We also don't want our business users to have to write a proc contents to generate the table. ... View more

Re: calculating rolling standard deviation of stock return

by Quartz | Level 8 in SAS Programming
‎09-10-2018 08:09 AM
‎09-10-2018 08:09 AM
Thank you! It works 🙂 @Ksharp ... View more

Re: Execute the code on the first weekday of the month

by Super User in SAS Programming
‎08-21-2018 10:12 AM
‎08-21-2018 10:12 AM
data want;  set have;  year=year(date);  month=month(date);  if  date=nwkdom(1, 2, month, year) then output; run; ... View more

Re: Concatenate a symbol to a text string to create a macro variable

by Super User in SAS Programming
‎08-21-2018 08:43 AM
‎08-21-2018 08:43 AM
You mean this ?   %macro x; %let x=test; %do i=1 %to 3; %let x=&x+; %end; %put &x; %mend; %x ... View more

Re: Today date as a parameter

by Diamond | Level 26 in SAS Programming
‎08-20-2018 03:36 AM
‎08-20-2018 03:36 AM
Why would you need to create your own parameter?  SAS already provides numerous methods to get today's date and time in whatever format you need.  Do not create macro variables and code just for the sake of it!! ... View more

Re: Incremental Data Load from SAP

by Lapis Lazuli | Level 10 in SAS Data Management
‎08-20-2018 02:19 AM
2 Likes
‎08-20-2018 02:19 AM
2 Likes
Can you provide more information? - What DB is your SAP installation using? - In what increments to you want to extract the data? - Have you looked into SAS/ACCESS + the DB you are using? - https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=acreldb&docsetTarget=titlepage.htm&locale=de - Are the tables you need already defined as a SAS lib? - If you are using R/3 take a look at this: https://support.sas.com/documentation/cdl/en/accr3/67413/HTML/default/viewer.htm#p0ok97f6s88px3n1j90t45uht4l8.htm - ... View more

Re: Driving distance between postal codes in The Netherlands

by Lapis Lazuli | Level 10 in SAS Programming
‎08-20-2018 02:04 AM
‎08-20-2018 02:04 AM
The link that @art297 provided will be your best shot at doing something like that. Calculating driving times and espically routes on a turn by turn basis is a hard problem which is best solved by consuming an api like the one provided by Google Maps. ... View more

Re: Issue while updating existing configuration using SAS Deployment m...

by Amethyst | Level 16 in Administration and Deployment
‎08-17-2018 04:16 AM
‎08-17-2018 04:16 AM
Hello @karthic2612,   I am not that in opposition to cloned server as @Kurt_Bremser is, as long as the technical cloning is OK and aligned with SAS specifications/needs, and the fees/contract for the licenses with SAS are clear. However, and I agree with him in this part very much, it is true that this alignment requires a lot of experience and knowledge with SAS Solutions, and not everyone has it.   Do you have this same problem for each original or cloned server? To me, I would say there might a problem with the original installation, what was patched manually... probably even the deplpoyment plan file had errors and was ... troubleshooted/workarounded on a way that the SDM cannot find how to update the config appropiately.   I can align with @Criptic 's suggestion: the best you can do is to contact SAS Technical Support and get great help from them. Someone should give a look and touch your environment. ... View more

Re: How Do I create a ID based on a prior observation?

by Lapis Lazuli | Level 10 in SAS Programming
‎08-17-2018 02:34 AM
‎08-17-2018 02:34 AM
Just to elaborate a bit on the code posted by @Astounding and formatting it:   data work.table_1; input br value; datalines; 1 7184 0 9759 1 9988 0 6780 0 6398 1 7107 0 5776 0 3719 ; run; * _id is a temp variable which stores the latest value where br is 1; data work.table_2(drop=_id); length id 8.; set work.table_1; if br=1 then _id = value; * _N_ contains the current iteration number; if _N_ > 1 then id = _id; * retains the value from iteration to iteration; retain _id; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-08-2022 03:03 PM
Likes given to
Likes from
Quick links