Solved: proc sql create table problem - SAS Communities
Sep 11, 2024 · Hi, I have a data set with several variable. Out of this, I want to create a separate data set with some existing variables and some new variables, that are produced out of an …
proc sql create table select with a blank column
Oct 7, 2024 · proc sql ; create table want as select ' ' as New_Field length=50 , have.* from have ; quit; If the name is non standard then you could either use a name literal. ' ' as 'New_Field'n …
Dictionary Tables: A SAS Hidden Gem
Apr 30, 2025 · They're updated automatically by SAS and can be accessed using PROC SQL. In this post, we'll explore how these tables can be used to examine datasets in a library, identify …
Solved: I have a PROC SQL - SAS Communities
Oct 9, 2024 · The PROC SQL statement is as follows: CREATE TABLE Falls_by_month_req_hosp AS SELECT month, COUNT(*) AS med_help FROM Falls_log …
Proc sql datatypes in create table statement - SAS Communities
May 22, 2024 · Please I need clarifcation on the code below. Thanks. "data-type bis enclosed in parentheses and specifies one of the following: CHARACTER (or CHAR) | VARCHAR | …
proc sql to create multiple tables by variable values
Oct 29, 2019 · Solved: I want to create multiple tables from one data set using proc sql. First thought is using loop with macro variables. The large data set likes
Creating tables with proc sql based on subqueries?
Jan 13, 2016 · Hi, I am trying to create a new table or data set differently based on logic that looks for specific records in a data set. For example, I want to create a new data set with a WTD, …
check if table exists & create if not - SAS Communities
May 1, 2020 · As this is a very specific macro for a certain type of table, I think you would be better off just using the date as the parameter. Possibly, you will want to have the library path …
How do I use a temporary SQL table in passthrough?
Feb 3, 2024 · I am working with previously written code that creates a comma separated macro list, and then uses this in a passthrough Oracle SQL query like so (this is a simplified …
Proc Sql: Creating New Table with Format - SAS Communities
Feb 12, 2019 · " When I create a query to list the data in the table" - do you mean the lst output from proc sql? Use proc report (or other reporting function) to output the data to a particular file …