About pavan1

Reeza · ‎01-11-2021

A data step can definitely do that, but you likely need a sort ahead of time. You can also look at the monotonic() function but SAS SQL doesn't support PARTITION. Enumeration is usually straightforward: https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/ If you need further help, post some example data, fake data is 100% fine, and what code you tried that isn't work. First and BY should definitely be able to replicate the order. If you have ties that will affect the results though, so it may not be exactly identical as SQL doesn't enforce any sort order on data sets.

SASKiwi · ‎03-16-2020

What do you mean by Reconcile statements? Please post examples.

pavan1 · ‎03-19-2019

THANK U SO MUCH KurtBremser 🙂 IT WORKED VERY WELL

pavan1 · ‎02-26-2019

Hello Reeza, how and where to define the STORE variable in the macro? Thanks in advance

derekx · ‎08-28-2018

ello Tom, run the same code,same sas 9.4 , I get the blanks in dte and size in my computer while my friend gets the right dte. Do you think what is the possibel cause for this? Thank you very much

pavan1 · ‎07-15-2018

thank you so much paige

pavan1 · ‎06-18-2018

thank you so much SASKiwi, it worked very well

pavan1 · ‎05-16-2018

Thank you so much Tom its perfectly working...!!!!

Kurt_Bremser · ‎01-30-2018

You do not need to "get" the properties of the csv file, you already have them in the data step that writes the csv. The other values are best determined by using operating system commands.

pavan1 · ‎05-15-2017

Hello abcd123 can you please share the code that u had used for this error. I'm facing the same issue. Thanks,

pavan1 · ‎05-09-2017

Hello, how to store column values with strings as macro variable? Ex: data dts; length l_dset $15 ttl $100; infile datalines delimiter='|'; input l_dset $ ttl $; datalines; LIS002|Illegible text LIS003|Duplicate AEs LIS004|Overlapping AEs LIS005|Duplicate Conmeds LIS015|Abacavir HSR and AE consistency LIS021|Compare age at screening LIS023|Laboratory date sample not in Chronolical order LIS024|Laboratory sample time is not the same for other samples collected at same visit LIS025|Multiple visit date LIS026|Multiple sample date LIS027|Duplicate Samples on same sample date LIS028|LowerCase Units ; run; I want only the ttl column from the dataset dts to be stored in macro variable and fetch those for later use. Please help me on this. i have been struggling with this. thanks, Pavan.Ch

pavan1 · ‎03-20-2017

Thank you so much scott...That was really helpful

RW9 · ‎03-07-2017

Why do you want to use export, that has no formatting functionality at all, not sure you can embed titles or anything like that. Is it because you want an XLSX file (maybe use libname excel then if you have > 9.3). I specifically used tagset to get this additional functionality. To do it your way you will need to create a temporary dataset with no observations, and set labels as the data you want, then output that, not easy and I don't have time to mess around with such a thing. If you have to do this which is "Excel" thinking and not SAS/Databasing, then dump your data out to CSV and use VBA to process it into the form you want, far simpler.

Online Status	Offline
Date Last Visited	‎01-20-2021 10:42 AM

Re: SQL Passthrough

SQL Passthrough

Re: Call SYMPUT using vname in Macro resulting in Apparent symbolic re...

Call SYMPUT using vname in Macro resulting in Apparent symbolic ref er...

Re: Converting XML to XLSX

Re: Handling missing time varaible

Handling missing time varaible

Re: Passing Multiple Parameters to Oracle Stored Procedure through SAS

Passing Multiple Parameters to Oracle Stored Procedure through SAS

Re: Program for Data Reconciliation Process

Re: Create Empty Sheet in a Workbook Using Excel Tagset

Re: Determining number of variables in a dataset

Re: How to split one string into multiple rows?

Re: What is the difference between PROC PRINT and PROC REPORT?

Re: How to extract year and month from date in SAS?

Re: SQL Passthrough

Re: Program for Data Reconciliation Process

Re: Call SYMPUT using vname in Macro resulting in Apparent symbolic re...

Re: Converting XML to XLSX

Re: Trying to get file properties using macros and put them in a data ...

Re: Handling missing time varaible

Re: Passing Multiple Parameters to Oracle Stored Procedure through SAS

Re: Adding prefix to the visit based on previous or upcoming visits

Re: UsingSAS9.3-Generate password protected ZIP file(csv file in) and ...

Re: WARNING: The quoted string currently being processed has become mo...

Re: How to store column values as macro variable?

Re: What is the difference between PROC PRINT and PROC REPORT?

Re: Print column of charcter strings to different sheets in Excel