About gyambqt

gyambqt · ‎04-12-2022

I am wondering how do you stop DI processing if there is an error within the loop start and loop end. For example: my DI jobs like below: table1--->loop start--->job1--->job2--->jobN---->loop end table1 is used to pass parameters to job1 for processing however I found even job1 result any error it will not stop the loop which means job2 ...Job3....JobN still gets executed. my question is how do you stop loop processing immediately if any of the middle jobs failed?

gyambqt · ‎01-12-2022

How do you register work table?

gyambqt · ‎01-11-2022

In SAS DI, for some transformation you will see work table represented by a green rectangular box. Is it possible to create the work table just like registered table? so instead of seeing rectangular box as work table, I want to see physical table feature for work table.

gyambqt · ‎12-15-2021

They are the same column

gyambqt · ‎12-15-2021

input Financial_Year;

gyambqt · ‎12-14-2021

The code I sent to you is the original copy without any changes. I changed to $char but it is not working.

gyambqt · ‎12-14-2021

infile "xxx" lrecl = 10000 delimiter = ',' dsd missover firstobs = 2 encoding = "ANY" termstr = CRLF; ; attrib column1 length = $1000 format = $1000. informat = $1000.;

gyambqt · ‎12-14-2021

Hi Tom, I am actually using file reader in DI to read CSV file. I changed the informat to $char but still not working.

gyambqt · ‎12-14-2021

Hi Experts: Simple question: I have a CSV file and one of a column has a dot (.) value I use infile to read this column into SAS table as a character value and the dot is gone. What is the reason behind?

gyambqt · ‎10-14-2021

thanks

gyambqt · ‎10-13-2021

Can you pls explain why is it working? I understand both %superq and resolve but what is happening when they used together?

gyambqt · ‎10-13-2021

Hi Experts, Given the program below how do I prevent the warnings? data test; call symputx('test','&test2'); test=resolve('&test'); run; Thanks

gyambqt · ‎09-16-2021

You could have more variables or changing variable name.

gyambqt · ‎09-16-2021

I am wondering if I use proc import to read the header in the csv file. And make each column name a macro variable. In DI I use &column1 &column2 etc. Do you think it is working? But I don’t know how to deal with my Scd2 issue as you need consistent name for variables used for detect change.

gyambqt · ‎09-16-2021

The CSV file they sent is with changing column every day. I just want to explore alternatives to read inconsistent CSV columns

Online Status	Offline
Date Last Visited	‎02-26-2024 02:16 AM

How to write a SAS program to find relationship between nodes

How to conduct impact analysis of a metadata table using SAS code

Re: Missing date column load data from Oracle to SAS

Missing date column load data from Oracle to SAS

Transfer text files from remote SFTP sever to local linux server

How to write a SAS code to extract SAS DI metadata objects?

How to identify log files differences between two log files?

Re: SAS bulkload issue

Re: SAS bulkload issue

Re: SAS bulkload issue

Re: why you can't use a macro funcation like %scan inside of a data st...

Re: How do I get the first part of the string using %scan

Re: How do I write a SAS program to re-construct the table?

Re: SAS bulkload issue

stored process questions (Stream vs Package outputs result)

SAS DI Loop question

Re: SAS DI, how to creatework table like a registered table?

SAS DI, how to creatework table like a registered table?

Re: Why SAS is converting . into blank value when read from CSV?

Re: Why SAS is converting . into blank value when read from CSV?

Re: Why SAS is converting . into blank value when read from CSV?

Re: Why SAS is converting . into blank value when read from CSV?

Re: Why SAS is converting . into blank value when read from CSV?

Why SAS is converting . into blank value when read from CSV?

Re: How to mask & in datastep

Re: How to mask & in datastep

How to mask & in datastep

Re: How to deal with changing columns in SAS DI

Re: How to deal with changing columns in SAS DI

Re: How to deal with changing columns in SAS DI