About staplegunjelly

staplegunjelly · ‎02-25-2024

I'm sorry. I meant to say long table. Its the same two variables but much more values for each. I basically want to display it in the way I showed in the post. Here's the sample data: data have; input equipment $ voltage $; datalines; A 13KV B 23KV C 115KV D 115KV E 230KV F 230KV G 13KV H 13KV ;

staplegunjelly · ‎02-25-2024

Hello Everyone! I have a large table which looks like this: And I would like to transform it into something like this: What's the best way to achieve this?

staplegunjelly · ‎02-21-2024

I had no idea about the datastyle option. Thanks a lot! That did the job for me. I also tried writing my own program but it worked differently across different csv files.

staplegunjelly · ‎02-21-2024

Hello Everyone! This is for a personal project of mine. I need to aggregate a ton of csv files to get my data prepped. I have 2 datetime columns in my csv files which look like: datetime_beginning_utc,datetime_beginning_ept 2/11/2022 5:00:00 AM,2/11/2022 12:00:00 AM The date part of these values are in the mm/dd/yyyy format. When using proc import, the datetimes are being stored as: Is there anyway to fix this? or any work arounds? I'm using SAS 9.4

Online Status	Offline
Date Last Visited	‎02-25-2024 08:45 PM

Re: Table transformation/reporting

Table transformation/reporting

Re: Datetimes in the wrong format when importing csv files

Datetimes in the wrong format when importing csv files

Re: Datetimes in the wrong format when importing csv files

Re: Table transformation/reporting

Table transformation/reporting

Re: Datetimes in the wrong format when importing csv files

Datetimes in the wrong format when importing csv files