About rodrichiez

rodrichiez · ‎07-11-2018

Hello Tom, It is working now, what I forgot was to configure a multiline prompt. But I realized that the form of the value must be: '0000000085', '0000000086', '0002746556', So I need to add quotation marks and commas.

rodrichiez · ‎07-10-2018

Hi Tom, When I try to run the code I get this error: 28 29 proc sql; 30 create table work.test as 31 select * from WORK.QUERY_FOR_CUP0_0001_0000 t1 32 where t1.CIF in(&InClause.); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: Line generated by the macro variable "INCLAUSE". 32 s1 __ 22 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, (, -, SELECT. ERROR 202-322: The option or parameter is not recognized and will be ignored. And I can't paste more than one value at a time.

rodrichiez · ‎07-06-2018

Thank you TomKari!!

rodrichiez · ‎07-06-2018

Hello Tom, It would be the first one: 0005164890 0005164917

rodrichiez · ‎07-06-2018

Hello Fred, There is not such option in the properties of filter and sort task.

rodrichiez · ‎07-05-2018

Hi Tom, They would pastes identification value of a client, is character type. This one is an example: 0005164890. Sometimes they would need to pastes up to 700 values. Regards.

rodrichiez · ‎07-05-2018

Hi, I'm trying to create a prompt where the user can paste great amount of values. I insert the prompt in the where clause on a query builder with an In a list operator but when I run it the prompt only give me the option to enter one value at a time. I try to put the prompt in a filter a sort task as seen in code below but this task does not recognize the prompt. %LET CIF = s1; %LET CIF_count = 1; PROC SQL NOEXEC; SELECT t2.CIF, t2.CLIENTE, t1.NO_CUENTA, t2.CEDULA, t2.PASAPORTE, t2.RNC, t2.SEGMENTO, t1.TIPO_CUENTA FROM WORK.QUERY_FOR_CUP0_0000 t2 INNER JOIN WORK.QUERY_FOR_CUP0_0001 t1 ON (t2.CIF = t1.CIF) WHERE t1.TIPO_CUENTA IN ( 'SOW', 'IND', 'JAF', 'JOF' ) AND %_eg_WhereParam( t2.CIF, CIF, IN, TYPE=S, IS_EXPLICIT=0 ) ORDER BY t2.CLIENTE; QUIT; Any idea? Thanks.

rodrichiez · ‎05-24-2018

I've tried all the recommedations but did not work. So I divided the project on two stored process, one for populate the dynamic prompt and another one to select from the list of cards and enter the date range. Thanks all of you the suggestions and your time.

rodrichiez · ‎05-21-2018

@FredrikE I've tried selection group and it doesn't work.

rodrichiez · ‎05-18-2018

@FredrikEI'm not familiarize with that: " check for which step is active." How could I know which step is active?

rodrichiez · ‎05-18-2018

@ReezaThis is not the same because in my case, the project need to run one time to obtain the credit cards numbers to populate the dynamic prompt from wich the user can choose in another prompt the cards he wants and after that selection the project should continue running.

rodrichiez · ‎05-18-2018

Hi @Reeza The second prompt don't depend on the first. But, the result is use to populate the second prompt with credit cards numbers.

rodrichiez · ‎05-18-2018

Hello, I need some help. I created a project wihere in the first part the user enter a date range and a code, the result of this, update a table with credit card numbers, this table is use to populate a dynamic prompt where the users have the possibility to select the credit cards they want and another date range to bring the info of those credit cards. My problem is that when I run the project, the program prompt the user to enter all the information when the correct function of the project is firstly to prompt the user, for date range and a code and then with that result, prompt the user again with another date range and a list of credit cards generated from the previous result. I tried define a cascading prompt at the stored process steps, but it doesn't work. Any idea?

rodrichiez · ‎02-20-2018

Hello, I want to know how could I search every word from a string in another string, I have 2 tables with names, but I need to search for coincidences, and bring the match found to another column. The result I'm looking for is a table where I can see the matching names from both tables. TABLE 1: JOSE MANUEL YULISA PEREZ JULIO CESAR VALENTIN SHEILA DE LA ROSA CHRISTIAN RODRIGUEZ TABLE 2: JOSE MANUEL YULISA PEREZ JULIO CESAR ALMANZAR SUGELY DE LA ROSA CHRISITAN QUEZADA

rodrichiez · ‎02-06-2018

Hi, I'm trying to send an email with attachment via SAS, but it seems not to recognize the local route of the file. Everytime I try to send it, I get the error: ERROR: Error opening attachment file C:\SASDATA\DATA.csv. ERROR: Physical file does not exist, /sas/sasconfig/Lev1/SASApp/C:\SASDATA\DATA.csv. The code is: FILENAME MailBox EMAIL ATTACH='C:\SASDATA\DATA.csv' to= ('ch@hotmail.com') type='text/html' subject= 'TEST' from='DE@hotmail.com'; data _null_; file MailBox; put 'FILE ATTACHED'; run; Please help.

Online Status	Offline
Date Last Visited	‎06-08-2022 05:43 PM

Re: Extrange results using trim and compress functions

Re: Extrange results using trim and compress functions

Strange results using trim and compress functions

Re: Action on Key Value object

Action on Key Value object

How to import a large dataset to a library

Re: Dynamic prompt

Re: Dynamic prompt

Re: Dynamic prompt

Re: Dynamic prompt

VA Report Example: Ways to use the Cumulative Period operator

Re: Display rules in Crosstabs

Re: SAS Excel Add-in load issue

Re: %DO %UNTIL in PROC SQL

Re: How to suspend a sas program for a period of time

How to import a large dataset to a library

Re: Prompt user more than one time

Re: ERROR: The format CHAR was not found or could not be loaded

Re: How to create a prompt to enter a list of values

Re: How to create a prompt to enter a list of values

Re: How to create a prompt to enter a list of values

Re: How to create a prompt to enter a list of values

Re: How to create a prompt to enter a list of values

Re: How to create a prompt to enter a list of values

How to create a prompt to enter a list of values

Re: Prompt user more than one time

Re: Prompt user more than one time

Re: Prompt user more than one time

Re: Prompt user more than one time

Re: Prompt user more than one time

Prompt user more than one time

Search for words in a string

ERROR: Error opening attachment file