Hi everyone, please I have confusion on how an indirect references works sas macro. I don't understand how this resolves to type2;
%let value1 = dogs; %let value2 = cats; %let value3 = birds;
%let type1 = value1; %let type2 = value2; %let type3 = value3;
%let animal = type2; %let final = animal;
%put &&&&&&final;
... View more
Hello Everyone, I am trying to connect to ODA using data bricks. I followed the setup document in this post: https://communities.sas.com/t5/New-SAS-User/How-to-connect-SAS-ODA-to-Azure-Databricks/td-p/826511 With no success, I am getting the error message: Any assistance would be great, thank you.
... View more
Hello, I have a weekly product sale in EQ in time series data(total 88 weeks) with mean=15,000 and standard deviation=2,500. I’m working on producing a matrix of confidence intervals and “power” analysis to determine what % lift (e.g. 5% or 6%) of sale do I need to observe to be confident the lift is statistically significant between the two test/control market pairs I identified. The goal is to have a X%(e.g. 95%) power chance of obtaining a Y%(e.g. 90%) confidence interval whose half-width is at most from Z%(5% or 6%) lift of eq sales for next 26 weeks. I need to complete this matrix below that will look something like this: I've tried to use the code below but don't know how to set up the parameters in "proc power". Can someone shed some lights here? Thanks so much for your help in advance. I ODS Output PlotContent = want; proc power; onesamplemeans ci=t SIDES=2 alpha = 0.05 ,0.1 halfwidth = 750 to 1500 by 150 stddev = 2500 probwidth =. ntotal = 8; plot x=effect min=500 max=3000 XOPTS=( REF=1500 2000 2200 2500 CROSSREF=YES); run;
... View more
Sometimes you hit “post” and our platform whisks your stuff to our spam quarantine. Unfortunately technical content, with code and arcane symbols, is susceptible to being detained. Good news: It’s now easy to alert community admins to release falsely imprisoned posts.
... View more
We have a huge table need to be copied from SAS Server to Snowflake. If we use insert into SN.TEST table, it takes almost 3 hours to pass 80M rows with 31 columns. I also try to use PUT command in EXECUTE () BY SN; it also give another type of error and will cause disconnection. Then I try to add bulkload option into the libname statement, however, it still now works. 427 libname SN sasiosnf SERVER="XXXXXXXXXXX" 428 conopts="uid=XXXXXXXXXXX;authenticator=snowflake_jwt; 429 priv_key_file=XXXXXXXXXXXrsa_key.p8; 430 priv_key_file_pwd=XXXXXXXXXXX;" 431 Role="XXXXXXXXXXX" 432 warehouse="XXXXXXXXXXX" 433 database="XXXXXXXXXXX" 434 schema="XXXXXXXXXXX" 435 READBUFF=32000 436 INSERTBUFF=32000 437 DBCOMMIT=32000 438 CONNECTION=GLOBAL BULKLOAD=YES bl_internal_stage="table/TEST"; NOTE: Libref SN was successfully assigned as follows: Engine: SASIOSNF Physical Name: XXXXXXXXXXX 12 The SAS System 16:27 Friday, September 27, 2024 439 440 441 PROC SQL; 442 CONNECT USING SN; 443 Execute (REMOVE @test) by SN; 444 DELETE FROM SN.TEST; NOTE: No data found/modified. 445 QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.76 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 5457.46k OS Memory 19880.00k Timestamp 09/27/2024 04:27:27 PM Step Count 92 Switch Count 0 Page Faults 0 Page Reclaims 676 Page Swaps 0 Voluntary Context Switches 21 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 446 447 PROC APPEND BASE = SN.TEST DATA = INPUT.CLAIMS; 448 RUN; NOTE: Appending INPUT.CLAIMS to SN.TEST. ... NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 83056675 observations read from the data set INPUT.CLAIMS. NOTE: 83056675 observations added. NOTE: The data set SN.TEST has . observations and 31 variables. ERROR: Error executing COPY command: Failed to decrypt. Check file key and master key. NOTE: Statements not processed because of errors noted above. 13 The SAS System 16:27 Friday, September 27, 2024 NOTE: PROCEDURE APPEND used (Total process time): real time 16:43.26 user cpu time 13:40.28 system cpu time 20.37 seconds memory 6913.90k OS Memory 20888.00k Timestamp 09/27/2024 04:44:11 PM Step Count 93 Switch Count 0 Page Faults 2 Page Reclaims 79594 Page Swaps 0 Voluntary Context Switches 6327 Involuntary Context Switches 6031 Block Input Operations 1049600 Block Output Operations 27968608 NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements.
... View more