About Sudhan

Patrick · ‎06-08-2020

Good that you've got your solution. And just as a tip: It's normally not appreciated if you mark your own post as solution.

Kurt_Bremser · ‎06-02-2020

@yabwon wrote: Kurt, Two thoughts if I may: 1) Wouldn't the MODIFY statement do an update "in place" without rewriting dataset? 2) With increasing flag value for new data you will always have to find current maximum value to get the latest data instead just "where flag = 1". All the best Bart If you manipulate the flag variable in the existing data, you will always have to read/write the whole dataset. The increasing flag for new data means that you only have to read the last observation of the existing dataset, and increment that. So my code reads the last observation of existing; will be very fast reads/writes the new data to set the flag reads/writes the new data during append I don't know if you can use modify to do a pure append, where the existing data is not at least read as a whole.

Kurt_Bremser · ‎03-05-2019

proc sort data=&column_name.; by id; run; proc sort data=schema.target; by id; run; data schema.target_new; merge schema.target (in=orig) &column_name. (in=update keep=id value) ; by id; if orig; if update then &column_name. = value; drop value; run; Once you have verified the result, remove schema.target and rename schema.target_new to schema.target.

Astounding · ‎03-04-2019

Since you will need a data step anyway, why use SQL at all? Why not: data want; set have; newvar = put ( name, 30. ); drop name; rename newvar = name; run; The new version is right-hand justified, although you could easily add to the program to change that.

FreelanceReinh · ‎02-05-2019

Hello @Sudhan and welcome to the SAS Support Communities! How about something along these lines: data source_table; input field_no field_name $; cards; 1 A 3 C 2 B ; proc sql noprint; select catt(field_name, ' char(30)') into :fn separated by ', ' from source_table order by field_no; create table target_table (value_1 char(30), &fn); quit;

Online Status	Offline
Date Last Visited	‎06-12-2020 07:10 AM

Re: Combining Datasets on variable field length

Re: Combining Datasets on variable field length

Combining Datasets on variable field length

Re: Append data to a table and increment a flag on the resultant table

Append data to a table and increment a flag on the resultant table

Update a column in a table with values from another table

Modify Column data types and format on a table based on another table

Data step to create tables based on a column value

Re: Combining Datasets on variable field length

Re: Combining Datasets on variable field length

Re: Append data to a table and increment a flag on the resultant table

Re: Update a column in a table with values from another table

Re: Modify Column data types and format on a table based on another ta...

Re: Data step to create tables based on a column value