About Jose7

Jose7 · ‎04-28-2023

Thks! Tom, nice help!

Jose7 · ‎04-27-2023

Hi experts, I need to generate a json file from a table like this ACCOUNTS DATA account1 data1 account1 data2 account1 data3 account2 data1 account2 data2 account3 data1 account3 data2 account3 data3 but, I want to generate 1 json file for each account with its own data, example: {account1, "data1", "data2", "data3"} --> first json file {account2, "data1", "data2"} --> second json file {account3, "data1", "data2", "data3"} --> third json file Any idea how to do it ?

Jose7 · ‎04-15-2023

Hi administrators experts Is there a way to start and stop the object spawner from managment console? the sas installation is on linux or i have to do it from linux command ?

Jose7 · ‎12-12-2022

Thks! it works !

Jose7 · ‎12-12-2022

Hi experts I have a table like this Id Name Percentage 1 Ricardo 100 2 Jose 100 3 Roberto 50 3 Alexander 50 4 Carlos 100 5 William 50 5 Juan 50 6 Alonso 33 6 Perez 33 6 Menjivar 34 7 Regina 100 And i Want to add a column making a count like this Id Name Percentage Count 1 Ricardo 100 1 2 Jose 100 1 3 Roberto 50 1 3 Alexander 50 2 4 Carlos 100 1 5 William 50 1 5 Juan 50 2 6 Alonso 33 1 6 Perez 33 2 6 Menjivar 34 3 7 Regina 100 1 Do you have any idea how to make it ?

Jose7 · ‎07-17-2022

It worked, Thks !!

Jose7 · ‎07-16-2022

I have the physical table in Sybase IQ and the column is varchar(25000), I imported the metadata by management console and always 1024 length is assigned. Then I assigned the lib as meta in enterprise guide like this “libname LIB1 meta library="XXXX" metaout=data” , but when I want to see the table with a select or double click in the lib, I obtain an error, what can I do to solve this issue?

Jose7 · ‎07-15-2022

Hi experts, nice to write you again ! I have a trouble modifying the length of a column in management console, when i import the metadata from a table, as a defult, it has 1024, but the length that i need for that column is 25,000 the datatype is alphanumeric. The management console accepts this chance, but when I select the table from the enterprice guide (ver.7.15), it has always 1024. I'm modifying in management console the lenght, the informat, and the format

Jose7 · ‎04-28-2022

Hi experts! I have copied some .sas7bdat files in a sql server database and i want read the data using sql managment studio or reporting services Is there a way to do so??

Jose7 · ‎03-18-2022

Hi experts, I have a table in sybase IQ with a numeric field like this 74882512059898578830423 it´s a numeric(23,0), but when i read this number in a sas query, shows me a diferent number 74882512059898582269952 and also like this 7.48825120598986E+22 is there a way to obtain the original number that i have in sybase IQ ??, i have tried to convert to text, but i obtain the same.

Jose7 · ‎02-09-2022

Hi experts, I have a sas table like "xxx.sas7bdat", and i want to generate a xml file. can i do this directly using proc export? proc export data=personal.xxx outfile="/sasdatos/xml_file" dbms= ??? replace; quit; or i have to do other step and then generate the xml file ? Thks!

Jose7 · ‎06-08-2021

Hi experts, I have this value "-0000180" and i want to transform it into "000018p", where p simbolize the negative value for cobol according to this equivalents: 0=p 1=q 2=r 3=s 4=t 5=u 6=v 7=w 8=x 9=y i have to sustitute the last digit of the negative value by the corresponding letter and keep the zeroes to the left, examples: -000323 = 00032s -000567 = 00056w Do you have any idea to do it ?

Jose7 · ‎05-24-2021

Sorry the group by is T1.sec

Jose7 · ‎05-24-2021

Hi experts, I have this code: PROC SQL; CREATE TABLE my_table AS SELECT DISTINCT MAX(T1.sequential) AS num, MAX(T1.date1) AS pay_date format date9., T1.sec AS sequential FROM table_one T1, table_two T2 WHERE T1.number_A = T2.number_A GROUP BY T1.name; QUIT; and i obtain this : ****** in the max of the date, the format (date9.) does not work num pay_date sequential 3375414 ********* 24025521

Jose7 · ‎05-14-2021

My Friend, I found a solution using loop, Thks Anyway! %macro sqlloop(start,end); PROC SQL; %let DATE_FROM = '05MAY2019'd; %let DATE_PLUS1 = '06MAY2019'd; %DO ADD=&start. %TO &end.; CREATE TABLE compare_&ADD. as SELECT T2.DATE, T2.ACCOUNT, T2.VAL_HASH FROM TABLE1 T1, TABLE2 T2 WHERE T1.ACCOUNT = T2.ACCOUNT AND T1.DATE = "&DATE_FROM"d AND T2.DATE = "&DATE_PLUS1"d AND T1.VAL_HASH <> T2.VAL_HASH; %let DATE_FROM=intnx('DAY',&DATE_FROM,1); %let DATE_PLUS1=intnx('DAY',&DATE_PLUS1,1); %END QUIT; %mend; %sqlloop(start=1, end=5)

Online Status	Offline
Date Last Visited	3 weeks ago

How to convert a character to ascii code

Re: equivalent of tranwrd

equivalent of tranwrd

Find out a process making a table scan or cartesian product

Re: trouble generating a fix file with character ñ

Re: trouble generating a fix file with character ñ

Re: trouble generating a fix file with character ñ

trouble generating a fix file with character ñ

Re: Datetime convertion

Re: Datetime convertion

Re: equivalent of tranwrd

Re: equivalent of tranwrd

Re: equivalent of tranwrd

Re: equivalent of tranwrd

Re: Find out a process making a table scan or cartesian product

Re: Generate a json file

Generate a json file

start and stop object spawner from managment console

Re: Add a count column

Add a count column

Re: problem to change a column length in management console

Re: problem to change a column length in management console

problem to chance a column length in management console

Reading .sas7bdat file in sql managment studio

reading a big numeric field from IQ to sas

proc export to generate xml file

negative values to cobol pack values

Re: Getting max from a date in proc sql

Getting max from a date in proc sql

Re: Knowing if a data was update in a range of dates

SAS Inner Circle Panel

SAS Analytics Explorers