About amorts

amorts · ‎11-04-2017

Thanks both for your help! I will give that a go.

amorts · ‎11-03-2017

If it helps I'll be more specific. I have a bunch of empty dimension table following an initial deployment. I need to insert a default unknown record in each of them. As an example: -1, 'Unknown' This will be hardcoded as a sql statement so there is no source table. Let me know what you need I'll provide additional information.

amorts · ‎11-03-2017

I have quite a basic requirement to insert a record into a table and based on a hard coded sql statement using SAS DI. Initially I thought I could use a insert row transform but this requires a source table. So what is the best way of doing this?

amorts · ‎10-19-2017

Hello, I have a SAS DI job which takes a bunch of tables from Oracle, pushes down the join criteria before it hits a table loader which directs the dataset into SAS. The join operation completes very quickly, according to the Stats tab in 1 second and returns 7,931 records but the table loader has been processing for nearly two hours. Options on the table loader are as follows: Load Style: Replace Replace: Entire Table New Rows: Append (Proc Append) Is there anyway I can work out why this transformation is taking so long? Is it possible to view the process in SAS management studio at all?

amorts · ‎10-09-2017

Ok thanks. Why doesn't it inherit the data type from the incoming data? What does it default to?

amorts · ‎10-09-2017

Ok so the field is stored as a num format 17.2. The result from the max is 5E8 Applying the best32. Works and returns the result 500000000

amorts · ‎10-07-2017

Ok thanks. I don't have access to the code right now but I'll post an example on Monday

amorts · ‎10-07-2017

Is there anything I should be designing into a dimensional model specifically for SAS VA? For example star or snowflake schema? I heard it extracts all the data from the database and loads it as a flat table - is this right?

amorts · ‎10-07-2017

I am running some Proc SQL queries e.g. MAX(variable) where the result cannot be displayed correctly due to the size of the number. How do I format this within the query to see the actual number?

amorts · ‎10-07-2017

Hi All, Is it possible to drag and drop table or column names from the explorer pain onto the Program code page in SAS EG? I don't find the intellisense picks up the objects within a library either. Any advice would be useful. Thanks

amorts · ‎10-05-2017

Thank you. That seems to be working now although is taking a long time. I'll take a look into how I can't reduce the time it takes.

amorts · ‎10-04-2017

Hi, thanks for the response. I have tried using it without any specifications beyond the dataset like this: proc freq data=library.tablename run; And I get the following error: ERROR: File library.tablename.DATA does not exist. ERROR: The metadata for the table/view library.tablename does not exist. ERROR 22-322: Syntax error, expecting one of the following: ;, (, ALPHA, CHARTYPE, CLASSDATA, CLM, COMPLETETYPES, CSS, CV, DATA, DESCEND, DESCENDING, DESCENDTYPES, EXCLNPWGT, EXCLNPWGTS, EXCLUSIVE, FW, IDMIN, KURTOSIS, LCLM, MAX, MAXDEC, MEAN, MEDIAN, MIN, MISSING, MODE, N, NDEC, NMISS, NOLABELS, NONOBS, NOPRINT, NOTHREADS, NOTRAP, NWAY, ORDER, P1, P10, P20, P25, P30, P40, P5, P50, P60, P70, P75, P80, P90, P95, P99, PCTLDEF, PRINT, PRINTALL, PRINTALLTYPES, PRINTIDS, PRINTIDVARS, PROBT, Q1, Q3, QMARKERS, QMETHOD, QNTLDEF, QRANGE, RANGE, SKEWNESS, STACKODS, STACKODSOUTPUT, STDDEV, STDERR, SUM, SUMSIZE, SUMWGT, T, THREADS, UCLM, USS, VAR, VARDEF. ERROR 202-322: The option or parameter is not recognized and will be ignored. As my SAS set up and permissions on new I wanted to check if this could be related?

amorts · ‎10-04-2017

Hi All, I am new to SAS EG and don’t have access to Data Flux. I would like to run some basic data profiling (min, max, count, Null values etc.) against a group of tables which exist in SAS. I have come across bits and pieces of code online but none seem to be complete and provided in a way that can be easily used. I would imagine it’s a very common task and it would be time consuming to hand code which is what I would like to avoid. I want to provide a table name and for the code to run some basic checks and output the results based upon the table structure and data types. Thanks for your help

amorts · ‎09-19-2017

Spot on @Reeza

amorts · ‎09-18-2017

Great. All sounds like sensible advice. I will follow your approach and get familiar with the UE so the transition is easier when I get access to DI

Online Status	Offline
Date Last Visited	‎11-03-2017 03:07 PM

Re: Insert default row into tables

Re: Insert default row into tables

Insert default row into tables

Data Loader Performance Tuning

Re: Format large number?

Re: Format large number?

Re: Format large number?

Dimensional Model considerations for SAS VA

Format large number?

Intellisense or Drag and drop objects to code pane?

Re: Can you install a local copy of SAS DI for home use?

Re: Insert default row into tables

Re: Insert default row into tables

Insert default row into tables

Data Loader Performance Tuning

Re: Format large number?

Re: Format large number?

Re: Format large number?

Dimensional Model considerations for SAS VA

Format large number?

Intellisense or Drag and drop objects to code pane?

Re: How to quickly profile data in SAS EG?

Re: How to quickly profile data in SAS EG?

How to quickly profile data in SAS EG?

Re: Can you install a local copy of SAS DI for home use?

Re: Can you install a local copy of SAS DI for home use?