I've never done it, but documentation from PROC DATASETS appears you can set MEMTYPE to view. I don't have time to test it either, so someone else may know better.   Next question would be what you want to do with it. Delete? Move? ... View more

Not sure if this is what you want.   data have; input id v1 v2 v3; datalines; 1 . . 3 2 1 2 3 3 . . . 4 1 . . ; run; data want (drop = i); set have; array _v [*] v:; total_miss = 0; do i = 1 to dim(_v); if missing(_v[i]) then total_miss + 1; end; run; Please provide example data in the future so we can understand what you need. ... View more

In the past with pass-through, which you are showing, I have done this to variables:   %str(%')<value>%str(%') Not sure if that will resolve your issue. I think it gets difficult because you mention the command line and what not.   And I primarily use Oracle with passthrough, which requires single quotes. If it's in a macro, the single quotes will cause issues. ... View more

All of it can be done in PROC TRANSPOSE.   You can also do it in a DATA step.   But best practice would be to get familiar with PROC DATASETS as it doesn't have to read in the entire file.   For this case, it is probably ok to not use PROC DATASETS, but if your files start to get much larger, then PROC DATASETS will be much faster. It doesn't have to read in the entire data set from your SET statement. It will modify the variable names on the data set directly.   data have; input _name_ $ "2023"n "2024"n; datalines; count 1 2 ; run; proc datasets library = work memtype = data nolist; modify have; rename "2023"n = _2023 "2024"n = _2024 ; run; quit; data want; set have (rename = ("2023"n = _2023 "2024"n = _2024)); run; ... View more

Are you able to pull directly from the database?   If so, you can use pass-through and the code you have listed. I haven't evaluated your actual code - just offering an idea.   Otherwise, it cannot be done with SAS PROC SQL and requires a DATA step as mentioned by @PaigeMiller. ... View more

You could store it in your autoexec. I'd probably just save it somewhere (not sure what platform you're using) and use the %INCLUDE statement in your autoexec. ... View more

My apologies - sometimes I read too quickly.   data want; x = TODAY(); format x yymmddn8.; run; proc sql; select format from dictionary.columns where libname = "WORK" and memname = "WANT"; quit; ... View more

Is there a reason you can't use dictionary.columns? proc sql; select name , type from dictionary.columns where libname = "SASHELP" and memname = "CARS"; quit; Or even PROC CONTENTS?   What is the purpose of the macro variable?   If you need to, you can still place it in a macro variable.   proc sql; select type from dictionary.columns where libname = "SASHELP" and memname = "CARS" and name = "MSRP"; quit; ... View more

No, you were clear – I misread it! ... View more

Can also be done in a DATA step, but PROC SQL might be better since you don't have to sort.     data mydata; input patient_id $ medication :$11. claim; datalines; ID1 medication . ID1 medication . ID1 medicationX 1 ID1 medication . ID2 medication . ID2 medication . ID2 medication . ID3 medicationX 1 ID3 medication . ID3 medicationX 1 ID3 medication . ; run; proc sort data = mydata; by patient_id descending claim; run; data want; set mydata; by patient_id; retain new_claim; if first.patient_id then call missing(new_claim); if not missing(claim) then new_claim = claim; run; Obs patient_id medication new_claim 1 ID1 medicationX 1 2 ID1 medication 1 3 ID1 medication 1 4 ID1 medication 1 5 ID2 medication . 6 ID2 medication . 7 ID2 medication . 8 ID3 medicationX 1 9 ID3 medicationX 1 10 ID3 medication 1 11 ID3 medication 1 This is commonly called last observation carried forward or LOCF.   ... View more

I would recommend marking @PaigeMiller's response as the correct one. ... View more

@PaigeMiller's solution was untested, so this was expected.   Use LIBNAME = "WORK" instead. Always use caps when you use dictionary.tables/columns. ... View more

Are you able to show your actual code?    You say you use two numeric variables to create the third, but you're only showing one? I'm just a little confused. Maybe I'm missing something. ... View more