topic calculated column in SAS Data Studio in SAS Visual Analytics

calculated column in SAS Data Studio

Carlo98 — Fri, 26 Apr 2024 08:23:56 GMT

Hallo,

How do I create a calculated column in SAS Data Studio - Data prep

Can somebody give me the right syntax?

I write a code and then this problem occurs:

path: /SASDataStudio/ui/asyncOperation
correlator: 71d9b09d-474a-451f-b71c-47941067a490

Thats my code:

data UpdatedData;
set CASUSER(luca.list@knime.com).ZS_HS_2019_STUENDLICH_WETTER;

/* Erstelle eine Testspalte */
TestColumn = "Test";
run;

Thanks

Re: calculated column in SAS Data Studio

PaigeMiller — Fri, 26 Apr 2024 10:38:29 GMT

Please tell us what is wrong with your code. Please be specific and detailed.

Re: calculated column in SAS Data Studio

Carlo98 — Fri, 26 Apr 2024 14:01:08 GMT

I have imported data into SAS Viya, where the 'Zeit' column, which contains various timestamps from the year 2020, was not recognized as a datetime format but was instead interpreted as varchar. I attempted to manually convert this column to a datetime format. However, instead of displaying the converted datetime values, the new column only shows dots (.), indicating a failure in the conversion process.

Re: calculated column in SAS Data Studio

Patrick — Sat, 27 Apr 2024 03:31:35 GMT

I couldn't find a SAS informat that can directly convert the source string to a SAS datetime value which is eventually also why your import didn't do it.

I did manage to convert the string to a SAS datetime value with code running in CAS using below syntax

cas mysession;
libname casuser cas;

data casuser.have;
  length zs_hs_2019_andSoOn varchar(*);
  zs_hs_2019_andSoOn='01.01.2019 05:43';
run;

/* data casuser.want; */
data casuser.have;
  set casuser.have;
  sas_dttm=sum(
    input(scan(zs_hs_2019_andSoOn,1,' '),ddmmyy10.)*86400,
    input(scan(zs_hs_2019_andSoOn,2,' '),time.)
    );
  format sas_dttm datetime20.;
run;

cas mysession terminate;

Re: calculated column in SAS Data Studio

LinusH — Mon, 29 Apr 2024 09:05:22 GMT

If this is a common format for you, it could be an idea to create your own informat using PICTURE.

Re: calculated column in SAS Data Studio

Patrick — Mon, 29 Apr 2024 10:10:11 GMT

@LinusH wrote:

If this is a common format for you, it could be an idea to create your own informat using PICTURE.

@LinusH How would you use a picture format to convert a source string to a SAS datetime value?

Re: calculated column in SAS Data Studio

FreelanceReinh — Mon, 29 Apr 2024 11:10:41 GMT

@Patrick wrote:

I couldn't find a SAS informat that can directly convert the source string to a SAS datetime value ...

Informat NLDATM. works for me with system option LOCALE=DE_DE.

Re: calculated column in SAS Data Studio

LinusH — Mon, 29 Apr 2024 12:22:27 GMT

My bad, and I think I made this mistake before...so I'm thinking that there should an INPICTURE capability in PROC FORMAT, corresponding to INVALUE.