cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Jhonarsalina
‎06-14-2022
  • 11 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Show more characters in a column

by Calcite | Level 5 in SAS Programming
‎06-08-2022 03:07 PM
‎06-08-2022 03:07 PM
I've already managed to see all the information in the column. I added the option DBMAX_TEXT= at the moment of connecting to SqlServer: libname analytic sqlsvr dsn="SQL Server Wire Protocol" user="Admin" password="3DAPass" schema=dbo DBMAX_TEXT=12000;   Thank you very much.   Cheers ... View more

Re: Show more characters in a column

by Calcite | Level 5 in SAS Programming
‎06-08-2022 02:35 PM
‎06-08-2022 02:35 PM
I was checking and it brings all the information but it does not show it in the table. It is displaying 1024 characters max. Do you know of a way to show more? ... View more

Show more characters in a column

by Calcite | Level 5 in SAS Programming
‎06-08-2022 12:59 PM
‎06-08-2022 12:59 PM
Hello, Requesting your help again. I am taking a table from sql server to SAS Viya. In that table there is a variable of length greater than 1024.   I use the following code to copy the table:   DATA survey08; length RESPONSEDIAN_DESC $ 2000; set ANALYTIC.VC_RESPONSEDIAN ; inFORMAT RESPONSEDIAN_DESC $2000. ; FORMAT RESPONSEDIAN_DESC $2000. ; RUN; Show the following warning; WARNING: During read: [SAS][ODBC SQL Server Wire Protocol driver]String data, right truncated. En la tabla resultado me presenta lo siguiente: I would like to know how to see more characters in this view.   Beforehand thank you very much   Cheers   Jhonar Salina     ... View more

Re: Backup codes SAS VIYA 3.4

by Calcite | Level 5 in Administration and Deployment
‎08-27-2021 01:11 PM
‎08-27-2021 01:11 PM
Thank you very much for your help.   Our SAS reseller told us that in SAS VIYA version 3.4 the option to link a GIT to Sasstudio is not available.   When trying to follow the document that he shared with me, it does not give me the option:   Greetings ... View more

Backup codes SAS VIYA 3.4

by Calcite | Level 5 in Administration and Deployment
‎08-27-2021 12:36 PM
‎08-27-2021 12:36 PM
  Good Morning,   I hope you are well, I request your kind collaboration in helping me if possible, how to make a backup to the codes that we make in SASSTUDIO within SAS VIYA version 3.4, we are currently doing them manually, as follows, one by one:   But it doesn't give me the option to download a folder containing the codes:   I would like to know if you know of any way to download all the .SAS files in a faster way.   Thank you in advance for your cooperation.   Greetings Jhonar Salina ... View more

Re: Transpose table

by Calcite | Level 5 in SAS Studio
‎07-30-2021 03:41 PM
‎07-30-2021 03:41 PM
@Reeza wrote: There are exact examples of this in the transposing data tutorials below: Long to Wide: https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/ https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/ @Jhonarsalina wrote: Good Morning, I request your kind cooperation. I have the following table:   ID Vehicle Class Brand Model 1 12132 Automovile Ford 2000 1 12135 Automovile Chevrolet 2020 2 12138 Automovile Audi 2015 2 12141 Motocycle BMW 2010 2 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008   I need to have it as follows: ID Vehicle_1 Class_1 Brand_1 Model_1 Vehicle_2 Class_2 Brand_2 Model_2 Vehicle_3 Class_3 Brand_3 Model_3 1 12132 Automovile Ford 2000 12135 Automovile Chevrolet 2020         2 12138 Automovile Audi 2015 12141 Motorcycle BMW 2010 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008                   the data is as follows: data datos; input ID $ Vehicle $ Class $ Brand $Model; datalines; 1 12132 Automovile Ford 2000 1 12135 Automovile Chevrolet 2020 2 12138 Automovile Audi 2015 2 12141 Motocycle BMW 2010 2 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008 ; run;   Beforehand thank you very much.   Greetings     Thanks a lot   ... View more

Transpose table

by Calcite | Level 5 in SAS Studio
‎07-30-2021 01:51 PM
‎07-30-2021 01:51 PM
Good Morning, I request your kind cooperation. I have the following table:   ID Vehicle Class Brand Model 1 12132 Automovile Ford 2000 1 12135 Automovile Chevrolet 2020 2 12138 Automovile Audi 2015 2 12141 Motocycle BMW 2010 2 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008   I need to have it as follows: ID Vehicle_1 Class_1 Brand_1 Model_1 Vehicle_2 Class_2 Brand_2 Model_2 Vehicle_3 Class_3 Brand_3 Model_3 1 12132 Automovile Ford 2000 12135 Automovile Chevrolet 2020         2 12138 Automovile Audi 2015 12141 Motorcycle BMW 2010 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008                   the data is as follows: data datos; input ID $ Vehicle $ Class $ Brand $Model; datalines; 1 12132 Automovile Ford 2000 1 12135 Automovile Chevrolet 2020 2 12138 Automovile Audi 2015 2 12141 Motocycle BMW 2010 2 12144 Bus Ford 1950 3 12147 Bus Chevrolet 2008 ; run;   Beforehand thank you very much.   Greetings     ... View more

Re: scheduled jobs do not execute programs with the CATX function

by Calcite | Level 5 in SAS Programming
‎11-30-2020 10:20 AM
‎11-30-2020 10:20 AM
Thank you all very much for your answers,   I opened a ticket and they are reviewing the case, it seems that there is some problem with the jobs in the software installation, the problem is not with the code, since in SasStudio it ends successfully.   Cheers ... View more

Re: scheduled jobs do not execute programs with the CATX function

by Calcite | Level 5 in SAS Programming
‎11-24-2020 02:08 PM
‎11-24-2020 02:08 PM
Sorry the code is as follows: Data C_COMPAREND_FECHINFRA (keep = PERSINVOL_TIPOIDENT_IDTIPIDE PERSINVOL_NRODOCUME COMPAREND_FECHINFRA); set COMPAREND_FECHINFRA_F ; length COMPAREND_FECHINFRA $1000 ; COMPAREND_FECHINFRA = catx( '|' , of col: ) ; run; It was the translator's fault. ... View more

Re: scheduled jobs do not execute programs with the CATX function

by Calcite | Level 5 in SAS Programming
‎11-24-2020 01:12 PM
‎11-24-2020 01:12 PM
What does the registry look like? The variables are date type What exactly does "do not run" mean? Does the work never start? Does it start but fail? Just that data pass not executing (there should be something in the log)? It starts but fails, only this step fails. It shows the following error: Error: 71-185: The call to the CATX function does not have enough arguments. Show the code using the CATX function. data C_Cod_GrupoInfra (keep = PERSINVOL_TIPOIDENT_IDTIPIDE PERSINVOL_NRODOCUME Cod_GrupoInfra); set Cod_GrupoInfra; length Cod_GrupoInfra $ 1000; Cod_GrupoInfra = catx ('|', from col :); run; Thanks a lot 🙂 ... View more

scheduled jobs do not execute programs with the CATX function

by Calcite | Level 5 in SAS Programming
‎11-24-2020 12:44 PM
‎11-24-2020 12:44 PM
The code that I am trying to execute in a job scheduled in SasStudio, executes successfully, but when I schedule it in an automatic job it ends when trying a DATA step that includes the CATX function, do I have to add any option for this type of functions run?   Thank you very much in advance.   Cheers ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-14-2022 12:20 PM
Quick links